ORACLE ORA-07445 joet_create_root_thread_group ( ) + 140與BUG:19904315

pingdanorcale發表於2023-03-13

最近客戶在打10.2.0.5.19 PSU補丁,執行@catbundle.sql psu apply,報ORA-07445:exception encountered: core dump [joet_create_root_thread_group()+140] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []錯誤。導致升級無法進行下去。

   檢視相關文件,只顯示如下資訊:

                                             

   沒有其他方案,只能備份資料庫,來嘗試上邊的方案,但是在邏輯備份時同樣遇到上邊的錯誤。無奈只能使用rman進行備份。

  根據1940340.1這個文件上的說可能是在應用PSU是導致的oracle buf。

   按照步驟如下:

 Create pfile=’/home/oracle/pfie.ora’ from spfile ;\

SQL> alter system set java_jit_enabled = FALSE; ---10g 不需要

SQL> alter system set "_system_trig_enabled"=FALSE;---

SQL> alter system set JOB_QUEUE_PROCESSES=0;

 

 

SQL> startup restrict

 

SQL> @catbundle.sql psu apply –跑完還原引數
 

SQL> alter system set "_system_trig_enabled"=TRUE;

SQL> alter system set JOB_QUEUE_PROCESSES=10;

重啟資料庫。

參考1940340.1文件

文件資訊如下:

 


ORA-07445[joet_create_root_thread_group()+145] After   Applying Patch 19791427 or Patch 19282015 ( 文件 ID 1940340.1)

轉到底部



In this Document


Symptoms


 


Changes

 


Cause

 


Solution

 


References

 
 

 

APPLIES TO:

Oracle   Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
  Information in this document applies to any platform.

SYMPTOMS

ORA-07445: exception encountered:   core dump [joet_create_root_thread_group()+145] is seen at startup.

The issue happens in CDC environments   and the following statement is seen in the alert log:

-----   Current SQL Statement for this session (sql_id=f03bykh6st1m5) -----
  BEGIN
        /* NOP UNLESS A TABLE OBJECT */
        IF dictionary_obj_type = 'TABLE'
        THEN
            sys.dbms_cdc_ipublish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,sysevent);
        END IF;
        END;
  ----- PL/SQL Stack -----
  ----- PL/SQL Call Stack -----
    object      line  object
    handle    number  name
  0xa7dd71c0        12  package body   SYS.DBMS_CDC_IPUBLISH

 

The error can also be seen from   MMON_SLAVE with an action of : JAVAVM JIT slave action without any SQL   statement referenced.

The call stack is:

joet_create_root_th   <- read_group <- joet_aux_thread_mai
          <- seoa_note_stack_out <- side <-   joet_thread_main <- sjontlo_initialize <- joe_enter_vm
           <- ioei_execute <- ioesub_EXECUTE   <- seoa_note_stack_out <- side <- ioe_execute
            <- side <- jox_ioe_execute <-   joxgrovel_jitsomeme <- thods <- joxgroveldrv
             <- thods <- joxjitexe <-   joxrdp_ <- joxrdp <- kebm_slave_main
              <- ksvrdp <- opirip <-   opidrv <- sou2o <- opimai_real
               <- ssthrdmain <- main   <- libc_start_main <- start

joet_create_root_thread_group   <- joet_aux_thread_main
          <- seoa_note_stack_outside   <- joet_thread_main <- sjontlo_initialize <- joe_enter_vm
         
 
 

CHANGES

Apply Patch 19791427 : COMBO OF OJVM   COMPONENT 11.2.0.3.1 DB PSU + DB PSU 11.2.0.3.12 (OCT2014)    

OR

Patch 19282015: ORACLE JAVAVM   COMPONENT 11.2.0.3.1 DATABASE PSU (OCT2014) +
  Patch 19121548: DATABASE PATCH SET UPDATE 11.2.0.3.12 (INCLUDES CPUOCT2014)

OR ONLY 

Patch 19282015 "ORACLE JAVAVM   COMPONENT 11.2.0.3.1 DATABASE PSU (OCT2014)

CAUSE

 The cause is a problem within   the Patch and it is investigated by Development in active bugs:

  - RECEIVE   ORA-07445[JOET_CREATE_ROOT_THREAD_GROUP()] AFTER APPLYING PATCH 19791427

  - ORA-7445 [JOET_CREATE_ROOT_THREAD_GROUP()+136]   ON SMON CACHE RECOVERY


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10201716/viewspace-2939381/,如需轉載,請註明出處,否則將追究法律責任。

相關文章