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 wrm$_wr_control; Disable AWR snapshot…
Read MoreERROR:- ********* 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 ‘SYS.DBMS_PRIV_CAPTURE’ must be declared -> Error…
Read MoreOracle Data Guard Physical Standby switchover using DGMGRL:- Performing a Oracle Data Guard Switchover Using DGMGRL Step1:-Check the Primary Database Check both side:- Select name,open_mode,database_role,protection_level from…
Read MoreReinstate Failed Primary Database using Flashback:- Methods to Reinstate database using Flashback:- 1) Using DGMGRL 2) Using SQL*PLUS 1) Using DGMGRL:- Startup the Failed Primary Database…
Read MoreStep:-1 Check invalid Invalid Component:- SQL> SELECT COMP_NAME FROM DBA_REGISTRY WHERE STATUS=’INVALID’; COMP_NAME ——————————————————————————– Oracle XML Database Step:-2 execute the below packages and triggers ALTER PACKAGE XDB.DBMS_CLOBUTIL COMPILE BODY ;…
Read MorePatch Information: – Patch 30087906 – Database Release Update Revision 19.3.2.0.191015 Step: -1 Environment Details export ORACLE_HOME=/u01/app/19c/grid export PATH=/u01/app/19c/grid/bin: $PATH [oracle@rac1 ~]$ srvctl config database -verbose oradb /u01/app/oracle/product/19c/dbhome_1 19.0.0.0.0…
Read MoreHardware monitoring commands: – Display information about the environment and hardware:- odaadmcli show env_hw Display information about the filesystem:- odaadmcli show fs Display information about the Memory:- odaadmcli show memory…
Read MoreORA-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] [SIGSEGV]…
Read MoreSERVER 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 supplied resources such as:…
Read MoreStep 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…
Read More