| TNS connection error [message #377513] |
Tue, 23 December 2008 05:18  |
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 #378146 is a reply to message #377795] |
Mon, 29 December 2008 02:38  |
Frank Naude
Messages: 4581
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. |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
