[Oracle 12c] Exploring the Multitenant Architecture: CDBs and PDBs
Hello guys, I have been studying Oracle 12c as a preparation for my upgrade certification. And this will be my second article on Oracle 12c. I have a bunch of scratch notes on 12c but I have a lot of deployments: upgrades and migration to 12c so, I haven't finalize most of them. This simple article presents how to create Pluggable Databases (PDBs) from the seed PDB. Remember that we can also create (clone) PDBs using an existing regular PDB. Let begin by familiarizing ourselves with the root CDB or the CDB$ROOT How to connect to a CDB? [oracle@orcl12c-serv01 ~]$ echo $ORACLE_SID ORCLDB [oracle@orcl12c-serv01 ~]$ echo $ORACLE_HOME /u01/app/oracle/product/12.1.0/db_1 [oracle@orcl12c-serv01 ~]$ sqlplus / as sysdba SQL> show con_name CON_NAME ------------- CDB$ROOT --> This is our current container, which is the ROOT CDB. Connecting to a CDB is the same as you connect with the regular, non-container database (11g and below). Wha