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 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 MoreFollow the below steps to drop the ASM Diskgroup. 1. Check the ASM diskgroup. 2. Drop ASM diskgroup. 3. Check the disk dropped from from ASM Diskgroup 1. Check the…
Read MoreFollow the below steps to create the ASM Diskgroup. 1. Create ASM disk. 2. Check the ASM disks. 3. Create ASM diskgroup. 4. Check the newly added disk in ASM…
Read More