Configure Oracle 12c Dataguard Physical Standby
Description: In this post I will describe the step by step configuration of Oracle 12c Dataguard physical standby setup with dataguard ...
ORA-16853: apply lag has exceeded specified threshold
I got the below error in one of my standby environment. Error - ORA-16853: apply lag has exceeded specified threshold ...
ORA-16857: member disconnected from redo source for longer than specified threshold
In one of my dataguard environment I got the Error: ORA-16857: member disconnected from redo source for longer than specified ...
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
On standby side, you may encountered the Error "ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be ...
ORA-19527: physical standby redo log must be renamed
On standby side, you may encountered the Error "ORA-19527: physical standby redo log must be renamed" in the alert log ...
ORA-65093: multitenant container database not set up properly
While starting a container database or mounting a standby container database you may encountered Error: ORA-65093: multitenant container database not ...
Enable Flashback Database on Oracle 12c
In this article we will describe the step by step instructions on how to enable flashback on Oracle 12c database ...
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
You might encounter ORA-19802 error while setting DB_RECOVERY_FILE_DEST Error: SQL> alter system set db_recovery_file_dest='/u01/app/oracle/fra'; alter system set db_recovery_file_dest='/u01/app/oracle/fra' * ERROR ...
ORA-16179: incremental changes to “log_archive_dest_1” not allowed with SPFILE
You might encounter ORA-16179 error during updating the archive log destination. Error Details: SQL> alter system set log_archive_dest_1='/u01/app/oracle/arch'; alter system ...
Migrate ASM Diskgroup to another storage
In this post I will describe in step by step how to Migrate Oracle ASM Diskgroups to another Storage in ...
Connect to Autonomous Database using SQLPlus
In this post I will describe how to connect to Autonomous Database using SQL*PLUS Steps: Connecting to Autonomous Database using ...
Connect to Autonomous Database using SQL Developer
In this post I will describe how to connect to Autonomous Database using SQL Developer Steps: Connecting to Autonomous Database ...
Autonomous Database creation on Oracle Cloud
In this post I will describe the step by step creation of Oracle 19c Autonomous Transaction Processing Database in Oracle ...
Unplug and Plugin Pluggable database (PDB)
Oracle has introduced new Multitenant Option from Oracle 12cR1 and this option allows a single container database (CDB) to host ...
INS-08101 Unexpected error while executing the action at state: ‘supportedOSCheck’
You may get the following error while installing Oracle 19c on Oracle Linux 8 in GUI as well as in ...
Oracle Linux 8 Installation
In this article I will describe how to perform a basic Oracle Linux 8 installation by using DVD or ISO ...
Oracle Linux 7 Installation
In this article I will describe how to perform a basic Oracle Linux 7 installation by using DVD or ISO ...
Clone a non-CDB into CDB in Oracle 12c
Oracle has introduced new Multitenant Option from Oracle 12cR1 and this option allows a single container database (CDB) to host ...
Clone a pluggable database (PDB) within a CDB in Oracle 12c
Oracle has introduced new Multitenant Option from Oracle 12cR1 and this option allows a single container database (CDB) to host ...
Create a pluggable database manually in Oracle 12c
Oracle has introduced new Multitenant Option from Oracle 12cR1 and this option allows a single container database (CDB) to host ...