02 December 2013

Dictionary Corrupted TS mismatch HAB_RT_EXEC_PROC_RUN_METRICS

Failure trying to upgrade from 12.2.1 to 12.2.2

In the proces of upgrading the EBS beta 12.2.0 environment to version 12.2.2.  Have successfully applied all the tech stack

patches as well as the AD (15955263) and TXK (15946788) patches.

[applmgr@arjun appl]$ adop phase=prepare

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

 Please wait. Validating credentials...


RUN file system context file: /u01/ORAR122/fs2/inst/apps/R122_arjun/appl/admin/R122_arjun.xml
PATCH file system context file: /u01/ORAR122/fs1/inst/apps/R122_arjun/appl/admin/R122_arjun.xml

************* Start of  session *************
 version: 12.2.0
 started at: Thu Nov 28 2013 14:20:38

APPL_TOP is set to /u01/ORAR122/fs2/EBSapps/appl
  There is already a session which is incomplete. Details are:
      Session Id: 4
      Prepare phase status: R
      Apply phase status: N
      Cutover  phase status: N
      Abort phase status: N
      Session status: F
  [Note: Y denotes that the phase is done
         N denotes that the phase has not been completed
         X denotes that the phase is not applicable
         R denotes that the phase is running (in progress) or ran
         F denotes that the phase has failed
         P (is applicable only to APPLY phase) denotes atleast
            one patch is already applied for the session id
  Will continue with previous session
  Continuing
  [START 2013/11/28 14:21:11] adzdoptl.pl run
    ADOP Session ID: 4
    Phase: prepare
    Log file: /u01/ORAR122/fs_ne/EBSapps/log/adop/4/adop_20131128_142010.log
    [START 2013/11/28 14:21:17] prepare phase
Dictionary Corrupted:
Details are as follows:
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


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/warnings. Please check logfiles
        Log file: /u01/ORAR122/fs_ne/EBSapps/log/adop/4/adop_20131128_142010.log

adop exiting with status = 1 (Fail)
[applmgr@arjun appl]$

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size            2230072 bytes
Variable Size          452987080 bytes
Database Buffers     1660944384 bytes
Redo Buffers           21725184 bytes
Database mounted.
Database opened.
SQL> @utlirp.sql

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size            2230072 bytes
Variable Size          452987080 bytes
Database Buffers     1660944384 bytes
Redo Buffers           21725184 bytes
Database mounted.
Database opened.
SQL> @utlrp.sql

Reference : R12.2 Dictionary Corrupted While Running adop (Doc ID 1576086.1)

No comments: