5 Replies Latest reply: May 30, 2013 6:26 AM by josephart RSS

    startup db get ORA-07445 [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x1072D9

    josephart
      Hi

      When i tried to run $OH/rdbms/admin/utlirp.sql on the database EBS R12 (11.1.0.7) i got following error :

      ORA-03113: end-of-file on communication channel
      Process ID: ****
      Session ID: 1089 Serial number: ****

      In alert_log file following error generated:

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x1072D99D8, hshget1()+120]
      Incident 126532 created, dump file: incdir_126532/devgl_ora_27722_i126532.trc
      ORA-07445: exception encountered: core dump [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x1072D99D8] [Address not mapped to object] []


      In server trace file following error generated:
      ORA-07445: exception encountered: core dump [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x1072D99D8] [Address not mapped to object] []
      ====== Dump for incident 126532 (ORA 7445 [hshget1()+120]) ======
      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x1072D99D8, hshget1()+120]

      ssexhd: crashing the process...
      Shadow_Core_Dump = PARTIAL

      I have followed note 1331237.1, 959957.1, can't solve my problem.

      Please help

      Thanks
        • 1. Re: startup db get ORA-07445 [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x1072D9
          Hussein Sawwan-Oracle
          josephart wrote:
          Hi

          When i tried to run $OH/rdbms/admin/utlirp.sql on the database EBS R12 (11.1.0.7) i got following error :

          ORA-03113: end-of-file on communication channel
          Process ID: ****
          Session ID: 1089 Serial number: ****

          In alert_log file following error generated:

          Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x1072D99D8, hshget1()+120]
          Incident 126532 created, dump file: incdir_126532/devgl_ora_27722_i126532.trc
          ORA-07445: exception encountered: core dump [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x1072D99D8] [Address not mapped to object] []


          In server trace file following error generated:
          ORA-07445: exception encountered: core dump [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x1072D99D8] [Address not mapped to object] []
          ====== Dump for incident 126532 (ORA 7445 [hshget1()+120]) ======
          Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x1072D99D8, hshget1()+120]

          ssexhd: crashing the process...
          Shadow_Core_Dump = PARTIAL

          I have followed note 1331237.1, 959957.1, can't solve my problem.

          Please help

          Thanks
          Did you start the database with the upgrade option before running utlirp.sql script?

          What has changed recently in the database (i.e. upgrade, patches, ..etc)?

          If you have a backup, please restore the database and try the same script again.

          Since none of MOS docs helped then I would suggest you log a SR.

          Thanks,
          Hussein
          • 2. Re: startup db get ORA-07445 [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x1072D9
            josephart
            Hi Husein,

            Thank you for update.

            1. Yes, I'm starting database with STARTUP UPGRADE
            2. I do not change patches/upgrade

            I ran utlirp.sql when I compiled one of package invalid, I got message "PLS-00801: internal error [1401] while compiling Package body"
            I ran utlirp.sql without disable parameter job_queue_processes and aq_tm_processes.
            The database stop when I ran that scripts and can't startup upgrade or startup normal.

            Thanks
            • 3. Re: startup db get ORA-07445 [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x1072D9
              josephart
              Hi Husein,

              Here the message on trace server :

              *** MODULE NAME:(sqlplus@bmsundev.bimafinance.com (TNS V1-V3)) 2013-05-29 10:04:52.665
              *** ACTION NAME:() 2013-05-29 10:04:52.665
              Only allocated 8 recovery slaves (requested 16)
              Using 139 overflow buffers per recovery slave
              Thread 1 checkpoint: logseq 51, block 2, scn 80942381
              on-disk rba: logseq 51, block 1181, scn 80969432
              start recovery at logseq 51, block 1181, scn 80969432
              *** 2013-05-29 10:04:52.827
              Started resilvering redo thread 1 seq 51: blocks 1181-1185
              *** 2013-05-29 10:04:52.879
              Completed resilvering redo thread 1 seq 51
              ==== Redo read statistics for thread 1 ====
              Total physical reads (from disk and memory): 4096Kb
              -- Redo read_disk statistics --
              Read rate (ASYNC): 2Kb in 0.21s => 0.01 Mb/sec
              Longest record: 0Kb, moves: 0/8 (0%)
              Change moves: 0/2 (0%), moved: 0Mb
              Longest LWN: 1Kb, moves: 0/2 (0%), moved: 0Mb
              Last redo scn: 0x0000.04d37edc (80969436)
              ----------------------------------------------
              ----- Recovery Hash Table Statistics ---------
              Hash table buckets = 65536
              Longest hash chain = 1
              Average hash chain = 3/3 = 1.0
              Max compares per lookup = 1
              Avg compares per lookup = 9/15 = 0.6
              ----------------------------------------------
              *** 2013-05-29 10:04:52.915
              KCRA: start recovery claims for 3 data blocks
              *** 2013-05-29 10:04:52.916
              KCRA: blocks processed = 3/3, claimed = 3, eliminated = 0
              *** 2013-05-29 10:04:52.990
              Recovery of Online Redo Log: Thread 1 Group 1 Seq 51 Reading mem 0
              *** 2013-05-29 10:04:52.991
              Completed redo application of 0.00MB
              *** 2013-05-29 10:04:53.010
              Completed recovery checkpoint
              IR RIA: redo_size 2560 bytes, time_taken 23 ms
              ----- Recovery Hash Table Statistics ---------
              Hash table buckets = 65536
              Longest hash chain = 1
              Average hash chain = 3/3 = 1.0
              Max compares per lookup = 1
              Avg compares per lookup = 12/12 = 1.0
              ----------------------------------------------
              *** 2013-05-29 10:04:55.119
              Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x1072D9
              9D8, hshget1()+120]
              Incident 136133 created, dump file: /oracle/devdb/db/tech_st/11.1.0/admin/devgl_bmsundev/diag/rdbms/devgl/devgl/incident/incdir_136133/devgl_ora_758_i136133.trc
              ORA-07445: exception encountered: core dump [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x1072D99D8] [Address not mapped to object] []

              ssexhd: crashing the process...
              Shadow_Core_Dump = partial

              thanks
              • 4. Re: startup db get ORA-07445 [hshget1()+120] [SIGSEGV] [ADDR:0x18] [PC:0x1072D9
                Hussein Sawwan-Oracle
                Incident 136133 created, dump file: /oracle/devdb/db/tech_st/11.1.0/admin/devgl_bmsundev/diag/rdbms/devgl/devgl/incident/incdir_136133/devgl_ora_758_i136133.trc
                Please log a SR and upload the database log file along with the above trace file.

                Thanks,
                Hussein