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

MOSC Banner

Migrating from 32bit to 64bit

edited Aug 20, 2021 9:58AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 7 commentsAnswered ✓

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:                                                   

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center