Oracle12c Multitenant Architecture
Multitenant Container (CDB) and
Pluggable Databases (PDBs)
LESSON 01
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 ...
LESSON 02
How to install Oracle12c using the Multitenant Architecture feature
More ...
LESSON 03
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/12.1.0.1/Db_1)
where applicable.
More…
LESSON 04
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.”
More…
Oracle creates services
automatically for each container (cdb, seed and pluggable database including
SYS$BACKGROUND and SYS$USERS). Let us check and query them.
More…
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.
More…
LESSON 05
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 …
LESSON 06
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 …
LESSON 07
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 …
LESSON 08
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!!!!
|