Geek Answers Handbook

ORA-12560: TNS: protocol adapter error

We have a network application with a dot and it connects to Oracle and retrieves the data and moves to the SQL server. he worked very well. just started giving error ORA-12560: TNS: protocol adapter error . Tnsping also gives this error. but if I stop this application and tnsping, then its success. running the application again within the first 10 minutes, it works fine and gets the same error. every 5 seconds this application connects to the Oracle databse.

any idea what the mistake is; and how to solve. there are many questions here, but he did not find instruction.

rate your comments on this request

+4
source share
1 answer

It seems you have some kind of resource leak. Are you closing connections correctly?

Also, as ar comment says, why don't you just open this connection? IIRC Connectivity is an expensive operation in any DBMS.

In addition, from the documentation:

ORA-12560 - TNS: protocol adapter error
Reason . A common protocol adapter error has occurred.
Action . Check the addresses used for the correct protocol specification. Before reporting this error, review the error stack and check for transport errors at a lower level. Turn on tracking and retry for more information. Disable tracing when the operation is complete.

UPDATE :
The problem may be caused by the overflow of the Windows event log. Check out Oracle events here:
Start Menu => Control Panel => "Administrative Tools" => "View Events"
You must either clear the log manually or increase its size

0
source

More articles:


All Articles