Re: RAC - Services

  • From: "Shivaswamy Raghunath" <shivaswamykr@xxxxxxxxx>
  • To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • Date: Sat, 14 Apr 2007 07:43:33 -0400

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@xxxxxxxxx> 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
 might possibly be relevant as well.


On 4/13/07, Shivaswamy Raghunath <shivaswamykr@xxxxxxxxx> 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

Other related posts: