Step:-1 Check invalid Invalid Component:- SQL> SELECT COMP_NAME FROM DBA_REGISTRY WHERE STATUS=’INVALID’; COMP_NAME ——————————————————————————– Oracle XML Database   Step:-2 execute the [...]

Patch Information: – Patch 30087906 – Database Release Update Revision 19.3.2.0.191015   Step: -1 Environment Details   export ORACLE_HOME=/u01/app/19c/grid export [...]

Hardware monitoring commands: – Display information about the environment and hardware:- odaadmcli show env_hw Display information about the filesystem:- odaadmcli show fs Display [...]

ORA-07445 – exception encountered: core dump Issue :- DB was down due to the ORA – 07445 error in the alert log Cause:- ORA-07445: exception encountered: core dump [kggchk()+52] [...]

SERVER CONTROL UTILITY (SRVCTL) Server Control Utility (SRVCTL): It is used to administer Oracle Real Application Clusters (Oracle RAC) databases and instances. Use SRVCTL to manage Oracle [...]

Step 1:  Get the hash value of the SQL using the SQL ID. Enter the SQL ID select a.plan_hash_value from v$sql a where sql_id=’&a’;   Step 2: Create a tuning task using SQL ID [...]

The following query will help you to find the history of concurrent programs run in your EBS environment. You should connect to ‘apps’ user for executing this query and query will [...]

1. Find out the Template file. [oracle@ebs bin]$ cd $ORACLE_HOME [oracle@ebs 12.1.0]$ cd appsutil/template/ [oracle@ebs template]$ pwd /u01/StageR122/PROD/12.1.0/appsutil/template [oracle@ebs [...]

STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs Enable/Disable auto restart of CRS. $GRID_HOME/bin/crsctl disable crs [...]

Creates the DDL for the specified job:- SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param [...]