Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Oracle 12c New Features (Part I)

Online Oracle Training

Oracle12c Multitenant Architecture

Multitenant Container (CDB) and Pluggable Databases (PDBs)



What you need to know about Oracle12c New Features
You will learn about: Containers, The Root, PDBs, Pros to have PDBs, Naming PDBs, Data Dictionary Architecture in a CDB, Metadata link, Object link, PROs of using Multitenant Architecture, Data Objects in a CDB, A CDB contains

More ...


How to install Oracle12c using the Multitenant Architecture feature

More ...



Creating a profile to access to your instances

The following is an example of global variables that you can define to access to you instances. Make sure to change your SID (mycdb) and Oracle home (product/ where applicable.




Exploring created instance (mycdb) and pluggable database (mypdb1)

Note on the instance “mycdb” and service name “mypdb1” and “mycdb.” Users can access to the mypdb1 pluggable database using the service name “mypdb1.”


Oracle creates services automatically for each container (cdb, seed and pluggable database including SYS$BACKGROUND and SYS$USERS). Let us check and query them.


Notice that the MYPDB pluggable database is in READ WRITE open mode and the seed PDB (PDB$SEED) is in READ ONLY open mode. The number 2 always assigned to the seed since it is the second created containers.




Create a net service name using the netca tool

In this lesson, you will create the mypdb1 net service name for the mypdb1 pluggable database of mycdb in the tnsnames.ora file.

More …



How to login to a pluggable database and query from it

Let us connect to mypdb1 pluggable database. First you need to open the pluggable database.

More …

Query the data files using the DBA_DATA_FILES view. Assume you are connected to the mypdb1 pluggable database.

More …



Create a new pluggable database

You use the seed read only pluggable database to create a pluggable database. In this lesson, you will create a new PDB pluggable database named mypdb2 in mycdb.

More …

You can use either the dbca tool or SQL Developer or SQL command to create a pluggable database. In this lesson, we use the SQL tool to create a PDB.

More …



How to clone a pluggable database

In this lesson, you will create a new pluggable database (mypdb2_clone) from mypdb2.

Assuming you have already connected to root.

More …

Change the mypdb2 open mode from read only to read write. First you need to close the database and then open it.

More …

You can use EasyConnect to the mypdb2_clone pluggable database as sysdba.

More …


Part I      .Part II     .Part III

Good Luck!!!!


Web web site