How to create new Pluggable database in Oracle Database 19c

 How to create new Pluggable database in Oracle Database 19c

step 1) Source CDB environment and make sure you connected to CDB (root container)

[oracle@ora19cdatabase ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 25 10:57:27 2024

Version 19.22.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.22.0.0.0

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

SQL> show CON_ID

CON_ID

------------------------------

1

SQL> show con_name

CON_NAME

------------------------------

CDB$ROOT

SQL>

step 2) Create Pluggable database

Example:

CREATE PLUGGABLE DATABASE <NEW_PDB_NAME> ADMIN USER pdb_database_admin_user IDENTIFIED BY pdb_database_admin_user_password  
FILE_NAME_CONVERT = (pdbseed_location, new_pdb_location);

    2.1) Check CDB datafiles location:

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/oradata/CDB/system01.dbf

/u01/oradata/CDB/pdbseed/system01.dbf

/u01/oradata/CDB/sysaux01.dbf

/u01/oradata/CDB/pdbseed/sysaux01.dbf

/u01/oradata/CDB/undotbs01.dbf

/u01/oradata/CDB/pdbseed/undotbs01.dbf

/u01/oradata/CDB/users01.dbf

7 rows selected.

SQL>

    2.2) Create directory for new PDB datafiles:

mkdir -p /u01/oradata/PDBTEST

     2.3) Create Pluggable database: 

SQL> CREATE PLUGGABLE DATABASE TEST1 ADMIN USER PDBADMIN IDENTIFIED BY "testpdbadmin_password"

  FILE_NAME_CONVERT=('/u01/oradata/CDB/pdbseed/','/u01/oradata/PDBTEST1');  2

Pluggable database created.

SQL>

    2.3) Check and open Pluggable database in read write mode:  

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         4 TEST1                          MOUNTED

SQL> alter pluggable database TEST1 open;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         4 TEST1                          READ WRITE NO

         2.3) Optional: Save PDB database state:  

SQL> alter pluggable database TEST1 save state;

Pluggable database altered.

SQL>

 

 Happy Learning 👍 Please comment if you need any further details or issues so that I can try my best to answer  👊