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 r ..read more

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,ABAND ..read more

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 patche ..read more

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 lon ..read more

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) M ..read more

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 ..read more

How to check Port availability  lsof -i tcp:<Port_Num> Netstat -putan |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>   Searching the Multiple parameters in single file   egrep 'login|s_wls_adminport' $CONTEST_FILE     H ..read more

Long Running Query   SELECT fcr.request_id,fcr.parent_request_id, ftp.user_concurrent_program_name, fcu.user_name,fcu.description User_Detail, fcr.phase_code phase, floor(((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60)/3600)|| ' Hrs ' || floor((((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60) - floor(((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60)/3600)*3600)/60)|| ' Mins ' || round((((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60) - floor(((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60)/3600)*3600 - (floor((((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60) - floor(((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60)/3600)*3600)/60 ..read more

High Level Steps RPM Installation  Firewall port Open  Collect the Printer information from user  Install the printer  ADD PRINTER ON THE APPLICATION SIDE RPM Installation   Install the required RPMs on the linux server in my server cups related RPMs already installed  [applmgr@vtebz1 ~]$ rpm -qa |grep cups  ghostscript-cups-9.25-5.el7.x86_64  cups-filters-1.0.35-28.0.1.el7.x86_64  cups-filesystem-1.6.3-51.el7.noarch  cups-filters-libs-1.0.35-28.0.1.el7.x86_64  cups-1.6.3-51.el7.x86_64  cups-client-1.6.3-51.el7.x86_64  cu ..read more

Oracle Managed Files (OMF) handles file creation and deletion directly at the operating system level.  Sample we only need to specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's data file with the DATAFILE clause. This feature works well with a logical volume manager (LVM). Below installation parameters are must enable the  OMF.   DB_CREATE_FILE_DEST  Defines the locations of the default file system directory for the datafiles and temporary files. SQL> show parameter DB_CREATE_FILE_DEST   NAME   ..read more