In this post, we can use createPluggableDatabase command creates a pluggable database (PDB) in a multitenant container database (CDB) with DBCA in Oracle 18c.
[oracle@18c admin]$ dbca -silent -createPluggableDatabase -pdbName DBCAPDB -sourceDB CDB18C Enter PDBADMIN User Password: -- Provide password -- Prepare for db operation 13% complete Creating Pluggable Database 15% complete 19% complete 23% complete 31% complete 53% complete Completing Pluggable Database Creation 60% complete Executing Post Configuration Actions 100% complete Pluggable database "DBCAPDB" plugged successfully. Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/CDB18C/DBCAPDB/CDB18C.log" for further details.
Let’s connect to the database and check the PDB is created or not.
[oracle@18c admin]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 Production on Mon Apr 23 15:02:33 2018 Version 18.1.0.0.0 Copyright (c) 1982, 2017, Oracle. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.1.0.0.0 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- --------------- ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB18C1 MOUNTED 4 PDB18C2 READ WRITE NO 5 DBCAPDB READ WRITE NO SQL>
In the next post, we can delete the PDB with DBCA in Oracle 18c.
Stay tuned for more articles on Oracle 18c
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
