3 Replies Latest reply: Aug 17, 2012 6:50 PM by Osama_Mustafa RSS

    how to troubleshoot connect error 12547?

    848025
      ##### end of monitoring #####
      Fri Aug 17 15:08:25 2012


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

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

      VERSION INFORMATION:
      TNS for HPUX: Version 11.1.0.7.0 - Production
      Oracle Bequeath NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
      TCP/IP NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
      Time: 17-AUG-2012 15:08:25
      Tracing not turned on.
      Tns error struct:
      ns main err code: 12547

      TNS-12547: TNS:lost contact*
      ns secondary err code: 12560
      nt main err code: 0
      nt secondary err code: 0
      nt OS err code: 0
      ORA-609 : opiodr aborting process unknown ospid (4395_1)
        • 1. Re: how to troubleshoot connect error 12547?
          sb92075
          George wrote:
          ##### end of monitoring #####
          Fri Aug 17 15:08:25 2012


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

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

          VERSION INFORMATION:
          TNS for HPUX: Version 11.1.0.7.0 - Production
          Oracle Bequeath NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
          TCP/IP NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
          Time: 17-AUG-2012 15:08:25
          Tracing not turned on.
          Tns error struct:
          ns main err code: 12547

          TNS-12547: TNS:lost contact*
          ns secondary err code: 12560
          nt main err code: 0
          nt secondary err code: 0
          nt OS err code: 0
          ORA-609 : opiodr aborting process unknown ospid (4395_1)
          when was last time SQL*Net worked without error?
          What changed since then?

          does any FireWall exist on or between client & DB Server?
          • 2. Re: how to troubleshoot connect error 12547?
            damorgan
            Tracing not turned on.
            SB's question is on target but with respect to the above statement: Why not? If not now ... when?
            • 3. Re: how to troubleshoot connect error 12547?
              Osama_Mustafa
              Search On This Forum and you will find lot of Thread with same Error .