Modern Oracle DBA

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 ~]$  ...

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