LOG_ARCHIVE_DEST_n: this parameter is used to transfer the archived redo from the primary database to standby database. Standby to primary in case of switchover. Note: LOG_ARCHIVE_DEST_n destination must have either …
-
-
1. Identify your SQL ID of SQL Query which need to trace. SELECT sql_id, plan_hash_value, substr(sql_text,1,40) sql_textFROM v$sqlWHERE sql_text like ‘SQL QUERY%’;2. Enable the trace of SQL with using SQLID …
-
Error in Alert Log Sun Nov 25 02:14:17 2018Unable to allocate memory for new incident error in file E:ORACLE12Cdiagrdbmsicictraceic_m001_6448.trc:ORA-04030: out of process memory when trying to allocate 20520 bytes (pga …
-
Configure the Shared Single Client Access Name (SCAN) Single Client Access NameIn release 11g, SCAN is introduced, In SCAN act as cluster alias,you does not need to change the …
-
1. Stop all the services running on the Node srvctl stop service -db database_name -service “service_name_list” -node node_name–Examplesrvctl stop service -db grid -service “sales,oltp” -node NODE1 2. Check the VIP …
-
Oracle Clusterware requires that each node is connected through a private network. You can also called cluster interconnect. It used for established communication between all the nodes present in the …
-
Restoring the Oracle Cluster Registry on Linux or UNIX Systems If OCR is failed then first check with OCRCHECK command before start restoring the OCR disk Note: If OCR location …
-
Backup and Restore the OCR on Windows system in Oracle RAC Restoring the Oracle Cluster Registry on Windows SystemsIf OCR is failed then first check with OCRCHECK command before …
-
Normal database environment If database is giving following message then you can use shutdown abort and startup it again. If not fixed then you can use shutdown abort commandShutdown abort …
-
Error: On checking the alert log we found the following error in alert log: ORA-00257: archiver error. Connect internal only, until freed.ORORA-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 904507904 …