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…

sqlplus preliminary connection

Some time ago a customer had problems with a application that generates many blocking sessions. In the end all the blocking session grow up and exceeds the avaible processes on the database so that the ORA-00020 maximum number of processes exceeded error occur. The customer also ask me, to analyze the problem to know which…