Export from a Non-CDB and Import in PDB

Introduction of Multitenant Architecture A logical backup taken from NON-CDB database can be easily imported into a pluggable database without any overhead. Let us see the example : Step 1: Check the database status SQL> select name,open_mode,cdb from v$database; NAME OPEN_MODE CDB ——— ——————– — NCDB READ WRITE NO SQL> Step 2 : Create the […]

Read More

Changing Instance Parameter in Pluggable Database

Introduction of Multitenant Architecture As we know in Multi-tenant architecture we have only one instance at container level hence we have only one spfile for Container Database. So value we set in parameters are associated in CDB$ROOT so applied to cdb root and serve as default parameters for all other containers; Although we can set […]

Read More

Pluggable Database Modes and PDB Settings

In this Article, we will see how we can open a Pluggable Database in different modes and changing the setting of particular pdb. Pluggable Database Modes : Open Pluggable Database in Restricted Mode First what is restricted mode : All user having create session privilege can connect to normally opened database. But when your database […]

Read More

Startup and Shutdown CDB and PDBs

In previous post we have seen various ways to connect with CDB and PDB. Establish Connection in CDB and PDB In this post we will see how we can Start and shutdown particular PDB and how to Start and shut down whole CDB. 1. How to Start Pluggable database There are two ways possible a) […]

Read More

Establish Connection in CDB and PDB

When it comes to Multi-tenant architecture,  one question that comes to our mind is how to connect to container database and pluggable database. Today we will see all possible way to connect to the container database. Obviously, we connect database using service name for the non-local connection. When we create CDB, a service is created […]

Read More

Manage Lockdown Profiles in PDB

Lockdown Profiles: Its a mechanism given by Oracle to restrict  PDBs from doing certain operations or from restricting them from using certain Functionalities. There are main three categories we can restrict using Lockdown Profile : Statement and clause Feature Option A statement can be Alter System and Alter Session and we can restrict clause with […]

Read More

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 SQL> SELECT con_id, name, open_mode, application_root,application_pdb, application_seed from v$containers where application_root = ‘NO’ and application_PDb = ‘NO’ and application_seed = ‘NO’; 2 3 4 CON_ID NAME OPEN_MODE APP APP APP ———- ——————————————————————————————————————————– ———- — — — 1 CDB$ROOT […]

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

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 [oracle@localhost ~]$ cd $ORACLE_HOME/dbs [oracle@localhost dbs]$ cat initmycdb.ora db_name=mycdb CONTROL_FILES=’/u02/oradata/mycdb/control01.ctl’,’/u02/oradata/mycdb/control02.ctl’ ENABLE_PLUGGABLE_DATABASE=TRUE DB_CREATE_FILE_DEST=’/u02/oradata/’ DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’ DB_BLOCK_SIZE=8192 UNDO_MANAGEMENT=AUTO UNDO_TABLESPACE=undotbs USER_DUMP_DEST=’/u01/oracle/admin/mycdb/adump/’ Step 2: Create necessary directories. [oracle@localhost dbs]$ mkdir […]

Read More