SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-20922: COMMUNICATIONS EXCEPTION: ORA-29260: network error: TNS:connecti

34946Jun 3 2004 — edited Jun 18 2004

We are using UTL_TCP to post xml documents to a web service. We are getting the following error apparently randomly since the system was upgraded to HPUX 9.2:

ORA-20922: COMMUNICATIONS EXCEPTION: ORA-29260: network error: TNS:connection closed

This error is happening after the post has finished while the plsql procedure is waiting for a reply from the web service. The web service is showing that it successfully received the xml document, but then this error occurs.

I am unclear why this tcp communications exception specifies a TNS error. As I understand it, in 8i UTL_TCP used the JVM, so the JVM could be disconnecting from Oracle internally. In 9.2 isnt UTL_TCP based on native libraries? Does anyone have any knowledge of this error?

As I mentioned, it is sporadic, occuring once in a hundred tcp sessions.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 16 2004

Added on Jun 3 2004

5 comments

2,616 views