What are the Oracle 12c Pluggable databases? How does a pluggable database work?(Video included)

Share via:

What are the Oracle 12c Pluggable databases?  How does a pluggable database work?

 

These are the databases that are stored within the CDB.

A PDB is a portable collection of schemas, schema objects, and non schema objects that appears to an Oracle Net client as a non-CDB.

Physical Structure for PDBs

 

 

WHAT PLUGGABLE DATABASE’s  have ??

  1. Each PDB has its own set of tablespaces including SYSTEM and SYSAUX.
  2. PDBs share UNDO, REDO and control files, (s)pfile of ROOT (CDB$ROOT).
  3. The CDB has a single TEMP tablespace but PDBs may create their own other wise it may use cdb’s TEMP tablespace.
  4. PDBs share common SGA and background process.
  5. Entire information of PDB’s are stored in CDB.

 

To check pluggable databases information.

To connect SEED DATABASE use following command.

 

CREATE PLUGGABLE DATABASE using seed database :

Here we are creating a pluggable database called PLUG1 using SEED database.

NOTE:

Whenever we create any pluggable database .The default mode of pluggable database is MOUNTED.we can make read write also.

Now we want connect to plug1 pluggable database.

CREATE PLUGGABLE DATABASE BY USING CLONING METHODS:

Here I would like to create new pluggable database from existing pluggable database nothing but CLONING.

NOTE :

When ever we are creating a PDB using cloning method the existing pdb should be in READ WRITE mode.

Making PDB as READ WRITE mode in another way.

CREATE PLUGGABLE DATABASE USING XML FILE

Note :

For creating pdb using xml first we need to unplug the pdb into xml file.

Unplug a database :

Plug  a database:

While plug a database using xml file make sure we need to drop existing pluggable database.

CLONING PLUGGABLE DATABASE WITH OUT USERDATA datafiles.

Here we are creating PLUG5  using PLUG1 without cloning of userdata datafiles.

To SHUTDOWN and STARTUP  all the pluggable database at once we need to use below command.

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (7 votes, average: 5.00 out of 5)
Loading...

3 thoughts on “What are the Oracle 12c Pluggable databases? How does a pluggable database work?(Video included)

  1. Hello Everyone

    We have discussed regarding the introduction of multitenency in our first session.

    Now we will discuss on different ways of creating the container databases,
    how to connect to the PDB and creating the global and local users in our next session

    Please go through below article before connecting to the session.

    https://www.ktexperts.com/what-are-the-oracle-12c-pluggable-databases-how-does-a-pluggable-database-work/

    Also, please give your your valuable comments in the comment section at end of the article.

    Session Details :

    What are the Oracle 12c Pluggable databases?
    Sat, Jun 16, 2018 8:00 AM – 11:00 AM PDT
    Please join my meeting from your computer, tablet or smartphone.
    https://global.gotomeeting.com/join/735527389
    You can also dial in using your phone.
    United States: +1 (408) 650-3123
    Access Code: 735-527-389

    Time Zone Converter :

    https://www.timeanddate.com/worldclock/converter.html?iso=20180616T150000&p1=176&p2=137

Leave a Reply to Vinod Cancel reply