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

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

Follow

Get every new post delivered to your Inbox.

Join 199 other followers