DB Wiki

SQL> alter session set container = pdb2;

Session altered.

SQL> shutdown 
Pluggable Database closed.
SQL> startup
Pluggable Database opened.
SQL> alter pluggable database pdb2 close;

Pluggable database altered.

SQL> alter pluggable database pdb2 open;

Pluggable database altered.

I think it always safer to use the “alter pluggable” command so you definitely know which database you are closing.

Sometimes you may get an error when opening a pluggable database

SQL> alter pluggable database pdb2 open;

Warning: PDB altered with errors.

The “show pdbs” reveals that pluggable database pdb2 has been opened in restricted mode.

SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 PDB1 			  READ WRITE NO
	 4 PDB2 			  READ WRITE YES

Use the view PDB_PLUG_IN_VIOLATIONS to see what the error is.
Thr full error message is not always written to the Alert Log. </code>select time, message, from pdb_plug_in_violations;

TIME MESSAGE ————————- ——————————————————————————– 28-JUL-15 08.59.31.507182 Sync PDB failed with ORA-959 during 'CREATE USER c##ian IDENTIFIED BY *DEFAULT T

                        ABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" container = all'</code>
                        

In the above case I had forgotten to create the tablespace users in database pdb2.