Tuesday, July 7, 2015

Some Useful queries for ADOP and patching

SQL> select * from fnd_oam_context_files where name not in ('TEMPLATE', 'METADATA');
SQL> SELECT abbreviation, codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad');
SQL> select ad_patch.is_patch_applied('R12',-1, bug_number ) from dual;
    select release_name from apps.fnd_product_groups;
     AD_ADOP_SESSION_PATCHES:
SQL> select ADOP_SESSION_ID, BUG_NUMBER, ADPATCH_OPTIONS, CLONE_STATUS, STATUS, NODE_NAME from AD_ADOP_SESSION_PATCHES
order by ADOP_SESSION_ID,END_DATE;
AD_ADOP_SESSIONS:
SQL> select ADOP_SESSION_ID, PREPARE_STATUS, APPLY_STATUS, FINALIZE_STATUS, CUTOVER_STATUS, CLEANUP_STATUS, ABORT_STATUS, STATUS,
ABANDON_FLAG, NODE_NAME from AD_ADOP_SESSIONS order by ADOP_SESSION_ID;
SQL> select * from fnd_nodes;
SQL> select * from ad_appl_tops;
select BUG_NUMBER, ADPATCH_OPTIONS from AD_ADOP_SESSION_PATCHES where BUG_NUMBER = '';

SQL> select ADOP_SESSION_ID, PREPARE_STATUS, APPLY_STATUS,
     CUTOVER_STATUS, CLEANUP_STATUS, ABORT_STATUS, STATUS
     from AD_ADOP_SESSIONS
     order by ADOP_SESSION_ID;
   
     These status values are updated when a step has completed, and are as follows:

N denotes that the phase has not been completed
0 denotes that cutover/force_shutdown has started
1 denotes the "force_shutdown" step has successfully executed
3 denotes the "db_cutover" step has successfully executed
4 denotes the "fs_cutover" step has successfully executed
6 denotes the "force_startup" step has successfully executed
Y denotes that the phase is done

SQL> select ADOP_SESSION_ID,BUG_NUMBER,ADPATCH_OPTIONS, CLONE_STATUS,STATUS,NODE_NAME
from AD_ADOP_SESSION_PATCHES
order by ADOP_SESSION_ID;

No comments:

Post a Comment