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 and later
Information in this document applies to any platform.


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,'',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;

-------- -----------------------------------------------------------------
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


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