Manage common and local users, roles, privileges and profiles in PDBs

Introduction of Multitenant Architecture Common users and Local users: This concept came with Oracle Database 12c. Common Users: a Common user is a user which have the same username and password authentication across PDBs of CDB. Common users are created at CDB level and the common user can connect to the root and perform operations. […]

Read More

Manage common and local objects in application containers

Introduction of Multitenant Architecture With Oracle 12c Oracle introduced the concept of common objects which avoids redundancy of metadata and data. Which makes CDB maintenance and up-gradation easy. Common objects exist in Oracle-supplied schemas and therefore cannot be user-defined. In the Application container, we can create metadata-linked or data-linked common objects. There can be following […]

Read More

Backup CDB and PDBs

Introduction of Multitenant Architecture In this article, we will see how we can take RMAN backup of whole CDB and for the single pluggable database. To take RMAN backup of the whole CDB we can simply take backup by connecting to target as container database and backup database command. Let us see by example : CDB […]

Read More

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

Step 2 : Create the directory

Step 3 : Backup using expdp

Step 4 : Connect to CDB […]

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

Managing Tablespace in Multi-Tenant Environment Part – I

In this article, we will see how tablespaces are managed in a Multi-tenant architecture. Mainly we have 4 types of tablespaces System Tablespace. User permanent tablespace. Temporary tablespace. Undo tablespace. System tablespace must be created while creating a database using either DBCA or manually.

We can see in above output system tablespace is created […]

Read More