How to resolve ORA-609 TNS-12537 and TNS-12547 or TNS-12170.

by

In alert log file  error ORA-609 TNS-12537 and TNS-12547 or TNS-12170 reported. We are going to resolve this error after change parameter in sqlnet.ora file. TNS-12537: TNS:connection closed

ERROR:-

 

ORA-609 TNS-12537

 

Alert log shows below error.

 

Fatal NI connect error 12537, connecting to:

 (LOCAL=NO)

Thu Oct 29 11:14:13 2020

Thu Oct 29 11:14:13 2020

TNS-12537: TNS:connection closed

 VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.4.0 – Production

        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 – Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 – Production

  Time: 29-OCT-2020 10:07:58

  Time: 29-OCT-2020 10:07:58

  Tracing not turned on.

  Tns error struct:

  Tracing not turned on.

    ns main err code: 12537

  Tns error struct:

TNS-12537: TNS:connection closed

opiodr aborting process unknown ospid (24729) as a result of ORA-609

TNS-12537: TNS:connection closed

    nt secondary err code: 0

    nt secondary err code: 0

    ns secondary err code: 12560

    nt main err code: 0

    nt secondary err code: 0

VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.4.0 – Production

        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 – Production

   TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 – Production

    ns main err code: 12537

    ns main err code: 12537

    ns main err code: 12537

    ns main err code: 12537

    ns main err code: 12537

  Time: 29-OCT-2020 11:14:23

 

Modify sqlnet.ora:-

 
The above error will eliminate by increasing SQLNET.INBOUND_CONNECT_TIMEOUT in sqlnet.ora and listener file.
 
 
To change INBOUND_CONNECT_TIMEOUT follow below steps.
 
 
$cd $TNS_ADMIN     –> ($RDBMS_HOME/network/admin)
 
 
 
sqlnet.ora :- 
 
 
The default setting for the SQLNET.INBOUND_CONNECT_TIMEOUT parameter is 60 seconds.  
 
 
SQLNET.INBOUND_CONNECT_TIMEOUT =180
 
 
listener.ora:-
 
INBOUND_CONNECT_TIMEOUT_ACE = 160
 
Once you update the value need to be reload the listener.
 
$lsnrctl reload <listener_name>
 
 

References:-

Alert.log shows ORA-609 with TNS-12537: TNS:connection closed (Doc ID 1538717.1)

Leave a Comment