Explore Instance of PDB

In a previous post, we have seen the creation of Container database and pluggable database Manually Create and configure CDB database and PDB database In this post, we will explore data dictionary views of CDB and PDB. We all are aware of DBA_, ALL_, and USER_ views.   USER_ views show information about user-specific metadata. […]

Read More

Convert Regular PDB to Application PDB

In this article, we will see converting regular PDB to Application PDB. Step 1: Check regular PDB

I have two pdbs which are not associated with any application container. Step 2: Now I will check which application container is available in my CDB$ROOT

I have two application containers available F348281081_21_1 PDB is a clone […]

Read More

Plugging Non-CDB to CDB

In this article, we will see how we can plug the Non-CDB database as a Pluggable Database in a Container Database. Step 1: Check non-cdb Database

Step 2: Gracefully shut down Non-CDB database and open it in READ ONLY stage

Step 3 : Call DBMS_PDB.DESCRIBE procedure, that will create the XML file

[…]

Read More

Upgrade and Patch Application in Application Container

In previous article we have seen Installing Application and Synchronizing it with Application PDB. Introduction to Application Container Application Container Creation and Installation of Application In this article, we will see upgrading Application and Patching Application. 1. Upgrade Application in Application Container : Before starting application upgrade you need to know the current version of […]

Read More

Creating Application PDB and Syncing with Application Root

In a previous post, we have seen creation steps of Application Container and Installation of Application in the Application container. Application Container Creation and Installation of Application In this article, we will see Creation Steps of Application PDB and synchronization of Application PDB with Application Container. Create application PDB: Step1: Connect to application root : […]

Read More

Application Container Creation and Installation of Application

In the previous article, we have seen Introduction of Application Container Introduction to Application Container   In this article we will see creating Application Container, Installing Application in Container, Creating Application PDBs and syncing application PDB with application root. Step 1: Create an application root database

Step 2: Open application root database

Step 3: Save […]

Read More

Introduction to Application Container

Application container is a new feature introduced in Oracle 12c Release 2. The main benefit of an application container in your environment is it makes application level patching and upgrade easy. Introduction of Multitenant Architecture In a product based company where you have multiple customers which are having same application running in your PDBs. We […]

Read More

Manually Create and configure CDB database and PDB database

In the previous article, we can see that the architecture of multitenant. In this post, we will configure manually CDB and PDB. Introduction of Multitenant Architecture Step 1: create initmycdb.ora

Step 2: Create necessary directories.

Step 3: export ORACLE_SID and start the database in the nomount stage

Step 4: Create a script […]

Read More

Describe the CDB root and pluggable database containers

In the previous article, we have explored Multitenant architecture. Introduction of Multitenant Architecture We have heard this word container database and pluggable database many times after 12c came into the market. Today we will see what does it mean by a pluggable database and container database. Container Database and Pluggable Database : In a multi-tenant […]

Read More

Introduction of Multitenant Architecture

Oracle databases are always extremely advanced and sophisticated software components that are state of the art for RDBMS. Till 12.1 came into the market we used to have Single Database associated with Single Instance [Except RAC environment], to support each application we need to create a new database. So the organization which handles 50 different […]

Read More