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 rwserver.conf rwserver.conf_bck Change the maxEngine value from 1 to…
Read MoreFor the mail server configuration in 12c reports, need to the update the rwserver.conf files with mail server credentials. cd $DOMAIN_HOME/config/fmwconfig/components/ReportsServerComponent/repserv1 Edit the rwserver.conf and update the below, From :…
Read MoreStep 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 sofwatare to Grid home mkdir -p /u01/oracle/product/19.3.0.0/grid unzip the…
Read MoreSteps 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…
Read MoreThe 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.…
Read MoreThe 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…
Read MoreBelow 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, h.session_serial#,…
Read MoreBelow 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, decode(level_id, 10001,’SITE’, 10002,’APP…
Read MoreFollow the below steps to remove a disk from ASM diskgroup in Oracle 19c. 1. Check the ASM disks in ASM DiskGroup. 2. Remove disk from ASM diskgroup. 3. Check…
Read MoreFollow the below steps to add a disk to ASM diskgroup in Oracle 19c. 1. Create ASM disk. 2. Check the ASM disks. 3. Add disk to ASM diskgroup. 4.…
Read More