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 …
-
OracleTroubleshoot
ORA-01154: database busy. Open, close, mount, and dismount not allowed
by tuanlpby tuanlpNormal 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 …
-
OracleTroubleshoot
ORA-00257: archiver error. Connect internal only, until freed.
by tuanlpby tuanlpError: 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 …
-
OracleTroubleshoot
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n
by tuanlpby tuanlpError: When i tried to set the log_archive dest value then i got the following error:SQL> ALTER SYSTEM SET log_archive_dest=’D:oraclexe’;ALTER SYSTEM SET log_archive_dest=’D:oraclexe’*ERROR at line 1:ORA-02097: parameter cannot be modified …
-
Issue When i tried to connect with the database then i got the following error.ORA-27101: shared memory realm does not exist ErrorSQL*Plus: Release 12.1.2 – Production on Mon May 07 …
-
Restore Pluggable database with RMAN Advisory Recover the Pluggable database with RMAN advisory from CDB completed backup in Oracle. Error:SQL> alter pluggable database pdb3 open;alter pluggable database pdb3 open*ERROR …
-
Following are the way to check current SCN in Oracle Database: 1. Fetch the current SCN number in v$database view.Select CURRENT_SCN from v$database; SQL> Select CURRENT_SCN from v$database;CURRENT_SCN———–3208426 2. Get …