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 Reference: How To Change or Reset The WebLogic Administration Password In 12.2 E-Business Suite (Doc ID 1385751.1 )

How to check EBS CPU level Copy Select max (CODELEVEL) "CPU" from AD_TRACKABLE_ENTITIES where ABBREVIATION in ('ebscpu'); How to check AD and TXK Code level Copy Select abbreviation,codelevel from ad_trackable_entities where abbreviation in( 'ad','txk','cc_pf','atg_pf','scp_pf' ) order by abbreviation; How to check Patch applied status Copy Select bug_number,creation_date from ad_bugs where bug_number= How to check Installed language in EBS Copy SELECT Language_code, NLS_language, Installed_flag FROM fnd_languages WHERE installed_flag IN ('I', 'B'); I- Installed Language B- Base Language Is System crash/Unable to continue the Adop session  Execute below querys to find which session is causing theissue Copy select adop_session_id from ad_adop_sessions where status='R'; Copy select ADOP_SESSION_ID,PREPARE_