客户11.2 RAC环境出现ORA-7445[pevm_icd_call_common]错误。
详细错误信息为:
Mon Aug 20 17:31:49 2012 Exception [TYPE: SIGSEGV, Address NOT mapped TO object] [ADDR:0xD8] [PC:0x93F1E34, pevm_icd_call_common()+754] [flags: 0x0, COUNT: 1] Redo thread 1 internally disabled at seq 9 (SMON) Errors IN file /oracle/diag/rdbms/orcl/orcl2/trace/orcl2_m003_21741.trc (incident=12433): ORA-07445: exception encountered: core dump [pevm_icd_call_common()+754] [SIGSEGV] [ADDR:0xD8] [PC:0x93F1E34] [Address NOT mapped TO object] [] ORA-04067: NOT executed, package body "GGS.DDLREPLICATION" does NOT exist ORA-06508: PL/SQL: could NOT find program unit being called: "GGS.DDLREPLICATION" ORA-04067: NOT executed, package body "GGS.DDLREPLICATION" does NOT exist ORA-06508: PL/SQL: could NOT find program unit being called: "GGS.DDLREPLICATION" Incident details IN: /oracle/diag/rdbms/orcl/orcl2/incident/incdir_12433/orcl2_m003_21741_i12433.trc USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. Dumping diagnostic DATA IN directory=[cdmp_20120820173151], requested BY (instance=2, osid=21741 (M003)), summary=[incident=12433]. |
根据MOS文档ORA-03113: During an Upgrade whille Running Catuppst.sql ORA-6508 “GGUSER.DDLREPLICATION” in alert.log [ID 1506156.1],导致问题的原因是OGG的触发器影响了数据库的升级脚本的执行。
在升级过程中,应该先将OGG的触发器禁止掉:alter trigger sys.GGS_DDL_TRIGGER_BEFORE disable 然后再运行升级脚本,否则在catuppst.sql执行时就会引发这个错误。