Migrating from 32bit to 64bit
Dear All,
We are migrating the database 11.1.0.7 from 32bit to 64bit Linux system.
We are facing a problem to compile the invalid objects using utlrp.sql.
SQL> desc utl_recomp_errors;
Name Null? Type
----------------------------------------- -------- ----------------------------
OBJ# NUMBER
ERROR_AT TIMESTAMP(6)
COMPILE_ERR VARCHAR2(4000)
SQL> select * from utl_recomp_errors;
OBJ#
----------
ERROR_AT
---------------------------------------------------------------------------
COMPILE_ERR
--------------------------------------------------------------------------------
450625
23-NOV-12 05.32.23.422012 PM
ORA-04045: errors during recompilation/revalidation of SYS.GENINVALIDMETADATAEXC
EPTION
ORA-04055: Aborted: "GENINVALIDMETADATAEXCEPTION" formed a non-REF mutually-depe
ndent cycle with "GENOLAPIEXCEPTION".
ORA-06550: line 1, column 40:
OBJ#
----------
ERROR_AT
---------------------------------------------------------------------------
COMPILE_ERR
--------------------------------------------------------------------------------
PLS-00421: circular synonym 'PUBLIC.GENOLAPIEXCEPTION'
ORA-06550: line 0, column 0: