3 Replies Latest reply: Aug 12, 2010 7:56 AM by Damir Vadas RSS

    ORA-12570 on 11gR2 and Windows Server 2008 R2 (64-bit)

    user12945509
      Hi

      Were currently testing with 11gR2 on windows and we seem to have a problem - I suspect it to be a leak in the database.
      The database runs fine for a couple of days and then suddenly it refuses any connections.

      I've added pasted an extract of the corresponding alert*.log and .trc file below:
      alert_testing.log
      ***********************************************************************

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

      VERSION INFORMATION:
           TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
           Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
           Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
      Time: 03-JUL-2010 00:00:31
      Tracing not turned on.
      Tns error struct:
      ns main err code: 12570

      TNS-12570: TNS:Pakke reader-fejl
      ns secondary err code: 12560
      nt main err code: 0
      nt secondary err code: 0
      Sat Jul 03 00:00:39 2010
      nt OS err code: 0
      opiodr aborting process unknown ospid (5720) as a result of ORA-609
      Sat Jul 03 00:00:48 2010


      testing_ora_5720.trc
      Trace file c:\oracle\ora112\diag\rdbms\testing\testing\trace\testing_ora_5720.trc
      Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
      Windows NT Version V6.1
      CPU : 2 - type 8664, 2 Physical Cores
      Process Affinity : 0x0x0000000000000000
      Memory (Avail/Total): Ph:6256M/8027M, Ph+PgF:14217M/16053M
      Instance name: testing
      Redo thread mounted by this instance: 1
      Oracle process number: 46
      Windows thread id: 5720, image: ORACLE.EXE (SHAD)


      *** 2010-07-03 00:00:40.283
      *** CLIENT ID:() 2010-07-03 00:00:40.283
      *** SERVICE NAME:() 2010-07-03 00:00:40.283
      *** MODULE NAME:() 2010-07-03 00:00:40.283
      *** ACTION NAME:() 2010-07-03 00:00:40.283

      opiino: Attach failed due to ORA-12570

      I've also noticed a number of tnsping.exe processes, that seems to be stuck "somewhere".

      Any suggestions?
        • 1. Re: ORA-12570 on 11gR2 and Windows Server 2008 R2 (64-bit)
          fjfranken
          Your alert file says:
          opiodr aborting process unknown ospid (5720) as a result of ORA-609
          Sat Jul 03 00:00:48 2010
          testing_ora_5720.trc
          Trace file c:\oracle\ora112\diag\rdbms\testing\testing\trace\testing_ora_5720.trc
          What does that trace file say.

          Refer to MOS Note ID 987162.1: Fatal NI Connect 12560 And ORA-609 Opiodr Aborting Process Errors In The Alert Log
          This handles your problem

          Success:

          FJFranken
          My Blog: http://managingoracle.blogspot.com
          • 2. Re: ORA-12570 on 11gR2 and Windows Server 2008 R2 (64-bit)
            user12945509
            Well, I did include trace file (testing_ora_5720.trc) in my original post and Note 987162.1 didn't apply in my case (no user credentials had been changed).

            I more or less suspect the 'OracleDBConsole<service>' to be the root of all evil! At least in the Windows version of 11gR2.
            Rebooting the server did not help and it was suddenly almost impossible to login to the database.

            Stopping the service 'OracleDBConsole<service>' seemed to fix the problem (for now at least).
            I've also changed the startup type from the default 'automatic' to 'manual' and this definitely improved the server bootup time.

            I rarely use the web-interface anyhow (unless I really have to)...
            • 3. Re: ORA-12570 on 11gR2 and Windows Server 2008 R2 (64-bit)
              Damir Vadas
              1) This is confirmed on Linux OsCentOS 5.3 x86
              2) We alse haven't touch this server as well as TP
              3) For disabling "web" interfqace this is also good habbit:
              select dbms_xdb.gethttpport as "HTTP-Port", dbms_xdb.getftpport as "FTP-Port" from dual;
              begin
                  dbms_xdb.sethttpport('0');
                  dbms_xdb.setftpport('0');
              end;
              /
              select dbms_xdb.gethttpport as "HTTP-Port", dbms_xdb.getftpport as "FTP-Port" from dual;
              Regards,
              Damir

              Edited by: Damir Vadas on Aug 12, 2010 2:56 PM