Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to check number of active Oracle cluster nodes ?
> Do you want the number of nodes, or the number of instances?
>
> If you want the number of instances, a quick select count(*) from
> gv$instance would tell you the number of currently participating instances.
> And a select instance_name from gv$instance would show you which ones were
> surviving.
>
> As for 'elegant; ways of detecting this, Oracle has lots! Enterprise Manager
> would be your friend here, since it is fully RAC-aware.
>
> Or, if you have a two-node cluster with a single active instance RAC, you
> can install clusters guard, which comes with an Instance Monitor to do very
> much what you want to do.
>
> Regards
> HJR
Well i need to know currently active nodes(using sql-script)and
gv$instance seems to be the perfect solution for me.
Thank you Received on Wed Sep 03 2003 - 03:04:20 CDT