Modern Oracle DBA

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

Long Running Query Copy 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) * 60))) || ' Secs ' "RUNNING_SINCE", to_char(FCR.requested_start_date, ' DAY DD-MON-YY HH:MI AM') REQUESTED_START_DATE, to_char(FCR.actual_start_date, ' DAY DD-MON-YY HH:MI AM') ...

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  cups-libs-1.6.3-51.el7.x86_64  [applmgr@vtebz1 ~]$  Example1 :  [applmgr@ vtebz1 ~]$  nc -vz 10.20.30.555 631  Ncat: Version 7.50 ( https://nmap.org/ncat )  Ncat: Connected to 10.20.30.555 631  . Ncat: 0 bytes sent, 0 bytes received in 0.06 seconds.  [applmgr@ vtebz1 ~]$  Example 2:   [applmgr@ vtebz1 ~]$   nc -vz 10.20.30...

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                                  TYPE         VALUE ------------------------------------------------------------------------------- db_create_file_dest     ...

This post is a step-by-step for Installing Oracle E-business suite R12.2.0 on Oracle Enterprise Linux 7.5 (64-bit). Pre-Installation Tasks Software Requirement ·        Oracle Virtual Box ·        Oracle Enterprise Linux 7.5 (64-bit) ·        Oracle E-Business suite R12.2 for LinuxX86-64-bit High Level Installation Steps ·        Hardware requirements. ·        Operating System pre-requisites. ·        Prepare Stage Area. ·        Install Oracle EBS R12.2 software. ·        Verify Installation Download the Oracle E-Business Suite Software Download the software from  http://edelivery.oracle.com . It comes in zip format.   NETWORKING Please add the below format foe the /etc/host file <IP address>  <hostname>.<domainname>...