Modern Oracle DBA

This step requires a minimum version of R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 or later. TXK 7's functionality has been simplified and largely automated with the introduction of a new utility that handles previously manual procedures. 1. Shutdown the all application tier services except the Admin Server. Primary node, run the below command cd $ADMIN_SCRIPTS_HOME /adstpall.sh -skipNM -skipAdmin Secondary nodes, stop the application services cd $ADMIN_SCRIPTS_HOME /adstpall.sh 2. To change the Oracle WebLogic Server Administration User password, execute the below command on the primary node's run file system. Source the environment on the run file system. perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword 3. Start all services on all nodes, using the command: cd $ ADMIN_SCRIPTS_HOME /adstrtal.sh

How to check Patch applied status Select bug_number,creation_date from ad_bugs where bug_number=<Patch Number> How to check AD and TXK Code level Select abbreviation,codelevel from ad_trackable_entities where abbreviation in( 'ad','txk','cc_pf','atg_pf','scp_pf' ) order by abbreviation; How to check EBS CPU level Select max (CODELEVEL) "CPU" from AD_TRACKABLE_ENTITIES where ABBREVIATION in ('ebscpu'); Is System crash/Unable to continue the Adop session  Execute below querys to find which session is causing theissue select adop_session_id from ad_adop_sessions where status='R'; 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 where ADOP_SESSION_ID='&sid'; Set the status to Completed 'C' for that session to re- try the adop phase. update ad_adop_sessions set status='C'where stat