Upgrade 11.2.0.1 To 11.2.0.2 Fails With ORA-7445 [Pevm_icd_call_common()+754] [ID 1313738.1] | |||||
| |||||
Modified 22-SEP-2011 Type PROBLEM Status PUBLISHED |
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.
This document is a replacement for 1313738.1 which has been deleted
Symptoms
Upgrade post install script fails with errors:
ORA-07445: exception encountered: core dump [pevm_icd_call_common()+754] [SIGSEGV] [ADDR:0xD8] [PC:0x9153AF8] [Address not mapped to object] []
ORA-04067: not executed, package body "GG.DDLREPLICATION" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "GG.DDLREPLICATION"
ORA-04067: not executed, package body "GG.DDLREPLICATION" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "GG.DDLREPLICATION"
Changes
Applied the 11.2.0.2 patchset
Cause
Error is caused by a Golden Gate Replication DDL trigger where the packages being referenced are invalid
OWNER OBJECT_NAME OBJECT_TYPE STATUS
--------------- ------------------------------ ------------------- -------
GG DDLORA_GETBINOBJECTCOUNT FUNCTION VALID
GG DDLORA_GETERRORSTACK FUNCTION VALID
GG DDLORA_GETTABLESPACESIZE FUNCTION INVALID
GG DDLORA_VERIFYDDL FUNCTION INVALID
GG DDLREPLICATION PACKAGE VALID
GG DDLREPLICATION PACKAGE BODY INVALID
GG DDLVERSIONSPECIFIC PACKAGE INVALID
Solution
Disable GGS_DDL_TRIGGER_BEFORE trigger
sql> alter trigger sys.GGS_DDL_TRIGGER_BEFORE disable ;
Then re-run the post install scripts or restart from the last script before the error occurred, whichever is more appropriate.
If the ORA-7445 error occurs on startup then add the following parameter to the initialization file before starting up:
"_system_trig_enabled"=false
and then follow the steps above. Ensure that the parameter is set back to 'true' when the problem has been corrected.
References
Products
|
转载于:https://blog.51cto.com/mrdba/922152