6 Replies Latest reply: Mar 16, 2013 3:01 AM by Zalach RSS

    Fatal NI connect error 12537

    923210
      My DB version is 11.2.0.1.0
      OS: Microsoft WIndows (SP2)

      I get following message in alert.log of my production database

      Fatal NI connect error 12537, connecting to:
      (LOCAL=NO)

      VERSION INFORMATION:
           TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
           Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
           Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
      Time: 12-MAR-2012 14:46:36
      Tracing not turned on.
      Tns error struct:
      ns main err code: 12537

      TNS-12537: TNS:connection closed
      ns secondary err code: 12560
      nt main err code: 0
      nt secondary err code: 0
      nt OS err code: 0
      opiodr aborting process unknown ospid (4632) as a result of ORA-609


      Please help me to resolve the same
      For this i have added SQLNET.INBOUND_CONNECT_TIMEOUT=120 in sqlnet.ora
      and INBOUND_CONNECT_TIMEOUT_LISTENER=110 in my listener.ora file
      But it doesnot work after this i have inserted DIAG_ADR_ENABLED_LISTENER=off
      in listener.ora file but same also not working. Please help me to resolve the same