Today I have been notified a problem with the following error
ORA-29260: network error: TNS:connection closed
ORA-06512: at “SYS.UTL_TCP”, line 28
ORA-06512: at “SYS.UTL_TCP”, line 257
ORA-06512: at line 12
There is a stored procedure that connects to a web service on another machine, when it run gives this error ORA-29260. In the other machine there is no database, so it should only be the process / program that makes the function of web service, after speaking with the systems people (in this case it is a windows server) shows that there is a windows service that is stopped, after startup the procedure in the database begins to work normally.
Not everything is the fault of the database…
HTH – Antonio NAVARRO