Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RAC - Services

Re: RAC - Services

From: LS Cheng <exriscer_at_gmail.com>
Date: Sat, 14 Apr 2007 15:46:22 +0200
Message-ID: <6e9345580704140646s3ce6ac55q348387df26bb42e6@mail.gmail.com>


The preferred nodes information is stored in OCR and that is why you can only get it from srvctl

On 4/14/07, Shivaswamy Raghunath <shivaswamykr_at_gmail.com> wrote:
>
> 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#sthref462
> > that 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
Received on Sat Apr 14 2007 - 08:46:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US