There is way to start and stop all pluggable database. you can also use except keyword if you want to skip or add pluggable database. STOP all pluggable database. SQL>ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE; Pluggable database altered. START All pluggable database SQL> ALTER PLUGGABLE DATABASE ALL OPEN READ WRITE;

Pluggable database altered. EXCEPT Keyword to start specific pluggable database . SQL> ALTER PLUGGABLE DATABASE ALL EXCEPT PDBPRIM OPEN READ WRITE; SQL> alter pluggable database all except PDB002,PDBPRIM open; Note : However, if any of your pluggable databases are in READ ONLY mode, then the statement returns the error “ORA-65019: pluggable database PDBPRIM already open” as you can see.