1. Check current snap_interval and disable snapshot creation, see below. Check current AWR snapshot interval as follows: sqlplus /nolog connect / as sysdba select snap_interval from [...]

ERROR:- ********* Error occurred while running ./datapatch -verbose after applying latest patch on 19.0.0.0 Error at line 8325: script md/admin/sdoutlb.plb – 167/11 PLS-00201: identifier [...]

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