Deinstall 19c Grid Home
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.…
Read MoreDeinstall 19c Oracle Home
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…
Read MoreScript to check the Highest SQL Wait Time using Active Session History (ASH)
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, h.session_serial#,…
Read MoreScript to see if any Debug or Trace profile options have been set to Y in Oracle ERP application.
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, decode(level_id, 10001,’SITE’, 10002,’APP…
Read MoreRemove Disk from ASM diskgroup in Oracle 19c.
Follow 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 MoreAdd Disk to ASM diskgroup in Oracle 19c.
Follow 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 MoreDrop ASM Diskgroup in Oracle 19c.
Follow 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 MoreCreate ASM Diskgroup in Oracle 19c
Follow 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 MoreScript to compile all the INVALID objects and script to compile specific object type
Below is the script to compile all the INVALID objects and script to compile specific objects in oracle database. ************************************************************************************ SET SERVEROUTPUT ON SIZE 1000000 BEGIN FOR cur_rec IN…
Read MoreScript to stop 12c Forms & Reports
Script to stop 12c Forms & Reports *************************************************************************** export MW_HOME=/u01/app/oracle/middleware export DOMAIN_HOME=$MW_HOME/user_projects/domains/ClassicDomain echo “Stop WLS_FORMS” $DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_FORMS echo “Stop WLS_REPORTS” $DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_REPORTS echo “Stop OHS” $DOMAIN_HOME/bin/stopComponent.sh ohs1 echo “Stop…
Read More