5 Replies Latest reply: Apr 13, 2012 6:27 AM by 713555 RSS

    ORA-07445 Oracle 11g RAC

    773086
      Hello

      I have one problem with process procedure on Oracle 11g RAC (1,5 TB):

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2B8FA46785D2] [PC:0x347A879E07, strncmp()+55] [flags: 0x0, count: 1]
      Errors in file /oracle/app/base/diag/rdbms/p00sss/p00ssss2/trace/p00ssss2_j000_24724.trc (incident=306029):
      ORA-07445: exception encountered: core dump [strncmp()+55] [SIGSEGV] [ADDR:0x2B8FA46785D2] [PC:0x347A879E07] [Address not mapped to object] []

      How it fix?
      May be exist workaround?

      Thanks

      Edited by: laaam on 13.04.2012 14:58
        • 1. Re: ORA-07445 Oracle 11g RAC
          Helios-GunesEROL
          Hi;
          ORA-07445 internal error code,
          You are getting oracle internal error(ORA 600) which mean you could need to work wiht oracle support team. Please see below note, if its not help than i suggest log a sr:
          Troubleshoot an ORA-600 or ORA-7445 Error Using the Error Lookup Tool [ID 153788.1]

          Regard
          Helios
          • 2. Re: ORA-07445 Oracle 11g RAC
            761190
            Write please what is on your trace.
            p00ssss2_j000_24724.trc
            • 3. Re: ORA-07445 Oracle 11g RAC
              773086
              Trace file /oracle/app/base/diag/rdbms/p00ssss/p00ssss2/trace/p00ssss2_j000_24724.trc
              Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
              With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
              Data Mining and Real Application Testing options
              ORACLE_HOME = /oracle/app/base/db/11.2.0
              System name: Linux
              Node name: p00ssssdb02
              Release: 2.6.18-194.el5
              Version: #1 SMP Tue Mar 16 21:52:39 EDT 2010
              Machine: x86_64
              Instance name: p00ssss2
              Redo thread mounted by this instance: 2
              Oracle process number: 190
              Unix process pid: 24724, image: oracle@p00ssssdb02 (J000)


              *** 2012-04-13 14:11:40.418
              *** SESSION ID:(1421.28661) 2012-04-13 14:11:40.418
              *** CLIENT ID:() 2012-04-13 14:11:40.418
              *** SERVICE NAME:(SYS$USERS) 2012-04-13 14:11:40.418
              *** MODULE NAME:() 2012-04-13 14:11:40.418
              *** ACTION NAME:() 2012-04-13 14:11:40.418

              Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2B8FA46785D2] [PC:0x347A879E07, strncmp()+55] [flags: 0x0, count: 1]
              DDE: Problem Key 'ORA 7445 [strncmp()+55]' was flood controlled (0x6) (incident: 306029)
              ORA-07445: exception encountered: core dump [strncmp()+55] [SIGSEGV] [ADDR:0x2B8FA46785D2] [PC:0x347A879E07] [Address not mapped to object] []
              ssexhd: crashing the process...
              Shadow_Core_Dump = PARTIAL
              • 4. Re: ORA-07445 Oracle 11g RAC
                713555
                I hit similar issues with 7445's on RAC 11.2. patch/upgrade always fixed as they were always bugs. as above, hit the lookup tool mentioned for the exact fix. If you upgrade without proving its a known bug, it might be a new bug that hasnt been fixed yet so why bother.
                • 5. Re: ORA-07445 Oracle 11g RAC
                  773086
                  Thanks!