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

About these ads

3 Comments »

  1. Hi:
    I had the same problem during the upgrade of the Oracle VM template 11.1.0.6 to 11.1.0.7 using the patchset available at Metalink.
    I am using an OEL5 virtual machine.
    Best regards, Marcelo.

    Comment by Marcelo Ochoa — December 20, 2008 @ 3:29 pm

  2. Hi,
    I’ sure it’s just a typo in your blog, but Note:264235.1 talks about a asleep of 120 which are seconds, not minutes (what would make little sense.)
    Thank you to point us to this issue!
    cheers,
    Martin

    Comment by Martin Berger — December 21, 2008 @ 7:14 pm

  3. Thank you for correction Martin it was a friday post I was in hurry for the pints :)

    MArcelo, there is another issue related with this error..
    please check the forum thread below

    http://forums.oracle.com/forums/message.jspa?messageID=2246572

    Comment by coskan — December 21, 2008 @ 8:58 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Theme: Silver is the New Black. Get a free blog at WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 205 other followers

%d bloggers like this: