Oracle Data Guard Physical Standby switchover using DGMGRL:-   Performing a Oracle Data Guard Switchover Using DGMGRL    Step1:-Check the Primary Database   Check both side:-   [...]

Reinstate Failed Primary Database using Flashback:-   Methods to Reinstate database using Flashback:-   1) Using DGMGRL 2) Using SQL*PLUS   1) Using DGMGRL:-   Startup the [...]

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 [...]