Coskan’s Approach to Oracle

December 19, 2008

ORA-29701 when starting oracle during server boot

Filed under: ASM, Tips — coskan @ 6:53 pm

I finally passed 11G New Features exam to upgrade my 10G OCP and now the new target is becoming Managing Oracle on Linux Certified Expert. I will write a blog post about my opinions and my approach to Oracle Certification when I find time,  but now, what I want to write is, a problem I faced during my tests for the exam.

When I was testing to start oracle (ASM Database Listener and dbconsole together) as a service during the server boot , my ASM instance was always failing with the error

“ORA-29701: unable to connect to Cluster Manager”

ASM needs CSS daemons to start before it starts, no matter  the sequence was right(  like below)  ASM wasn’t starting because  CSS daemons wasn’t  starting  in time.

service startup sequence
init.cssd start
dbora start
init.cssd run

On Metalink this problem  listed as  Bug 3458327 . As explained on Metalink Note Id: 264235.1 the workaround is changing the  location of the line in which CSS daemon start  (which is probably at the bottom of inittab) to between run levels rc2.d and rc3.d to make it ready for use of ASM instance like below,

.

l0:0:wait:/etc/rc.d/rc 0
l1:1:wait:/etc/rc.d/rc 1
l2:2:wait:/etc/rc.d/rc 2
h1:35:respawn:/etc/init.t/init.cssd run >/dev/null 2>&1 </dev/null
l3:3:wait:/etc/rc.d/rc 3
l4:4:wait:/etc/rc.d/rc 4
l5:5:wait:/etc/rc.d/rc 5
l6:6:wait:/etc/rc.d/rc 6

Another option is to change your service script to sleep for 120 sec (thanks Martin for correction) but I prefer the one on the top.

Tests are done on 11.1.0.7 running on Oracle EL5

December 17, 2008

ASMLib and undiscovered disks

Filed under: ASM, Tips — coskan @ 1:03 pm

I won’t give any detailed information but just a quick tip for users who are struggling with discovery of disks they mounted by ASM Lib

If you follow the steps as Tim Halls article ASM using ASMLib and Raw Devices normally everthing should go fine,  but somehow,  if your disks are not discovered, you can first follow very well written ASMLib  troubleshooting guide of Jason Arneil.

If checks are ok,  but disks are still not discovered

you should first try to put ORCL:* (Thanks Saurabh- see the comment) to your ASM disk discovery path

Still doesnt work,   like it did not in my case ?

Try this magical discovery path

/dev/oracleasm/disks/*

If you are lucky as me it will work like charm.

The Silver is the New Black Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 193 other followers