Steps to upgrade the latest JDK in OEM agent : 1. Check JDK Version. Go to OEM agent location and check the java version. cd /u01/app/oracle/product/agent13c/agent_13.5.0.0.0/jdk/bin ./java [...]

Steps to upgrade the latest OEM Agent Release update 1. Install the latest AgentPatcher Download the latest Agentpatcher from oracle support. cd <Patch location> cp [...]

Increase the report server engine to run multiple reports in parallel. Take a backup of rwsever.conf file cd $DOMAIN_HOME/config/fmwconfig/components/ReportsServerComponent/repserv1 cp -rp [...]

For the mail server configuration in 12c reports, need to the update the rwserver.conf files with mail server credentials. cd [...]

Step by Step installation of 19c Grid software,   1. Download the 19c Grid software from ORACLE, https://www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html 2. Copy Grid [...]

Steps to apply PSU patch in GRID Home, 1. Download the PSU patch from oracle support. 2. Check the opatch version before applying the patch. If you have older opatch version, then update to the [...]

The following steps to Deinstall 19c Grid Home, 1. Stop all the database which are related to ASM instance. 2. Stop all the listeners which are related to ASM instance. 3. Drop the database or [...]

The following steps to Deinstall 19c Oracle Home, 1. Stop all the database which are running under this oracle home. 2. Stop all the listeners which are running under this oracle home. 3. Go to [...]

Below sql script to check the Highest SQL Wait Time using Active Session History (ASH) col session_id for a10 col session_serial# for a10 col session_state for a20 SELECT h.session_id, [...]

Below sql script to check if any Debug or Trace profile options have been set to Y in Oracle ERP application, select distinct a.application_short_name app_short, user_profile_option_name optname, [...]