12 Replies Latest reply: Apr 5, 2013 7:28 PM by marksmithusa RSS

    DB was down with ora-7445

    sam995972
      Hi,
      oracle 9.2.0.8
      os:solaris

      one of my (OLAP) prod DB was down with ora-7445.can any one please help.

      thanks ,
      Sam.
        • 1. Re: DB was down with ora-7445
          KR10822864
          can you please post 20 lines alertlog content..

          hope it may be bug.
          • 2. Re: DB was down with ora-7445
            moreajays
            Sam,

            Check ..

            http://arjudba.blogspot.in/2011/05/database-crash-with-ora-07445-ndoprnt4.html

            Else

            Go to http://support.oracle.com
            refer to
            ORA-600/ORA-7445/ORA-700 Error Look-up Tool [ID 153788.1]

            Else

            Open SR

            Thanks,
            Ajay More
            http://www.moreajays.com
            • 3. Re: DB was down with ora-7445
              sam995972
              log info:

              Thu Apr 3 16 00:42:54 2013
              ARCH: Completed archiving log 3 thread 1 sequence 135381
              Thu Apr 3 16 00:43:03 2013
              Completed checkpoint up to RBA [0x210d6.2.10], SCN: 0x09f8.7497c3b
              Completed checkpoint up to RBA [0x210d5.2.10], SCN: 0x09f8.7497c35
              Completed checkpoint up to RBA [0x210d4.2.10], SCN: 0x09f8.747b09d
              Thu Apr 3 16 00:52:01 2013
              Errors in file /ora/admin/JP00DP/udump/JP00DP_ora_16715.trc:
              ORA-07445: exception encountered: core dump [0000000101CA36F8] [SIGBUS] [Invalid address alignment] [0xA9875D0008000B] [] []
              Thu Apr 3 16 00:52:06 2013
              Errors in file /ora/admin/JP00DP/bdump/JP00DP_pmon_17895.trc:
              ORA-07445: exception encountered: core dump [0000000101CA33F8] [SIGBUS] [Invalid address alignment] [0xA9875D0008000B] [] []
              Thu Apr 3 16 00:52:06 2013
              Errors in file /ora/admin/JP00DP/bdump/JP00DP_pmon_17895.trc:
              ORA-07445: exception encountered: core dump [0000000101E55984] [SIGBUS] [Invalid address alignment] [0xA9875D0008000B] [] []
              ORA-00602: internal programming exception
              ORA-07445: exception encountered: core dump [0000000101CA33F8] [SIGBUS] [Invalid address alignment] [0xA9875D0008000B] [] []
              Thu Apr 3 16 00:52:11 2013
              • 4. Re: DB was down with ora-7445
                Osama_Mustafa
                you database is De-Supported now, Refer to
                ORA-600/ORA-7445/ORA-700 Error Look-up Tool [ID 153788.1]
                • 5. Re: DB was down with ora-7445
                  KR10822864
                  sam995972 wrote:
                  log info:

                  Thu Apr 3 16 00:42:54 2013
                  ARCH: Completed archiving log 3 thread 1 sequence 135381
                  Thu Apr 3 16 00:43:03 2013
                  Completed checkpoint up to RBA [0x210d6.2.10], SCN: 0x09f8.7497c3b
                  Completed checkpoint up to RBA [0x210d5.2.10], SCN: 0x09f8.7497c35
                  Completed checkpoint up to RBA [0x210d4.2.10], SCN: 0x09f8.747b09d
                  Thu Apr 3 16 00:52:01 2013
                  Errors in file /ora/admin/JP00DP/udump/JP00DP_ora_16715.trc:
                  ORA-07445: exception encountered: core dump [0000000101CA36F8] [SIGBUS] [Invalid address alignment] [0xA9875D0008000B] [] []
                  Thu Apr 3 16 00:52:06 2013
                  Errors in file /ora/admin/JP00DP/bdump/JP00DP_pmon_17895.trc:
                  ORA-07445: exception encountered: core dump [0000000101CA33F8] [SIGBUS] [Invalid address alignment] [0xA9875D0008000B] [] []
                  Thu Apr 3 16 00:52:06 2013
                  Errors in file /ora/admin/JP00DP/bdump/JP00DP_pmon_17895.trc:
                  ORA-07445: exception encountered: core dump [0000000101E55984] [SIGBUS] [Invalid address alignment] [0xA9875D0008000B] [] []
                  ORA-00602: internal programming exception
                  ORA-07445: exception encountered: core dump [0000000101CA33F8] [SIGBUS] [Invalid address alignment] [0xA9875D0008000B] [] []
                  Thu Apr 3 16 00:52:11 2013
                  according to above info it is a BUG.
                  if you have extended support plz contact support.oracle.com
                  • 6. Re: DB was down with ora-7445
                    sam995972
                    thanks for all for quick reply.

                    any idea of bug why this error occuring?
                    • 7. Re: DB was down with ora-7445
                      695836
                      Hi,
                      Go to oracle support site and search for this exception.
                      • 8. Re: DB was down with ora-7445
                        KR10822864
                        sam995972 wrote:
                        thanks for all for quick reply.

                        any idea of bug why this error occuring?
                        i hope it may be BUG 8709146.

                        ora-7445 error arises due to inconsistency in transaction locking internally.

                        plz contact oracle support through SR.
                        • 9. Re: DB was down with ora-7445
                          moreajays
                          Sam,

                          You may get more details in MOS only

                          Similar error found in MOS but affected 10G fixed in 11g Jan 2013 PSU

                          PMON crashing with: ORA-07445: exception encountered: CORE Dump [kfiofib_detach()+84] [ID 744619.1]

                          Thanks,
                          Ajay More
                          http://www.moreajays.com
                          • 10. Re: DB was down with ora-7445
                            sam995972
                            do we have any workaround to avoid this issue ?
                            • 11. Re: DB was down with ora-7445
                              KR10822864
                              sam995972 wrote:
                              do we have any workaround to avoid this issue ?
                              check with support.oracle.com...

                              I would recommend you to upgrade the database to supported version of Oracle 11g...
                              • 12. Re: DB was down with ora-7445
                                marksmithusa
                                ORA-07445 is an unhandled exception stemming from the operating system. The lookup tool on MOS will be able to tell you if there's a patch to apply it (but you might not be able to access it) or a workaround.

                                You're running 9.2.0.8 - should you raise a Service Request, Oracle will tell you precisely the following:

                                'You're SOL until you upgrade to 11g'

                                I would follow their recommendation. It must be very lonely in the year 2002...