0 Replies Latest reply on Jan 31, 2016 12:21 PM by Karthik Appsys

    MetaData has not been upgraded after upgrade - kopm$

    Karthik Appsys

      Dear Legends,

       

      Current Env: R12.1.3 with 12.1.0.2 Database.  Previous Env: R12.0.6 with 10.2.0.3

      We have been hitting at the following issue:

       

      We upgraded our R12 Database from 10.2.0.3 to 10.2.0.5 and to 12.1.0.2. Today we came across to see that our Database is 32 or 64 bit and we already migrated the Database from 32 to 64 bit. But the below query shows

       

      SQL> select metadata from kopm$;

       

       

      METADATA

      --------------------------------------------------------------------------------

      0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A05050505050405

      0607080823432323081123081141B0230083036707D0030000000000000000000000000000000000

      0000000000000000000000000000000000000000

       

      As per this doc it is a 32 bit, seems the metadata has not been updated. Or something else is wrong ?

       

      But our Configurations are showing 64bit because we installed 64bit software and upgraded the database. I would like to know the solution for this issue.

       

      DBUPGDIAG.SQL Log

      =========================================

      Duplicate Objects Owned by SYS and SYSTEM

      =========================================

      Querying duplicate objects ....

       

      OBJECT_NAME                              OBJECT_TYPE

      ---------------------------------------- ----------------------------------------

      SUBOBJECT_NAME                                                                                                                    OBJECT_ID

      -------------------------------------------------------------------------------------------------------------------------------- ----------

      HELP                                     TABLE                      975807

      HELP_TOPIC_SEQ                           INDEX

                                                                                                                                           975808

      WPG_DOCLOAD                              PACKAGE

                                                                                                                                            21869

      WPG_DOCLOAD                              PACKAGE BODY

                                                                                                                                            21871

       

      DOC>

      DOC>################################################################################

      DOC>Below are expected and required duplicates objects and OMITTED in the report .

      DOC>

      DOC>Without replication installed:

      DOC>INDEX    AQ$_SCHEDULES_PRIMARY

      DOC>TABLE    AQ$_SCHEDULES

      DOC>

      DOC>If replication is installed by running catrep.sql:

      DOC>INDEX    AQ$_SCHEDULES_PRIMARY

      DOC>PACKAGE    DBMS_REPCAT_AUTH

      DOC>PACKAGE BODY    DBMS_REPCAT_AUTH

      DOC>TABLE    AQ$_SCHEDULES

      DOC>

      DOC>If any objects found please follow below article.

      DOC>Note 1030426.6 How to Clean Up Duplicate Objects Owned by SYS and SYSTEM schema

      DOC>Read the Exceptions carefully before taking actions.

      DOC>

      DOC>################################################################################

      DOC>#

       

      Thanks,

      Karthik