468,532 Members | 1,678 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,532 developers. It's quick & easy.

Strange TNS problem

Hello there.
I have ORACLE 8.1.7.4 server on AIX 5.1.
I have another server (BIZTALK) with Oracle client 8.1.7.
The system is running ok. I can connect from the client on my database
server just fine.
However at certain stages we get the error below when it tries to open
a connection.Please note that we are loading 150,000 records currently
and we open / close a connection for every call.

ORA-12154: TNS:could not resolve service name
- at System.Data.OracleClient.OracleException.Check(Oci Handle
errorHandle, Int32 rc)
at System.Data.OracleClient.OracleInternalConnection. OpenOnLocalTransaction(String
userName, String password, String serverName, Boolean
integratedSecurity, Boolean unicode)
at System.Data.OracleClient.OracleInternalConnection. Open(Object
transact)
at System.Data.OracleClient.OracleConnection.OpenInte rnal(OracleConnectionString
parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at BiztalkAIC.BiztalkAIC.LaikiToBYNXRequest_AIC(XmlDo cument doc)
at BiztalkAIC.BiztalkAIC.ProcessMessage(String strDocument)
[0x0159] The server encountered a transport error while processing
the messaging port "Mainframe To Bynx", which uses a transport
component with a ProgID of "BiztalkAIC.BiztalkAIC".

[0x012b] A transmission attempt failed.

Do you have any idea how to troubleshoot this?

Thank you
Jul 19 '05 #1
2 5382
You open and close a connection on every call? Hopefully, you are using
some sort of connection pooling or you are creating a massive performance
problem. Try connecting with sqlplus. Looks like your tnsnames.ora file
does not have the right stuff in it.
Jim
"Demetris" <DM***@laiki.com> wrote in message
news:c5**************************@posting.google.c om...
Hello there.
I have ORACLE 8.1.7.4 server on AIX 5.1.
I have another server (BIZTALK) with Oracle client 8.1.7.
The system is running ok. I can connect from the client on my database
server just fine.
However at certain stages we get the error below when it tries to open
a connection.Please note that we are loading 150,000 records currently
and we open / close a connection for every call.

ORA-12154: TNS:could not resolve service name
- at System.Data.OracleClient.OracleException.Check(Oci Handle
errorHandle, Int32 rc)
at System.Data.OracleClient.OracleInternalConnection. OpenOnLocalTransaction(Str
ing userName, String password, String serverName, Boolean
integratedSecurity, Boolean unicode)
at System.Data.OracleClient.OracleInternalConnection. Open(Object
transact)
at System.Data.OracleClient.OracleConnection.OpenInte rnal(OracleConnectionStrin
g parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at BiztalkAIC.BiztalkAIC.LaikiToBYNXRequest_AIC(XmlDo cument doc)
at BiztalkAIC.BiztalkAIC.ProcessMessage(String strDocument)
[0x0159] The server encountered a transport error while processing
the messaging port "Mainframe To Bynx", which uses a transport
component with a ProgID of "BiztalkAIC.BiztalkAIC".

[0x012b] A transmission attempt failed.

Do you have any idea how to troubleshoot this?

Thank you

Jul 19 '05 #2
"Jim Kennedy" <ke****************************@attbi.net> wrote in message news:<VZlBb.346556$275.1142660@attbi_s53>...
You open and close a connection on every call? Hopefully, you are using
some sort of connection pooling or you are creating a massive performance
problem. Try connecting with sqlplus. Looks like your tnsnames.ora file
does not have the right stuff in it.
Jim


Connecting through sqlplus is fine. I tried it and it works. Any other ideas?
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Paul Drummond | last post: by
25 posts views Thread by Neil Ginsberg | last post: by
1 post views Thread by Sam Kong | last post: by
11 posts views Thread by Martin Joergensen | last post: by
8 posts views Thread by Dox33 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.