ITPub博客

首页 > 数据库 > Oracle > Invalid logmnr functions after rollback of GG recommended patches for 11.2.0.4

Invalid logmnr functions after rollback of GG recommended patches for 11.2.0.4

Oracle 作者:q418441117 时间:2017-06-26 16:12:15 0 删除 编辑

APPLIES TO:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Information 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博客 ” ,链接:http://blog.itpub.net/26655292/viewspace-2141266/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-09-11

  • 博文量
    201
  • 访问量
    375229