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)