Blog Posts

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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
Drop cdb in silent mode

Drop a container database in silent mode

In my previous post I have described how to create create container database using dbca in graphical mode and silent ...
Read More
create cdb in silent mode

Create Container database (CDB) in silent mode

Oracle has introduced new Multitenant Option from Oracle 12cR1 and this option enables an Oracle database to function as a ...
Read More
Create cdb using dbca

Create Container Database (CDB) in Oracle 12c using DBCA

Oracle has introduced new Multitenant Option from Oracle 12cR1 and this option enables an Oracle database to function as a ...
Read More

Recover table to new name from RMAN backup in Oracle 12c

Oracle has introduced a new feature from Version 12c which will enable us to recover tables from RMAN backups using ...
Read More

Oracle 12c Recover table from RMAN backup

Oracle has introduced a new feature from Version 12c which will enable us to recover tables from RMAN backups using ...
Read More
Oracle 19c Autoupgrade

Upgrade to Oracle 19c using Autoupgrade utility

Oracle Database Autoupgrade Utility is a new feature designed in Oracle 19c to automate the Upgrade process which Identifies issues ...
Read More
Manually Upgrade database from 12c to 19c

Upgrade Oracle database manually from 12c to 19c

Description In this article I will demonstrate an overview on manually upgrading Oracle database from 12.2.0.1 to 19.3.0.0 on Oracle ...
Read More
error in invoking target 'agent nmhs'

Error in invoking target ‘agent nmhs’ of makefile

You may get the following error while trying to install Oracle 11g v11.2.0.4 on linux x86-64 bit machines, Error in ...
Read More
Upgrade Oracle db from 11g to 19c

Upgrading Oracle database from 11g to 19c

Description In this article I will demonstrate an overview on manually upgrading Oracle database from 11.2.0.4 to 19.3.0.0 on Oracle ...
Read More