Description:
In this blog, we are going to know about how to create container database in Oracle 12c using DBCA method.
Creating a multitenant container database has many uses and many configurations. Compared to previous versions of Oracle Database, the flexibility of grouping or consolidating databases using the multitenant architecture (compared to using RAC or multiple non-CDB databases on the same server) has increased dramatically while at the same time not increasing the complexity of managing multiple databases within a CDB. In fact, managing multiple PDBs within a CDB not only makes more efficient use of memory and CPU resources but makes it easier to manage multiple databases.
- CDB$ROOT
CDB$ROOT is the first container database created when we create CDB in 12c Multitenant architecture. The CDB root is a system-supplied container that stores common users, which are users that can connect to multiple containers, and system-supplied metadata and data. Each container has its own data dictionary stored in its proper SYSTEM tablespace, containing its own metadata, and a SYSAUX tablespace.
CREATE CONTAINER DATABASE USING DBCA
SELECT CREATE DATABASE and CLICK NEXT.
NEED TO PROVIDE GLOBAL DATABASE NAME AND PASSWORD
SELECT CREATE AS CONTAINER DATABASE OPTION.
CLICK FINISH BUTTON TO COMPLETE DATABASE CREATION
CONTAINER DATABASE CREATED.CLICK CLOSE
WE CAN LOGGING IN AND CHECK WITH GIVEN CONTAINER NAME
WE CAN CHECK THE CDB NAME AND ID USING V$DATABASE
