Re: RAC - Services

Thanks for your replies.

Probably I should have been more specific. I want to see which are the preferred nodes for a given service and on which available nodes the service will run. What are its TAF properties (basic? None, Preconnect?). I do not think, these do appear on a view that can be queries from sqlplus.

 Above information is available thru SRVCTL. And of course, I have queried the %SERVICE% views. before asking and I did not find them giving this info.

On 4/13/07, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> well now, I wonder if there could possibly be any views relevant to
> services already in the database, DBA_SERVICES perhaps, or ALL_SERVICES.
> Maybe you should take a look. Then again there's also the services section
> of the administrators guide to read
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref462that might possibly be relevant as well.
>
> Niall
>
> On 4/13/07, Shivaswamy Raghunath <shivaswamykr_at_gmail.com> wrote:
> >
> > Hello.
> >
> > How can I get the information of the services running on the RAC
> > instances from SQLPLUS? I know that, I can use EM or DBCA to get the info. I
> > can use srvctl quickly and effeciently to get still more results including
> > TAF.
> >
> > But other than, gv$parameter where name like '%SERV%', which gives very
> > little info, I did not find much useful info to get the information of the
> > services.
> >
> > Do you something more helpful?
> >
> > Thanks,
> > Shiva
> >
> >
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l