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…

CRS-1136 when upgrading Clusterware to 12.1.0.2

Recently I have tried to upgrade the Clusterware from 12.1.0.1 to 12.1.0.2 on a two node Linux cluster. After starting the rootupgrade.sh I got the following error. CRS-1136: Rejecting the rolling upgrade mode change because the cluster is being patched. CRS-4000: Command Start failed, or completed with errors. 2014/08/07 12:48:41 CLSRSC-511: failed to set Oracle…

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…