Creating a Multitenant Container Database and Pluggable Database

      This article I am going to show you how to create multitenant container database and pluggable databases  

  

Oracle Database 12c brings a new architecture that lets you have many pluggable databases

inside a single Oracle Database (Container database (CDB)).

The Container Database is standard contains the following containers.

Root container - It is the core of the CDB, contains all Oracle supplied metadata like packages, core dictionary objects, and common users. It is denoted as CDB$ROOT

SEED Container (SEED PDB) - This is a template database distributed for new PDBs, whenever we create a new PDB, Oracle copies mandatory datafiles (common datafiles) for creation of PDB from this SEED Database. This is by default in READ-ONLY mode, can't be altered or modified. This is denoted as PDB$SEED

User defined PDB Container (PDB) - This is the Pluggable Database created for Application purpose, contains only Consumer Data or USER Data

Some of the characteristics of a CDB:-

• There is a separate SYSTEM and SYSAUX tablespace for the root container of the CDB and each PDB
• Only one UNDO tablespace for the entire CDB
• Only one set of control files and online redo logs files for the entire CDB.
• PDB’s have their own data files (which contain the user data)
• We can create on default temporary tablespace for the entire CDB or each PDB can have its own additional temporary tablespaces
• There is only one set of background processes shared by the root and all PDBs
• There is a single SGA shared by all  PDB’s

Benefits :-

Cost reduction in terms of Product licensing and Hardware procurement as we require less number of processors and less memory compare to a Non-CDB environment

Easier Database maintenance, Pluggable Databases can easily be moved or copied locally or remotely across Physical machines in the network, Upgrading Operating System, Upgrading or Patching Databases itself is a lot easier and "often" a one shot process, that greatly improves the availability

Performance tuning becomes a lot easier as all PDBs in a CDB environment share the same Hardware/Platform/Network resources like CPUs/Memory/OS/Bandwidth etc.. For example, It is quite easy to tune one single piece of SGA/PGA on one single instance rather than tuning each SGA on each physical machine

Create a CDB named CDB1 using DBCA 

Window/Page Description:- Database Operation , Choices or Values:-  Select "Create Database" , Click Next

Window/Page Description:- Creation Mode , Choices or Values:-  Select "Advance Mode"

Click Next

Window/Page Description:- Database Template , Choices or Values:- Select  " General Purpose or Transaction Processing " , Click Next

Window/Page Description:- Database Identification

Enter :-

Global Database Name :- CDB1

                                    SID:- CDB1 ,                 

         Choices or Values:- Select "Create As Container Database"

                                     Select "Create An Empty Container Database,   Click Next

Window/Page Description:- Management options

                    Choices or Values:- Select "Configure Enterprise Manager(EM) Database Express" (Optional) , Click Next

Window/Page Description:- Database Credentials

                    Choices or Values:- Select "Use same Administrative Password"

                    Click Next

Window/Page Description:- Network Configuration

                    Choices or Values :- “Listener Selection"

                     Name of Listener  :- LISTENER_CDB1

                     Port Number         :-1521

                     Click Next

Window/Page Description:- Storage Location

                   Confirm Storage Type is "File system"

                    Choices or Values:- Select "Use Common Location for All Databases Files"

                    Click Next

Window/Page Description:- Enable archive

                    Choices or Values:- Select "Archive log location"

                    Click Next

Window/Page Description:- Database option ,  Click Next

Window/Page Description:- Initialization Parameter ,  Click Next

Window/Page Description:- Pre Requisite Checks , Click Next

Window/Page Description:- Summary, Click Finsh

Window/Page Description:- Progress Page

Window/Page Description:-  on the database Configuration Assistant page(for password management),

 Click :- Exit.

  Click :- Close

Connect to the multitenant container database CDB1 ,Check if the database is  a multitenant container database

Check services :-

Create Pluggable Database (PDB1) Using DBCA

Window/Page Description:- Database Operation

            Choices or Values:- Select  " Manage Pluggable Databases "

             Click Next

Window/Page Description:- Manage Pluggable Databases

             Choices or Values:- Select  " Create a Pluggable Database "

              Click Next

Window/Page Description:- Database List

            Choices or Values:- Select  a container database which the pluggable database can be created, Click Next

Window/Page Description:- Create Pliggable Database

            Choices or Values:- Select  " Create a new Pluggable Database "

             Click Next

Window/Page Description:- Pluggable Database Options

                    Choices or Values:-

                     Pluggable Database Name :- PDB1

                     Administrator Username :- oracle_4u

                     Administrator Password :- XXXXXX

                     Confirm ADMIN Password:- XXXXX

                     Click Next

Window/Page Description:- Summary

                                         Click Finish

Window/Page Description:- Progress Page

Window/Page Description:- Progress Page

                                         Click Close

Check the Pluggable Database status 

Configure tnsname for Pluggable database

                                          

Connect to any of the PDB in your CDB1 except PDB$SEED.

Shutdown PDB:-

Verify PDB down or not :-

Startup PDB:-

End of this article , You have learned how to created CDB and PDB database , How to bring down and up  PDB database . 

                                      Thank You all for watch this Demo .