Creating a Pluggable Database in Database 12c

Creating a pluggable database :

> CONN / AS SYSDBA
> CREATE PLUGGABLE DATABASE pdborcl ADMIN USER pdb_adm IDENTIFIED BY Admin123 FILE_NAME_CONVERT=('/u01/app/oracle/oradata/orcl/pdbseed/','/u01/app/oracle/oradata/orcl/pdborcl/');

Modify the listener.ora file as below:

SID_LIST_LISTENER= 

  (SID_LIST= 

    (SID_DESC= 

      (GLOBAL_DBNAME=orcl) 

      (SID_NAME=orcl)) 

    (SID_DESC= 

       (GLOBAL_DBNAME=pdborcl) 

       (SID_NAME=pdborcl))   

    ) 

Add the pluggable database entry in tnsnames.ora file:

PDBORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = pdborcl)

    )

  )

Command for opening the pluggable databases:

For opening all pluggable databases at a time

> CONN / AS SYSDBA

>ALTER PLUGGABLE DATABASE ALL OPEN;

To open individual pluggable database 

>ALTER PLUGGABLE DATABASE pdborcl OPEN;

Command for closing the pluggable databases:

For closing all pluggable databases at a time

> CONN / AS SYSDBA

>ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE;

To close individual pluggable database 

>ALTER PLUGGABLE DATABASE pdborcl CLOSE IMMEDIATE;

Command for checking the open pluggable databases:

> CONN / AS SYSDBA

>SELECT name, open_mode FROM v$pdbs;

Trigger for starting all the pluggable database at the CDB startup time:

> CONN / AS SYSDBA

>CREATE OR REPLACE TRIGGER open_pdbs

  AFTER STARTUP ON DATABASE

BEGIN

   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';

END open_pdbs;

/

Command to display the current container:

> CONN / AS SYSDBA

>SHOW CON_NAME;

Command to switch between the containers:

> CONN / AS SYSDBA

>ALTER SESSION SET container = pdborcl;

Connecting to a Pluggable Database (PDB):

> CONN system/password@//localhost:1521/pdborcl