Migrating from 32bit to 64bit

Nov 25, 2012 4:13AM

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:

Install, Upgrade, Clone, Patch - EBS (MOSC)