Export not running even after validate the CATPROC (Doc ID 1592868.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Export is failing due to the below errors:

 

ORA-06512: at "SYS.DBMS_METADATA", line 9427
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_REPCAT_EXP.SCHEMA_INFO_EXP('ER',0,1,'10.01.00.00.00',newblock)
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_UTL"
ORA-06512: at "SYS.DBMS_REPCAT_EXP", line 87

 

First checked and found that the CATPROC component is INVALID.

 

After validating the CATPROC by running the scripts :

 

SQL> startup upgrade
SQL > @?/rdbms/admin/catalog.sql
SQL > @?/rdbms/admin/catproc.sql
SQL > @?/rdbms/admin/utlrp.sql

The export is still failed with the same error, when checked the invalid objects found the below:

 

SQL> select owner,object_type,object_name from dba_objects where status='INVALID';

OWNER                          OBJECT_TYPE         OBJECT_NAME
------------------------------ ------------------- ------------------------------
SYS                            PACKAGE BODY        DBMS_REPCAT_UTL
SYS                            PACKAGE BODY        DBMS_REPCAT_COMMON_UTL
SYS                            PACKAGE BODY        DBMS_REPCAT_SNA_UTL
SYS                            PACKAGE BODY        DBMS_DEFER_REPCAT
SYS                            PACKAGE BODY        DBMS_OFFLINE_SNAPSHOT
SYS                            PACKAGE BODY        DBMS_REPCAT_ADMIN
SYS                            PACKAGE BODY        DBMS_REPCAT_FLA_UTL
SYS                            PACKAGE BODY        DBMS_REPCAT_FLA

 

When trying to manually compilethe package body, got the below errors:

 

SQL> alter package SYS.DBMS_REPCAT_UTL compile body;

Warning: Package Body altered with compilation errors.

SQL> sho errors;
Errors for PACKAGE BODY SYS.DBMS_REPCAT_UTL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
20/5     PL/SQL: SQL Statement ignored
22/19    PL/SQL: ORA-00942: table or view does not exist
55/5     PL/SQL: SQL Statement ignored
56/19    PL/SQL: ORA-00942: table or view does not exist

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms