ORACLE ORA-07445 joet_create_root_thread_group ( ) + 140與BUG:19904315
最近客戶在打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
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
SYMPTOMSORA-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) -----
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
joet_create_root_thread_group <- joet_aux_thread_main
CHANGESApply 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) +
OR ONLY Patch 19282015 "ORACLE JAVAVM COMPONENT 11.2.0.3.1 DATABASE PSU (OCT2014) CAUSEThe 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ora-07445[kcbo_link_ql] ora-07445[kggckh]bug引發例項意外關閉GC
- Oracle ORA-07445 [0000000000000000] 錯誤分析Oracle
- ora-07445 ? oracle 10.2.0.3 ? patch 5648872Oracle
- 11.2.0.1bug引發的報錯:ORA-07445: exception encounteredException
- oracle bugOracle
- ora-07445 LATCHING DURING KSSADPM/KSSREM OPERATIONS,bug 4927533.REM
- Oracle Debug ---- oradebugOracle
- Oracle 11G OCP 1Z0-053 140Oracle
- Oracle 11G OCP 1Z0-052 140Oracle
- oracle之BUG 7497640Oracle
- Oracle groupby的bugOracle
- Oracle 12.2 RAC 報錯ora-600 ora-07445Oracle
- e-c 140
- Oracle JDK7 bug 發現、分析與解決實戰OracleJDK
- oracle10.2.0.1.0中與all_objects有關的bugOracleObject
- oracle10g中drop user造成ORA-07445 core dumpOracle
- oracle10.1.0.4.0bugOracle
- oracle的一個bugOracle
- ORACLE EVENT && ORADEBUGOracle
- Oracle oradebug命令Oracle
- Oracle srvctl的小bugOracle
- oracle的兩個bugOracle
- 題解:AT_abc140_e [ABC140E] Second Sum
- ORA-07445:oracle_[type: SIGSEGV, Address not mapped to object]OracleGseAPPObject
- oracle 11.2.0.4 rac節點異常當機之ORA-07445Oracle
- ORA-07445: [kkqtutlSetViewCols()+250]QTTLSView
- Oracle bug的手工修復Oracle
- oradebug分析oracle hangOracle
- (轉)Oracle EVENT && ORADEBUGOracle
- oracle ucm 的嚴重bugOracle
- ORACLE 自定義函式BUG?Oracle函式
- Oracle10.2.0.1的bugOracle
- Oracle的又一巨型bugOracle
- oracle 9i index bug?OracleIndex
- ORACLE 10.2.0.4 RAC BUG IN HPOracle
- Oracle內部錯誤:ORA-07445[_memcpy()+52] [SIGSEGV]一例OraclememcpyGse
- 140個Google面試問題Go面試
- ORA-07445: exception encountered: (一)Exception