Chapter 9: Creating a New PDB with DBCA

Export variables

export ORACLE_SID=FREE
export ORAENV_ASK=NO
. /opt/oracle/product/23ai/dbhomeFree/bin/oraenv

Launch DBCA

cd $ORACLE_HOME/bin

./dbca

CREATE PLUGGABLE DATABASE FREEPDB2
ADMIN USER FREEPDB2_ADMIN IDENTIFIED BY qADvT947mpU3
ROLES = (dba)
DEFAULT TABLESPACE users
DATAFILE '/opt/oracle/oradata/CDB/FREE/users01.dbf' SIZE 250M AUTOEXTEND ON;