ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in DB Alert.log

In alert log file following error reported. We are going to resolve this error.

ERROR:-




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


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>




Supporting doc:- 


No comments:

Post a Comment

Thanks for reading till end. I hope this will help you more to improve your knowledge.

Now it's your turn!

What do you think? Share your experience in the comments box and subscribe for more interesting post.