R12.2 Apps DBA. Powered by Blogger.

R12.2 Dictionary Corrupted While Running adop TS Mismatch Error

No comments :
adop phase=prepare failed with the following errors
[STATEMENT] Updating prepare_status=R for session_id : 19
[UNEXPECTED]Dictionary Corrupted:
[START 2014/07/07 07:22:18] Data Dictionary Curruption Details
APPS OE_CREDIT_CHECK_ORDER_PVT V_20140516_0452 APPS OE_CREDIT_CHECK_UTIL V_20140516_0452 P Status: 5
APPS OKL_PAY_CURE_REFUNDS_PVT_W V_20140516_0452 APPS OKL_PAY_CURE_REFUNDS_PVT V_20140516_0452 P Status: 5
APPS OKL_PAY_CURE_REFUNDS_PUB_W V_20140516_0452 APPS OKL_PAY_CURE_REFUNDS_PUB V_20140516_0452 P Status: 5
APPS OKL_PAY_CURE_REFUNDS_PUB_W V_20140516_0452 APPS OKL_PAY_CURE_REFUNDS_PVT V_20140516_0452 P Status: 5
APPS INV_OPM_LOT_MIGRATION V_20140516_0452 APPS INV_LOT_API_PUB V_20140516_0452 TS mismatch: 12-JUN-14 16:50:54 29-JUN-14 14:42:12
APPS INV_LOT_ATTR_PUB V_20140516_0452 APPS INV_LOT_API_PUB V_20140516_0452 TS mismatch: 12-JUN-14 16:50:54 29-JUN-14 14:42:12
APPS INV_LOT_ATTR_PUB V_20140516_0452 APPS MTL_LOT_UOM_CONV_PVT V_20140516_0452 P Status: 5
Solution:
Fix Timestamp Mismatch Issues for Synonym, View, Package and Package Body
Note: This step is mandatory for New Vision Installation Customers. It is not necessary for new PROD installation customers.
Oracle strongly recommends all upgrade customers to execute this step to fix Timestamp mismatch issues in the database before starting to use the online patching utility (adop).
Upgrade Customers can refer to section 'Fix data dictionary or time stamp mismatch' in My Oracle Support Knowledge Document 1531121.1,
Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2.
    Download Patch 17268684:R12.AD.C.
    Do not apply the Patch 17268684:R12.AD.C. You should instead execute instructions in the patch readme to fix timestamp mismatches for Synonym, View, Package and Package Body.
1.8 Create Snapshot
After your installation or upgrade is complete, run the AD Administration Maintain Snapshot option.
    Run AD Administration (adadmin).
    From the Main Menu, choose Maintain Applications Files > Maintain Snapshot Information.
    Select Option 2, Update Current View Snapshot. Then, from the Snapshot sub-menu, select Option 1, Update Complete APPL_TOP.
ONLY if the steps above do not solve the issue consider following the steps below:
Warning, the following process can take up to and in excess of 10 hours to complete!
From $ORACLE_HOME/rdbms/admin, run the following steps on the Database tier:
1. Shutdown the database and open it in upgrade mode.
    Source the 11.2.0.3 db environment.
    From $ORACLE_HOME/rdbms/admin do the following:
sqlplus "/ as sysdba"
shutdown immediate
startup upgrade
2. From the same sqlplus session, run utlirp script:
@utlirp.sql
3. Bounce the database again and open it in normal mode.
From the same sqlplus session
shutdown immediate
startup
4. From the same sqlplus session, run the utlrp.sql from $ORACLE_HOME/rdbms/admin.
@utlrp.sql
5. Re-run adop.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.