Re: Starting named services at DB start
Date: Tue, 17 Aug 2010 14:26:26 +1000
Message-ID: <AANLkTin6D_qF48T=1qpbLtdFR1hmUSNyYfHLqUvTmwc4_at_mail.gmail.com>
Just to let you all know that I tried Mark's suggestion and it seems to work perfectly. I still need to test it a bit more but looks like we're on a winner !!
Thanks a lot Mark.
Cheers,
Steve
On Tue, Aug 17, 2010 at 1:49 PM, Bobak, Mark <Mark.Bobak_at_proquest.com>wrote:
> Glad I could help!
>
>
>
> Let us know if it works.
>
>
>
> Shameless plug:
>
>
>
> MOTS is a month away!
>
>
>
> The Michigan Oak Table Symposium is coming up in Ann Arbor, MI, on Sept
> 16-17th.
>
> Many of the top Oracle speakers in the world will be present, including
> Jonathan Lewis, Cary Millsap, Tanel Poder, and many more!
>
>
>
> For a complete list of speakers, and pricing and registration info, see:
> http://michigan.oaktable.net/
>
>
>
> There are still a few seats left! Sign up now!
>
>
>
> -Mark
>
> *From:* Steve Baldwin [mailto:stbaldwin_at_multiservice.com]
> *Sent:* Monday, August 16, 2010 11:43 PM
> *To:* Bobak, Mark
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Starting named services at DB start
>
>
>
> Thanks Mark !! That's a great idea. I'll give it a go.
>
> Steve
>
> On Tue, Aug 17, 2010 at 12:07 PM, Bobak, Mark <Mark.Bobak_at_proquest.com>
> wrote:
>
> 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,
>
>
>
> -Mark
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Steve Baldwin
> *Sent:* Monday, August 16, 2010 8:49 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Starting named services at DB start
>
>
>
> Hi all,
>
> (Oracle 11.1.0.7)
>
> 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?
>
> Thanks,
>
> Steve
>
>
>
> ---------------------------------------------------------------------------------------
>
> 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.
>
> ---------------------------------------------------------------------------------------
>
>
>
>
>
>
>
> ---------------------------------------------------------------------------------------
>
> 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.
>
> ---------------------------------------------------------------------------------------
>
>
>
>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 16 2010 - 23:26:26 CDT