Posts

How to Change Weblogic Password in R12.2

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

ADOP Frequently Using Commands

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; 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 status='R’; update ad_adop_sessions set APPLY_STATUS='C' where adop_session_id=28; update ad_adop_sessions set PREPARE_STATUS=&

Overview Of Adop Apply Phase

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 patch and apply the new patch adop phase

How To Create Database Link

Prerequest:- DBLink Name Schema name and password Connection string(tnsping SID) Creating Database Link:- Check DBLink is allreday existist or not SQL> Select * from dba_db_links where db_link='<db_link_name>'; SQL> CREATE DATABASE LINK <DB_LINK_NAME> CONNECT TO <Schema_name> IDENTIFIED BY <Schema_PWD> 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 SQL>set long 1000 SQL> select DBMS_METADATA.GET_DDL('DB_LINK','DB.DBLINK,'DB.OWNER') from dba_db_links; Connectivity Test:- select * from global_name@<DB_LINK_NAME> select * from global_name; Drop DB Link: Check the DB link and respective user and connect the user drop the db link  SQL> set lines 1000 col owner for a20 col username for a20 col host for a40 col d

19c Database Patching Steps

Image
1. Download pacthes 2. Patch Alasysis 3. Conflicts check and system space check  4. Backups (GI Home, DB Home and Database) 5. Apply  6. Post checks Download the Patches:- Search the below keyword in 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 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 pat

Useful Scripts to finding Query timings from AWR report and Memory

Below query collecting data from AWR report. 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='<SQL_ID>' and executions_delta > 0 order by 1, 2, 3 /  Below query use to (.sql) file set echo off set verify off set feedback off set heading on set timing off undef sql_id prompt "SQL_ID PLAN FROM CURSOR MEMORY" SELECT inst_id,sql_id, plan

Frequently Using Linux Commands

How to check Port availability   lsof -i tcp:<Port_Num> Netstat -putan |grep <Port_Number> netstat -an |grep <Port_Number>   lsof -i tcp:8031  netstat -putan |grep 8031   Renaming more than one characters in VI editor   Below command is replacing the word "DEV" to TEST in source file   perl -pi -e 's/DEV/TEST/g' <File_Name>   Ex: perl -pi -e 's/DEV/TEST/g' initTEST.ora     Check the Connection issues   nslookup  <Hostname> tnsping <Hosyname>   Searching the Multiple parameters in single file   $ORACLE_HOME/OPatche/opatch lsinventory |egrep -w '23456|125679|76578'| grep "applied on"   Tar Command Tar command is using to zip and unzip the files  Zip files: tar -cvf 11.2.0.4.tar.gz 11.2.0.4/ Unzip tar -xvzf  11.2.0.4.tar.gz   Nohup command nohup command in Linux systems that keep processes running even after exiting the shell or terminal. nohup tar - cvf 11.2.0.4.t