Invalid logmnr functions after rollback of GG recommended patches for 11.2.0.4
APPLIES TO:
Oracle GoldenGate - Version 12.1.2.0.0 and laterInformation in this document applies to any platform.
SYMPTOMS
After rolling back one of the recommended patches for Golden Gate (Doc ID 1557031.1) from an 11.2.0.4 database the following objects may become invalid:
FUNCTION SYSTEM.LOGMNR$TAB_GG_TABF_PUBLIC
FUNCTION SYSTEM.LOGMNR$COL_GG_TABF_PUBLIC
Running scripts $ORACLE_HOME/rdbms/admin/utlrp.sql or $ORACLE_HOME/rdbms/admin/prvtlmcb.plb will not fix the problem.
CAUSE
Types LOGMNR$TAB_GG_REC and LOGMNR$COl_GG_REC don't get recreated after running the post-deinstall script because of dependencies with other objects.
SOLUTION
After running the post-deinstall script execute the following as sys:
sqlplus / as sysdba
drop type system.LOGMNR$TAB_GG_RECS;
drop function system.LOGMNR$TAB_GG_TABF_PUBLIC;
drop type system.LOGMNR$COL_GG_RECS;
drop function system.LOGMNR$COL_GG_TABF_PUBLIC;
drop type SYSTEM.LOGMNR$SEQ_GG_RECS;
drop type SYSTEM.LOGMNR$KEY_GG_RECS;
@$ORACLE_HOME/rdbms/admin/prvtlmcb.plb
This will remove the objects that depend on the above TYPES and will recreate all the objects again.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26655292/viewspace-2141266/ ，如需转载，请注明出处，否则将追究法律责任。
