Create pluggable database(PDB) - demo

How to create pluggable database pdb

SQL> create pluggable database pdb_name
     admin user pdbuser identified by password;

How to open,close,read only pdb

SQL> alter pluggable database pdb_name open|
                                       close|

                                       read only;

In session I am going to demostrate 

1. Create PDB
2. Open PDB
3. Close PDB

View - v$pdbs , v$active_services,

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77

SQL> show parameter db_file_name_convert NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string pdb_file_name_convert string SQL>select name,con_name,con_id from v$active_services NAME CON_NAME CON_ID ------------------------------ ------------------------------ ---------- pdborcl.localdomain PDBORCL 3 orclXDB CDB$ROOT 1 orcl.localdomain CDB$ROOT 1 SYS$BACKGROUND CDB$ROOT 1 SYS$USERS CDB$ROOT 1 SQL> select name,con_id,con_uid,open_mode from v$pdbs; NAME CON_ID CON_UID OPEN_MODE ------------------------------ ---------- ---------- ---------- PDB$SEED 2 4068245421 READ ONLY PDBORCL 3 2272803820 MOUNTED SQL> create pluggable database aamir 2 admin user aamir_admin identified by aamir; admin user aamir_admin identified by aamir * ERROR at line 2: ORA-65016: FILE_NAME_CONVERT must be specified SQL> alter system set db_create_file_dest='/u01/oradata/orcl/cltst12c'; System altered. SQL> show parameter db_create_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_file_dest string /u01/oradata/orcl/cltst12c SQL> SQL> create pluggable database aamir admin user aamir_user identified by aamirpassword Pluggable database created. SQL> select con_id,open_mode,name from v$pdbs; CON_ID OPEN_MODE NAME ---------- ---------- ------------------------------ 2 READ ONLY PDB$SEED 3 MOUNTED PDBORCL 4 MOUNTED AAMIR SQL> c/opne/open 1* alter pluggable database aamir open SQL> / Pluggable database altered. SQL> select name,con_id,open_mode from v$pdbs; NAME CON_ID OPEN_MODE ------------------------------ ---------- ---------- PDB$SEED 2 READ ONLY PDBORCL 3 MOUNTED AAMIR 4 READ WRITE SQL> SQL> SQL> alter pluggable database aamir close; Pluggable database altered.

Thanks
Click for Reference Link