Invalid Replication Objects Like dbms_repcat Cannot Be Recompiled After Upgrade to 10.2
(Doc ID 459781.1)
Last updated on JANUARY 02, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |