12c Pluggable database autostart

Before Version 12.1.0.2 whenever a container database was started all the pluggable databases associated with container database remains in MOUNT state. The workaround was to write a database startup trigger to open PDB during container startup. A Basic example can found on MOS Note: 1594901.1 12c Pluggable Database is closed on restart of Computer If…

Clone a PDB

When you want to clone a PDB (in the same CDB) then there few simple steps to do. Check your Database Parameters Connect to your CDB Stop the source PDB (hope this step will not be necessary in future releases) Clone the PDB Open the PDB Step 1: Check your Database Parameters We want to…

Convert a non PDB to a PDB

When you want to convert a Single Instanz (non PDB) to a PDB (for example after a pre 12c Database upgrade) then this example is usefull for you. First here is a overview of the task: Open the database in read only mode Create a xml File for the conversion Login into your CDB Plug…