Blog Posts

Oracle dataguard physical standby

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 ...
ASM Storage migration

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 db using sqlplus

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

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 ...
Oracle Autonomous database creation

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 pdb

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

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

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

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

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 pdb within a cdb

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 pdb manually

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