PDB Auto start with CDB in 12c

[oracle@jdedb01 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 9 20:27:25 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 8053063680 bytes

Fixed Size                  3729840 bytes

Variable Size            1879049808 bytes

Database Buffers         6157238272 bytes

Redo Buffers               13045760 bytes

Database mounted.

Database opened.

SQL> select name,open_mode from v$pdbs;

NAME                           OPEN_MODE

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

PDB$SEED                       READ ONLY

JDEORCL                        MOUNTED

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> select name,open_mode from v$pdbs;

NAME                           OPEN_MODE

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

PDB$SEED                       READ ONLY

JDEORCL                        READ WRITE

SQL> alter pluggable database JDEORCL save state;

Pluggable database altered.

SQL> select CON_ID,CON_NAME,INSTANCE_NAME,STATE from dba_pdb_saved_states;

    CON_ID CON_NAME   INSTANCE_NAME      STATE

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

         3 JDEORCL    ORA12C             OPEN

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 8053063680 bytes

Fixed Size                  3729840 bytes

Variable Size            1879049808 bytes

Database Buffers         6157238272 bytes

Redo Buffers               13045760 bytes

Database mounted.

Database opened.

SQL> select name,open_mode from v$pdbs;

NAME                           OPEN_MODE

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

PDB$SEED                       READ ONLY

JDEORCL                        READ WRITE

Note:

Set restart of specific database

altar pluggable database pdb_name save state;

Restart of all PDB’s :

altar pluggable database all save state;

we use this to keep the state of all but a few with the except clause:

altar pluggable database all except pdb_name1, pdb_name2 save state;