Critical Patch Update for July 2016 Now Available

The Critical Patch Update (CPU) for July 2016 was released on July 19, 2016 and Oracle strongly recommends applying the patches as soon as possible. A good starting Point will be the Critical Patch Update Advisory, it includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and…

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…