Oracle Application Freezing up
Oracle alert log has below error occurring frequently.  How to troubleshoot message?

Fatal NI connect error 12170.

VERSION INFORMATION: TNS for 32-bit Windows: Version 11.1.0.6.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production Time: xxxxTracing 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=xx.xx.x.xxx)(PORT=xxxx)) WARNING: inbound connection timed out (ORA-3136)



Software/Hardware used:
OOracle 11g, O.S., Windows Server 2003 Enterprise x64 SP2
ASKED: January 6, 2010  10:14 PM
UPDATED: January 7, 2010  2:42 PM

Answer Wiki:
It seems to be related to a client authentication problem (ora-03136). The authentication process was not completed before the timeout occurred. Here are a couple of links that may help you: <a href="http://www.dba-oracle.com/sf_ora_03136_inbound_connection_timed_out.htm">Inbound connection timed out tips</a> <a href="http://download.oracle.com/docs/cd/B28359_01/network.111/b28316/troublestng.htm">Troubleshooting Oracle Net Services</a>
Last Wiki Answer Submitted:  January 7, 2010  2:42 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _