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_...

Adop Apply Phase Frequently Using Commands: - How to apply the patch adop phase=prepare adop phase=apply patches=<Patch_Number> adop phase=finalize adop phase=cutover adop phase=cleanup adop phase=fs_clone How to apply Multiple patches  adop phase=apply patches=<Patch1>,<Patch2>,<Patch3> How to apply Merge patch adop phase=apply patches=<Patch1>,<Patch2>,<Patch3>  merge=yes How to apply Patch Run File System/Hot Patch Mode adop phase=apply patches=<Patch_Number>   hotpatch=yes How to apply the patch downtimemode adop phase=apply patches=<Patch_Number>  apply_mode=downtime How to reapply the patch adop phase=apply patches=<Patch_Number>  options=forceapply How to restart the patch from where patch failed adop phase=apply patches=<Patch_Number>  restart=yes How to restart the failed patch from begining adop phase=apply patches=<Patch_Number>  abandon=yes How to ignore the failed patc...

Prerequest:- DBLink Name Schema name and password Connection string(tnsping SID) Creating Database Link:- Check DBLink is allreday existist or not Copy SQL> Select * from dba_db_links where db_link='db_link_name'; Copy CREATE DATABASE LINK CONNECT TO IDENTIFIED BY USING 'TEST=( DESCRIPTION=( ADDRESS=( PROTOCOL=TCP (HOST=ebstest.vis.com) (PORT=1521) ) (CONNECT_DATA=( SERVICE_NAME=test INSTANCE_NAME=test )) ) )'; If you want to recreate a DB Link first get the source code from the database link before you drop the DBLink Copy SQL>set long 1000 SQL> select DBMS_METADATA.GET_DDL('DB_LINK','DBLINK_Name') from dual; Connectivity Test:- Copy select * from global_name@DB_LINK_NAME select * from global_name; Drop DB Link: Check the DB link and respectiv...

Step 1: Download the Patches Search for the following keywords on Oracle Metalink to download the CPU patches: Critical Patch Update (CPU) Program JAN 2022 Critical Patch Update (CPU) Program APR 2022 Critical Patch Update (CPU) Program JUL 2022 Critical Patch Update (CPU) Program OCT 2022 Download the Latest OPatch Version: Verify the current OPatch version: I opened for the July patch, and here we need to click Patch availability for Oracle products -> 3.1 Oracle database. Oracle database (3.1) Many Oracle products patches are listed here. I need only Oracle database patches. So, I'll go with the Oracle database 3.1.7 My DB version is 19c So I will choose 3.1.7.3 Oracle database 19c Here I will download the below database patch and grid patch (GI) One interesting fact is that if you download the GI Patch Database patch, it will also come under GI Patch. As a result, there is no need to download a database patch separately. Note : If you only apply the patch in Oracle Home, you...

Below query collecting data from AWR report. Copy SET LINES 155 COL execs FOR 999,999,999 COL avg_etime FOR 999,999.999 COL avg_lio FOR 999,999,999.9 COL begin_interval_time FOR a30 COL node FOR 99999 BREAK ON plan_hash_value ON startup_time SKIP 1 SELECT ss.snap_id, ss.instance_number node, begin_interval_time, sql_id, plan_hash_value, NVL(executions_delta, 0) execs, (elapsed_time_delta / DECODE(NVL(executions_delta, 0), 0, 1, executions_delta)) / 1000000 avg_etime, (buffer_gets_delta / DECODE(NVL(buffer_gets_delta, 0), 0, 1, executions_delta)) avg_lio FROM DBA_HIST_SQLSTAT S, DBA_HIST_SNAPSHOT SS WHERE ss.snap_id = S.snap_id AND ss.instance_number = S.instance_number AND sql_id = ' ' AND executions_delta > 0 ORDER BY 1, 2, 3 /  Below query use to (.sql) file Copy SET ECHO OFF SET VERIFY OFF SET FEEDBACK OFF SET HEADING ON SET TIMING OFF UNDEF sql_id PROMPT "SQL...

As an Oracle DBA or Linux system administrator, we frequently perform operational tasks such as checking port usage, cleaning old files, troubleshooting network issues, and monitoring disk space. This post documents commonly used Linux commands that are extremely helpful in day-to-day DBA activities , along with examples for better understanding. 1. How to Check Port Availability Using lsof This command identifies which process is using a specific TCP port. lsof - i tcp: 8031 Sample Output: java 24567 oracle 123u IPv4 987654 TCP *: 8031 (LISTEN) Using netstat This command displays active network connections and listening ports. netstat -putan | grep 8031 netstat -an |grep <Port_Number> Sample Output: tcp 0 0 0.0.0.0:8031 0.0.0.0 :* LISTEN 24567 /java 2. Renaming Multiple Characters in a File This method is useful when you want to replace a specific word throughout a file. Syntax perl - pi -e 's/OLD_VALUE/NEW_VALUE/g' <FILE_N...