Fatal NI connect error 12170 from your alert.log

Sunday, March 24, 2013 ·


Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
Time: 12-MAR-2013 10:39:03
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=TESTSVR)(PORT=43155))
WARNING: inbound connection timed out (ORA-3136)

 

Cause:
 The client failed to establish a connection and complete authentication in the time specified by the SQLNET.INBOUND_CONNECT_TIMEOUT parameter in the sqlnet.ora file. This error may be a result of network or system delays

Action:
You can set a higher value for INBOUND_CONNECT_TIMEOUT in sqlnet and listener.ora file or simple provide a value 0 to avoid these messages. This is just a warning saying that users were trying to connect and ultimately failed in connecting.

0 comments:

Search This Blog

About Me

I am an Oracle certified DBA and Apps DBA, totally loving my field of work. I have created this blog in order to save my studies in my field and share it with all.

View Asif Muhammad's profile on LinkedIn

Which is the most featurized database???

Followers

Site Traffic