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…

How to rename a Disk in ASM

When create a Diskgroup the ASM diskname is created per default for you. The name of the disk typically looks like Diskgroupname an some Digits. First check your current diskname. SQL>col name format a12 SQL>col path format a30 SQL>SELECT name, path   FROM v$asm_disk   WHERE group_number = (SELECT group_number FROM v$asm_diskgroup WHERE name = ‚DG_DATA‘); NAME         PATH…