Modern Oracle DBA

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

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

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)*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') ACTUAL_START_DATE , floor(((FCR.ACTUAL_START_DATE-FCR.request_date)*24*60*60)/3600)|| ' Hrs ' || floor((((FCR.ACTUAL_START_DATE-FCR.request

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.555 631   Ncat: Version 7.50 ( https://nmap.org/ncat )  Ncat: Connection timed out.   You have new mail in /var/spool/mail/appl

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        string       /u01/app/oracle/oradata   DB_CREATE_ONLINE_LOG_DEST_n Defines the locations of the redo log files and control files creations.   DB_RECOVERY_FILE_DEST Default location for the fast recovery area. SQL> s

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>  <hostname> HARDWARE REQUIREMENTS It is recommended to use 4GB of memory for the database and 6GB for the application (0 -10 users). So, for a single node installation in PRODUCTION, a minimum of 10g RAM is recommended. The table below s