Home » RDBMS Server » Networking and Gateways » TNS connection error (Unix/Windows)
TNS connection error [message #377513] Tue, 23 December 2008 05:18 Go to next message
samgic
Messages: 2
Registered: December 2008
Location: Kuwait
Junior Member

There is a Win 2003 server with IIS server running different web applications open to internet users, which connects to 10g R2 DB in Unix.

Suddenly the applications were not fetching any data from backend. We tried connecting to the Oracle DB through SQL plus from Windows server. It was returning same TNS errror, that was seen in web applications. However DB was up and running and allowing connections from other machines. Some other client server and multi tier applications connecting to the same DB were working fine. So there was nothing wrong with DB we observed. We tried restarting the Windows 2003 server running IIS. Upon restarting connection to Oracle was fine and web applications started accessing DB again.

Windows log shows no error. Any idea on why it happens?

Thanks in advance.
Re: TNS connection error [message #377521 is a reply to message #377513] Tue, 23 December 2008 05:33 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
It would help if you post the exact error as well.
Re: TNS connection error [message #377795 is a reply to message #377521] Thu, 25 December 2008 03:17 Go to previous messageGo to next message
samgic
Messages: 2
Registered: December 2008
Location: Kuwait
Junior Member

We faced the same problem again today. Win 2003 with IIS stopped communicating with 10g R2 in HP Unix. When we tried through SQL we get Ora 12560 error message.

Thanks
Re: TNS connection error [message #378146 is a reply to message #377795] Mon, 29 December 2008 02:38 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
This is what you need to do:

12560, 00000, "TNS:protocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors. For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.
Previous Topic: listner error
Next Topic: Listener problem - ORA-12514
Goto Forum:
  


Current Time: Fri Mar 29 01:52:02 CDT 2024