Close and Open pluggable database

With current 12c and 19c database multitenant databases, we may come across situation where we may need to restart oracle pluggable database. Here we will discuss simple steps to discuss the same.

pluggable database technopdb is 

SQL> show pdbs

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 TECHNOPDB                      READ WRITE NO

SQL>

SQL> alter pluggable database technopdb close;

 

Pluggable database altered.

 

SQL> show pdbs

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 TECHNOPDB                      MOUNTED

SQL>

SQL> alter pluggable database technopdb open;

 

Pluggable database altered.

 SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 TECHNOPDB                      READ WRITE NO

Mostly two commands take care of our task

alter pluggable database technopdb close;

alter pluggable database technopdb open;