Oracle 19c: Creation of Container Database and Creation of PDB from PDBSEED

This video tutorial is for Oracle 19c Container database creation using DBCA, then we will manually create PDB from PDBSEED. It will also show several very useful queries to monitor your CDB and PDBs.

The software and versions used in this video

Virtualbox 6.1.22
Oracle Linux 7
Oracle Database Enterprise Edition Release 19.0.0.0.0 Production Version 19.3.0.0.0
Wondershare Filmora for video editing

Scripts to monitor container database and pluggable databases

** To check if container database processes is running

ps -ef|grep cdb2

** To get container database information in V$DATABASE

select name, cdb, con_id from v$database;

** To get container database information in V$INSTANCE

select INSTANCE_NAME, STATUS, CON_ID from v$instance;

** To check services created for container database and/or PDBs

select name, con_id from v$services;

** To verify container name, you currently connected

show con_name

** To verify container ID of container name you are currently connected

show con_id

** Query to get PDB information using CDB_PDBS

col PDB_NAME format a8
col CON_ID format 99
select PDB_ID, PDB_NAME, DBID, GUID, CON_ID from cdb_pdbs;

** Q uery to check LOGFILE members for CDB

col MEMBER format A40
select GROUP#, CON_ID, MEMBER from v$logfile;

** To check CONTROLFILE information for CDB

col NAME format A60
select NAME , CON_ID from v$controlfile;

** To check DATAFILE information for CDB & PDBs

col file_name format A50
col tablespace_name format A8
col file_id format 9999
col con_id format 999
select FILE_NAME, TABLESPACE_NAME, FILE_ID, con_id
from cdb_data_files order by con_id ;

** To check DATAFILE & TABLESPACE information for CDB you currently connected

col file_name format A42
select FILE_NAME, TABLESPACE_NAME, FILE_ID
from dba_data_files;

** To check TABLESPACE information for CDB & PDBs

col NAME format A12
from v$datafile d, v$tablespace ts
order by 4,3;

** To check TEMPFILES information for CDB & PDBSEED

col file_name format A57
select FILE_NAME, TABLESPACE_NAME, FILE_ID
from cdb_temp_files;

** To check user SYSTEM for CDB, PDBSEED & PDBs

col username format A22
select username, common, con_id from cdb_users
where username ='SYSTEM';

** To check COMMON Users

select distinct username from cdb_users
where common ='YES';

** To check NON-COMMON Users

select distinct username, con_id from cdb_users
where common ='NO';

** To check COMMON Roles

col role format A30
select role, common, con_id from cdb_roles;

** To check SYS and TABLES Privileges

desc CDB_SYS_PRIVS
desc CDB_TAB_PRIVS

====

Enjoy learning! To God be the Glory!