_____________________________________________________________________________________ Oracle Database 12c Learning Library https://apexapps.oracle.com/pls/apex/f?p=44785:141:0:::141:P141_PAGE_ID,P141_SECTION_ID:6,18 _____________________________________________________________________________________ CREATE A PDB FROM THE SEED PDB ============================== create pluggable database PDB01 admin user pdb01adm identified by oracle roles = (DBA); -- (No FILENAME CONVERT because of OMF) DROP A PDB ========== alter pluggable database PDB01 close immediate; drop pluggable database PDB01 including datafiles; CONTAINER DB INFORMATION ======================== show con_name show con_id PLUGGABLE DB INFORMATION ======================== select * from v$pdbs; select name, open_mode from v$pdbs; select pdb_name, status from cdb_pdbs order by 1; DATAFILE INFORMATION ==================== set pages 1000 set lines 200 col DB for a10 col TS for a10 col FILE for a100 select 'CDB' "DB", t.name "TS", d.name "FILE" from v$datafile d, v$tablespace t where d.con_id = 1 and d.ts# = t.ts# and d.con_id = t.con_id union select p.name "DB", t.name "TS", d.name "FILE" from v$pdbs p, v$datafile d, v$tablespace t where p.con_id = d.con_id and d.ts# = t.ts# and d.con_id = t.con_id order by 1, 2 ; MISCELLANEOUS ============= alter session set container = pdb01; alter pluggable database all open; alter pluggable database pdb01 open; alter pluggable database all close immediate; alter pluggable database pdb01 close immediate; CREATE A TRIGGER TO OPEN ALL PDBS AFTER CDB STARTUP =================================================== create or replace trigger sys.after_startup after startup on database begin execute immediate 'alter pluggable database all open'; end after_startup; / RENAME THE PDB ============== /* (You must be connected to the PDB to rename it) */ alter pluggable database pdb01 close immediate; alter pluggable database pdb01 open restricted; connect sys/oracle@pdb01 as sysdba; alter pluggable database pdb01 rename global_name to pdb11; alter pluggable database close immediate; alter pluggable database open; select name, open_mode from v$pdbs; TNSNAMES.ORA WITH BOTH CDB AND PDB(S) ===================================== # tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. CDB01 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CDB01.ORACLE.DE) ) ) PDB01 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PDB01.ORACLE.DE) ) ) PDB02 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PDB02.ORACLE.DE) ) ) PDB11 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PDB11.ORACLE.DE) ) )