Oracle Database 12c:How to Create the container database

Last updated on January 13th, 2019 at 01:37 pm

So far we have learned about container database,Multi tenant architecture. Now in this post I will give you some steps on How to Create the container database in Oracle 12c

How to Create the container database in Oracle 12c

Container Database can be created by DBCA or you can create it manually

DBCA

It is same as pre 12c But we just have a additional flag to enable PLUGGABLE DATABASE

Manually:

1) We can set the Oracle home and Oracle SID
2) Create the init.ora and spfile
3) Connect to sqlplus
startup nomount

4) Run the command

It create the Container database and Seed PDB

Two important things in this command
a) ENABLE PLUGGABLE DATABASE : It enabled the container database
b) SEED FILE_NAME_CONVERT: It tells where to create the datafile for seed database
c) If we have OMF present ,then we we dont need to give the SEED file_name_convert. Everything gets created into DB_CREATE_FILE_DEST

So with OMF

5) Run the catcdb.sql script which create the necessary views

Important things to check

1. The above command create two container CDB$ROOT and PDB$SEED
2. v$containers is the new view in CDB,it shows all the containers

When this is run from root container, it shows all containers CDB as well as PDB. But if you run same command from any PDB, it will show that container.
3. We have a new column in v$database called CDB. If your database is container database it will show as YES

1. SYS and SYSTEM are common user between root and seed container

2. SGA is shared across the all the container so,v$ views contains extra column con_id

3. USER_objects list all the object own by the user in PDB

4. ALL_OBJECTS list all the object which he has privilege in the PDB
5. DBA_OBJECTS list all the objects the PDB and root container
6. There is new view CDB_OBJECTS. It list all the objects across all the PDB in the container