_____________________________________________________________________________________

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)
    )
  )