Re: DBMS_SERVICE create service/start_service and DB Restarts doesn't start service

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 7 Mar 2013 12:09:53 +0000
Message-ID: <CABe10sYJnfRhEmvczwNN9eEj-0NoxAW69HVscOJ9c+bWYB9r_g_at_mail.gmail.com>



Take a look at http://www.ardentperf.com/pub/schneider-services.pdf (and indeed Tim's note). AFAIK everything Jeremy says about service creation in RAC applies to Oracle Restart as well.

On Thu, Mar 7, 2013 at 1:03 AM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> When I add it to SERVICE_NAMES it seems to start correctly.
>
> Any reason not to do that?
>
> Chris
>
> Sent from my mobile device. Please ignore any typos.
>
> On Mar 6, 2013, at 4:21 PM, "Bobak, Mark" <Mark.Bobak_at_proquest.com> wrote:
>
> > Right. You want to add a service via 'srvctl add service ....'.
> >
> > -Mark
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] On Behalf Of Tim Hall
> > Subject: Re: DBMS_SERVICE create service/start_service and DB Restarts
> doesn't start service
> >
> > I think what Michael McMullen was referring to is the big note at the
> top of the CREATE_SERVICE procedure in the documentation that says you
> shouldn't be using this in RAC or Restart configurations :)
> >
> >
> http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_serv.htm#i1001480
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 07 2013 - 13:09:53 CET

Original text of this message