1. Environment Check Before Creating the PDB
[oracle@ol8 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 19 10:31:41 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> select name,open_mode,con_id from v$database;
NAME OPEN_MODE CON_ID
--------- -------------------- ----------
OLDB READ WRITE 0
SQL>
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
4 PDB2 READ WRITE NO
SQL> select name,con_id,dbid from v$containers;
NAME CON_ID DBID
-------------------- ---------- ----------
CDB$ROOT 1 3728810340
PDB$SEED 2 958530440
PDB1 3 4152486592
PDB2 4 2067846322
SQL>
SQL> select name from v$datafile where con_id=2;
NAME
--------------------------------------------------
/u01/app/oracle/oradata/OLDB/pdbseed/system01.dbf
/u01/app/oracle/oradata/OLDB/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/OLDB/pdbseed/undotbs01.dbf
SQL>
SQL> select name from v$tempfile where con_id=2;
NAME
--------------------------------------------------
/u01/app/oracle/oradata/OLDB/pdbseed/temp012024-04
-26_16-30-44-811-PM.dbf
2. Creating new PDB using seed (PDB$SEED)
[oracle@ol8 ~]$ mkdir -p /home/oracle/oradata/PDB3
[oracle@ol8 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 19 10:45:45 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
SQL> create pluggable database PDB3 admin user syspdb3 identified by "123"
2 default tablespace PDB3_USERS
3 datafile '/home/oracle/oradata/PDB3/pdb3_users01.dbf' size 250m autoextend on
4 storage (maxsize 1g max_shared_temp_size 1g)
5 file_name_convert=('/u01/app/oracle/oradata/OLDB/pdbseed/','/home/oracle/oradata/PDB3/');
Pluggable database created.
SQL>
SQL> alter pluggable database PDB3 open;
Pluggable database altered.
3. Verify the newly created PDB
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
4 PDB2 READ WRITE NO
5 PDB3 MOUNTED
SQL>
SQL> select name from v$datafile where con_id=5;
NAME
--------------------------------------------------------------------------------
/home/oracle/oradata/PDB3/system01.dbf
/home/oracle/oradata/PDB3/sysaux01.dbf
/home/oracle/oradata/PDB3/undotbs01.dbf
SQL> select name from v$tempfile where con_id=5;
NAME
--------------------------------------------------------------------------------
/home/oracle/oradata/PDB3/temp012024-04-26_16-30-44-811-PM.dbf
SQL> select name,con_id,dbid from v$containers;
NAME CON_ID DBID
-------------------- ---------- ----------
CDB$ROOT 1 3728810340
PDB$SEED 2 958530440
PDB1 3 4152486592
PDB2 4 2067846322
PDB3 5 2487336357
SQL>
Note: All of these things are for educational purposes only.
0 Comments