重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-06575: Package or function LOGMNR$TAB_GG_TABF_PUBLIC is in an invalid state [打印本页]

作者: 刘泽宇 时间: 2023-11-5 13:22
标题: ORA-06575: Package or function LOGMNR$TAB_GG_TABF_PUBLIC is in an invalid state
SYMPTOMS
Extract abends with

2018-03-22 13:17:16 ERROR OGG-00663 OCI Error ORA-06575: Package or function LOGMNR$TAB_GG_TABF_PUBLIC is in an invalid state (status = 6575),

SQL erid, md_tab_colcount, md_tab_total_col_num, md_tab_iot, md_tab_iot_overflow, md_tab_partition, md_tab_subpartition, md_tab_xmltypetable, md_tab_objtype, md_tab_owner, md_tab_name, obj_flags, property

FROM TABLE (system.logmnr$tab_gg_tabf_public( :sid, :mdh, :object_id, :objv, to_number(:csn)))>.

CAUSE
In this case it was related to invalid dictionary objects.

SOLUTION
As per below info  CATPROC was in INVALID state:

COMP_ID COMP_NAME                                  VERSION STATUS MODIFIED                   SCHEMA
CATPROC Oracle Database Packages and Types 11.2.0.4.0  INVALID 18-DEC-2017 09:20:33 SYS

Refer below doc to make it valid:
         CATPROC Component Is Invalid and Will Not Validate (Doc ID 759635.1)

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)