[Oracle 12 c] : Using DBCA to Create a Pluggable Database

select con_id, file_name from cdb_data_files order by 1;

CON_ID FILE_NAME

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

                 1 /u01/app/oracle/oradata/orcl/system01.dbf

                 1 /u01/app/oracle/oradata/orcl/users01.dbf

                 1 /u01/app/oracle/oradata/orcl/undotbs01.dbf

                 1 /u01/app/oracle/oradata/orcl/sysaux01.dbf

SQL> select pdb_id, pdb_name, status from cdb_pdbs;

    PDB_ID PDB_NAME    STATUS
---------- -------------------------------------------------------------------------------------------------------------------------------- ---------
3 PDBORCL    NORMAL
2 PDB$SEED    NORMAL



SQL> select con_id, name, open_mode from v$pdbs;

    CON_ID NAME  OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED  READ ONLY
3 PDBORCL  MOUNTED


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@oracle12c datafile]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 23 18:08:08 2014

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter session set container=PDBORCL ;

Session altered.

SQL> alter pluggable database PDBORCL open read only;


SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/pdborcl/system01.dbf
/u01/app/oracle/oradata/orcl/pdborcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/pdborcl/pdborcl_users01.dbf

SQL> alter session set container = cdb$root;

Session altered.

7 rows selected.

SQL> select con_id , file_name from cdb_data_files;

   CON_ID FILE_NAME
---------- -------------------------------------------
1 /u01/app/oracle/oradata/orcl/system01.dbf
1 /u01/app/oracle/oradata/orcl/sysaux01.dbf
1 /u01/app/oracle/oradata/orcl/undotbs01.dbf
1 /u01/app/oracle/oradata/orcl/users01.dbf
3 /u01/app/oracle/oradata/orcl/pdborcl/system01.dbf
3 /u01/app/oracle/oradata/orcl/pdborcl/sysaux01.dbf
3 /u01/app/oracle/oradata/orcl/pdborcl/pdborcl_users01.dbf

SQL> alter pluggable database PDBORCL close ;

Pluggable database altered.

SQL> select con_id, name, open_mode from v$pdbs ;

    CON_ID NAME  OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED  READ ONLY
3 PDBORCL  MOUNTED

SQL> alter pluggable database PDBORCL open read write;

Pluggable database altered.

SQL> select con_id, name, open_mode from v$pdbs ;

    CON_ID NAME  OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED  READ ONLY
3 PDBORCL  READ WRITE