Invalid Replication Objects Like dbms_repcat Cannot Be Recompiled After Upgrade to 10.2 (Doc ID 459781.1)

Last updated on MARCH 24, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 24-Mar-2012***

Symptoms

After upgrade the database from 8.1.7.4 to 10.2.0.3 . Some invalid objects is exist, and cannt be valid even after manual compile using " Alter Compile " statement.
The invalid objects may be like the following list :

SYSTEM.DBMS_REPCAT

SYS.DBMS_IAS_INST_UTL PACKAGE BODY
SYS.DBMS_OFFLINE_RGT PACKAGE BODY
SYS.DBMS_REPCAT_ADD_MASTER PACKAGE BODY
SYS.DBMS_REPCAT_ADMIN PACKAGE BODY
SYS.DBMS_REPCAT_MAS PACKAGE BODY
SYS.DBMS_REPCAT_RGT_CUST PACKAGE BODY
SYS.DBMS_REPCAT_SNA_UTL PACKAGE BODY
SYS.DBMS_REPCAT_UTL PACKAGE BODY
SYS.DBMS_REPCAT_UTL3 PACKAGE BODY
SYS.DBMS_REPUTIL PACKAGE BODY
SYS.V_$LE_STATX VIEW
SYS.X_$CLASS_STAT VIEW
SYS.X_$LE_STAT VIEW
SYS.X_$LOGMNR_CONTENTS VIEW
SYS.X_$LOGMNR_DICTIONARY VIEW

When compile :
=============
SQL> alter package SYS.DBMS_REPCAT_ADD_MASTER compile body ;

Warning: Package Body altered with compilation errors.

Elapsed: 00:00:00.24
15:06:07 SQL> show errors
Errors for PACKAGE BODY SYS.DBMS_REPCAT_ADD_MASTER:
321/16 PL/SQL: SQL Statement ignored
326/24 PL/SQL: ORA-00904: "RO"."GENPACKAGE": invalid identifier
330/7 PL/SQL: Statement ignored
330/64 PLS-00364: loop index variable 'REC' use is invalid
333/9 PL/SQL: SQL Statement ignored
335/27 PL/SQL: ORA-00904: "REC"."ONAME": invalid identifier
335/27 PLS-00364: loop index variable 'REC' use is invalid
341/9 PL/SQL: Statement ignored
342/12 PLS-00364: loop index variable 'REC' use is invalid
343/9 PL/SQL: Statement ignored
344/12 PLS-00364: loop index variable 'REC' use is invalid

Changes

Database has been upgraded from 8.1.7.4 to 10.2.0.3

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