.::: Create New Container or add Container CDB in Oracle 19C :::.

 

1. Cek dulu container yang ada

sqlplus sys/oracle as sysdba;

SHOW CON_NAME;
SHOW PDBS;
 

2. Buat PDB baru dari PDB$SEED (template bawaan)

Misalnya mau buat container baru bernama TGHDBHR:

CREATE PLUGGABLE DATABASE TGHDBHR
  ADMIN USER hradmin IDENTIFIED BY hrpass
  FILE_NAME_CONVERT=('/u01/app/oracle/oradata/TGH/pdbseed/',
                     '/u01/app/oracle/oradata/TGH/TGHDBHR/');

3. Buka PDB baru
ALTER PLUGGABLE DATABASE TGHDBHR OPEN;
ALTER PLUGGABLE DATABASE TGHDBHR SAVE STATE;

4. Login ke PDB baru
sqlplus hradmin/hrpass@//localhost:1521/TGHDBHR

atau

ALTER SESSION SET CONTAINER=TGHDBHR;

5. Verifikasi
SHOW CON_NAME;

Kalau berhasil, hasilnya:

CON_NAME
------------------------------
TGHDBHR