Monday, March 9, 2015

Remove TNS errors in alert log

https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=wa1za2jwf_57&_afrLoop=458983111660712..
 
  #       Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed out' Reported in 11g Alert Log (Doc ID 1286376.1)
DIAG_ADR_ENABLED = OFF
_______________________________________________________________________________________________________________________________ Listener log pktms

 <txt>08-OCT-2014 09:28:00 * (CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=pktms.kmausa.com)(CID=(PROGRAM=pmdtm)(HOST=hmadwh2)(USER=infadm))(INSTANCE_NAME=pktms1)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.120.6.75)(PORT=56850)) * establish * pktms.kmausa.com * 0
 </txt>

 alert log pktms
 Wed Oct 08 09:40:13 2014


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

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Solaris: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
  Time: 08-OCT-2014 09:40:13
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535

TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505

TNS-00505: Operation timed out
    nt secondary err code: 145
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.120.6.75)(PORT=56850))
 
_________________________________________________________________________________________________________________________________
 Listener log pktms
  <txt>08-OCT-2014 11:41:29 * (CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=pktms.kmausa.com)(CID=(PROGRAM=sqlplus@hmadwh2)(HOST=hmadwh2)(USER=oracle))(INSTANCE_NAME=pktms1)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.120.6.75)(PORT=56553)) * establish * pktms.kmausa.com * 0

 
  Alert log pktms
  Wed Oct 08 13:46:29 2014


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

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Solaris: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
  Time: 08-OCT-2014 13:46:29
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535

TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505

TNS-00505: Operation timed out
    nt secondary err code: 145
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.120.6.75)(PORT=56553))
 
 
  _______________________________________________________________________________________________________________________________

 

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...