ORA-3136 Errors from Oracle Database running in Windows server due to WinPrvSE.exe program

Last updated on JULY 16, 2018

Applies to:

Symptoms

++ Several "WARNING: inbound connection timed out (ORA-3136)" error messages in database alert log.

++ In Sqlnet.log,the similar errors were logged

***********************************************************************
Fatal NI connect error 12170.

 VERSION INFORMATION:
TNS for 64-bit Windows: Version 10.2.0.5.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 10.2.0.5.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 10.2.0.5.0 - Production
 Time: 09-JUL-2012 10:52:38
 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=xx.xx.xx.xx)(PORT=xxxx))


***********************************************************************

++ Database Listener log shows that the process "WinPrvSE.exe" was trying to login during the same time.

++ Enabling sqlnet server traces shows the following entries

Changes

 SYSTEM User Account password was changed recently.

Cause