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
