问题描述
客户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执行时就会引发这个错误。
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。