Dictionary Corrupted while running ADOP Prepare phase: TS mismatch error

Issue

ADOP Prepare phase completed in error and would not complete.

Command Issued:

adop phase=prepare workers=6

Error Description

[START 2014/11/12 18:35:04] prepare phase

      [UNEXPECTED]Dictionary Corrupted:

      [START 2014/11/12 18:35:14] Data Dictionary Curruption Details

        OWBSYS          HAB_RT_EXEC_PROC_RUN_METRICS                   OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

        OWBSYS          WB_RTI_OBJECT_CATALOG                          OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

        OWBSYS          UAB_RT_EXEC_PROCESS                            OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

        OWBSYS          UAB_RT_EXEC_PROCESS_RUNS                       OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

        OWBSYS          UAB_RT_EXEC_PROC_RUN_COUNTS                    OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

        OWBSYS          UAB_RT_EXEC_PROC_RUN_METRICS                   OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

        PUBLIC          WB_OLAP_AW_PRECOMPUTE                          OWBSYS          WB_OLAP_AW_PRECOMPUTE                          TS mismatch: 23-SEP-10 05:17:34 26-NOV-12 18:48:25

        OWBSYS          ALL_RT_INSTALLATIONS                           OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

        OWBSYS          RAB_RT_INSTALLATIONS                           OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

        OWBSYS          HAB_RT_EXEC_PROCESS                            OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

        OWBSYS          HAB_RT_EXEC_PROCESS_RUNS                       OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

        OWBSYS          HAB_RT_EXEC_PROC_RUN_COUNTS                    OWBSYS          WB_RT_VERSION                                  TS mismatch: 16-SEP-10 09:13:44 26-NOV-12 18:48:19

      [END   2014/11/12 18:35:14] Data Dictionary Curruption Details

      NOTE: Please contact Oracle Support and request them to open a bug against

            Oracle Application Install(166), Component Online Patching(OP).

          [ERROR]     Prepare phase completed with errors or warnings. Please check logfiles.

          Log file: /u01/oracle/VIS/fs_ne/EBSapps/log/adop/7/adop_20141112_183234.log

[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.

adop exiting with status = 1 (Fail)

Resolution

The root cause of this issue is a TimeStamp Mismatch. Follow any of the below mentioned solutions:

SOLUTION-1

Step 1. Shutdown the database and open it in upgrade mode.

sqlplus "/ as sysdba"

shutdown immediate

startup upgrade

Step 2. From the same sqlplus session, run utlirp script:

@utlirp.sql

Step 3. Bounce the database again and open it in normal mode. From the same sqlplus session:

shutdown immediate

startup

Step 4. From the same sqlplus session, run the utlrp.sql from $ORACLE_HOME/rdbms/admin.

@utlrp.sql

Step 5. Re-run adop and you will not get the above error now.

SOLUTION-2

The above utlirp.sql and utlrp.sql scripts takes long time to finish. As a short-cut you may want to follow the below mentioned solution:

Step 1. Login to SQL prompt using the following user:

conn owbsys/owbsys

Step 2. Run the following script to check whether there are any invalid objects:

@$ORACLE_HOME/rdbms/admin/utldtchk.sql

This will most probably return a list of all above packages, views and functions totalling around 12 to 14 invalid objects.

Step 3. Now run the following from the SQL prompt one-by-one (make sure you have logged in SQL using user 'owbsys'). This will recompile all the objects and will help in removing the timestamp issue:

alter view ALL_RT_INSTALLATIONS compile;

alter view RAB_RT_INSTALLATIONS compile;

alter view HAB_RT_EXEC_PROCESS compile;

alter view HAB_RT_EXEC_PROCESS_RUNS compile;

alter view HAB_RT_EXEC_PROC_RUN_COUNTS compile;

alter view HAB_RT_EXEC_PROC_RUN_METRICS compile;

alter view UAB_RT_EXEC_PROCESS compile;

alter view UAB_RT_EXEC_PROCESS_RUNS compile;

alter view UAB_RT_EXEC_PROC_RUN_COUNTS compile;

alter view UAB_RT_EXEC_PROC_RUN_METRICS compile;

alter function WB_OLAP_AW_PRECOMPUTE compile;

drop public synonym WB_OLAP_AW_PRECOMPUTE;

create public synonym WB_OLAP_AW_PRECOMPUTE for OWBSYS.WB_OLAP_AW_PRECOMPUTE;

alter package WB_RTI_OBJECT_CATALOG compile;

alter package WB_RTI_OBJECT_CATALOG compile body;

Step 4. If you get the following error while running the above issue then follow my troubleshooting notes on this blog:

alter view UAB_RT_EXEC_PROC_RUN_COUNTS compile

*

ERROR at line 1:

ORA-04023: Object alter view UAB_RT_EXEC_PROC_RUN_COUNTS compile

Step 5. Now rerun the above script to make sure there are no invalid objects:

@$ORACLE_HOME/rdbms/admin/utldtchk.sql

Step 6. Next step is to login with your Application Tier user and restart the 'prepare' phase using adop:

adop phase=prepare restart=yes

Environment

  • Oracle E-Business Suite Release 12.2.4
  • Oracle Linux 5.7
FREE Sampl...
Syntax error: Invalid parameter 'VMs\Oracle' while...