Monday, July 30, 2012

Verify ASMLIB configuration

Usually System Admin will install ASMLIB and create ASM disks Here are a few useful command to verify ASMLIB was configured properly
1 Verfiy rpm installation

rpm -qa|grep oracleasm


2. ASM mount point creation

df -ha|grep oracleasm
oracleasmfs              0     0     0   -  /dev/oracleasm

3 Query and liks ASM disk
/etc/init.d/oracleasm listdisks
/etc/init.d/oracleasm querydisk  


4. Discover asm disks using string 'ORCL:*'

/usr/sbin/oracleasm-discover 'ORCL:*' 

5. Simulate the disk discovery from the operating system level, using tool kfod.  ($ORACLE_HOME/bin). 

$ORACLE_HOME/bin/kfod asm_diskstring='ORCL:*' disks=all

Friday, July 27, 2012

ORA-29701 On Reboot for Non-RAC database Uses ASM


ORA-29701: unable to connect to Cluster Manager

On Server Reboot, Oracle CSS daemon doesn't start in time, then the Automatic Storage
Management (+ASM) instance can't start and therefore all instances are unable to start. 

Solution (according to Note:264235.1)

put the entry in 'inittab' file about the init.cssd script before
running the runlevel 3

example of inittab:

(...)
s2:23:wait:/sbin/rc2 >/dev/msglog 2<>/dev/msglog 
s3:3:wait:/sbin/rc3 >/dev/msglog 2<>/dev/msglog 
s5:5:wait:/sbin/rc5 >/dev/msglog 2<>/dev/msglog 
(...)
h1:3:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1 


you need to change it in this way:


(...)
s2:23:wait:/sbin/rc2 >/dev/msglog 2<>/dev/msglog 
h1:3:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1 
s3:3:wait:/sbin/rc3 >/dev/msglog 2<>/dev/msglog 
s5:5:wait:/sbin/rc5 >/dev/msglog 2<>/dev/msglog 
(...)