RE: Starting named services at DB start

From: Bobak, Mark <>
Date: Mon, 16 Aug 2010 22:07:11 -0400
Message-ID: <>

Hi Steve,

We have 10.2, 11.1, and 11.2 RAC, but I'm only using named services on 11.2, so, I never noticed it before.

I don't think you missed anything. Looks like it's not there in 11.1 or earlier versions.

One thought, totally untested and pure speculation:

How about a database startup trigger that calls dbms_service.start_service?

Hope that helps,


From: [] On Behalf Of Steve Baldwin Sent: Monday, August 16, 2010 8:49 PM
Subject: Starting named services at DB start

Hi all,


We're using named services to implement application node affinity on a RAC database. These services were created using :

srvctl add service -s srv_xxx -d rac11d -r rac11d2 -a rac11d1 -P BASIC

When the database starts up these services need to be started explicitly using :

srvctl start service -d rac11d -s srv_xxx

I see that in 11.2 the srvctl add service command takes a '-y AUTOMATIC' to start the service when the DB starts. Is there an option in 11.1 that I've missed or is it just not there?



This email is intended solely for the use of the addressee and may

contain information that is confidential, proprietary, or both.

If you receive this email in error please immediately notify the

sender and delete the email.

-- Received on Mon Aug 16 2010 - 21:07:11 CDT

Original text of this message