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