Modern Oracle DBA
158 FOLLOWERS
Follow this blog to read articles on Oracle.
Modern Oracle DBA
3w ago
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
Modern Oracle DBA
1M ago
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
Modern Oracle DBA
2M ago
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
Modern Oracle DBA
2M ago
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
Modern Oracle DBA
2M ago
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
Modern Oracle DBA
8M ago
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
Modern Oracle DBA
9M ago
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
Modern Oracle DBA
1y ago
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
Modern Oracle DBA
1y ago
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
Modern Oracle DBA
1y ago
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