This content has been marked as final. Show 5 replies
It connection works regurlaly is strange, if fail from time to time maybe a network problem, high latences, networks cuts, etc. ask for help to your net admin.
Looking at the error codes
$ oerr ora 12535
12535, 00000, "TNS:operation timed out"
// *Cause: The requested operation could not be completed within the time out
// *Action: Look at the documentation on the secondary errors for possible
// remedy. See SQLNET.LOG to find secondary error if not provided explicitly.
// Turn on tracing to gather more information.
$ oerr ora 12606
12606, 00000, "TNS: Application timeout occurred"
// *Cause: A network session did not reach an application-defined stage
// within the allowed time interval.
// *Action: This is an error which does not normally appear at the high level.
// The action to take is application specific, and is detailed in the
// higher level error description.
$ oerr ora 03136
03136, 00000, "inbound connection timed out"
// *Cause: Inbound connection was timed out by the server because
// user authentication was not completed within the given time
// specified by SQLNET.INBOUND_CONNECT_TIMEOUT or its default value
// Action: 1) Check SQLNET and RDBMS log for trace of suspicious connections.
// 2) Configure SQL*NET with a proper inbound connect timeout value
// if necessary.
What is the value of your sqlnet.inbound_connect_timeout?
Have you checked the database alert log for related errors?
Running a sqlnet trace to try to find if these errors are coming from one source would likely be a necessary action if you want to get to the root cause.
HTH -- Mark D Powell ---
oradba11 wrote:the most common cause for TNS Timeout is a FireWall on or between client & DB Server.
I am wokring on oracle 11g and linux.We are finding following messages in alterlog files many time ,coming again and again ...
Is there any issue we are facing ...Is that we need to add some more parameters in our sqlnet.ora or other networking files..
Fatal NI connect error 12170.
TNS for Linux: Version 18.104.22.168.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 22.214.171.124.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 126.96.36.199.0 - Production
Time: 10-JAN-2013 19:28:15
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
Is this error only associated with a single remote IP#?
Can you confirm any successful remote session from this same IP#?
An attempt was made to talk to the database by a remote session. This attempt timed out. I tend to see this whenever the client (usually an app server) is having performance issues or network issues. Alternatively, it could be because you have a networking problem between the client and the database server.
Refer to1 person found this helpful
Troubleshooting ORA-3136: WARNING Inbound Connection Timed Out [ID 465043.1]