Re: RAC nodes list?

Try this...

  select a.instance, a.status, a.enabled, b.host_name   from v$thread a, gv$instance b
  where a.thread# = b.thread# (+)

-Rajeev

On 8/2/07, Kerber, Andrew W. <Andrew.Kerber_at_umb.com> wrote:
>
> Srvctl works within sqlplus?
>
>
>
> I want to get the information w/o going to the os. Someone suggested
> v$thread earlier, and that will get me the instance names, but I would also
> like to get the server names if possible.
>
>
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *David Sharples
> *Sent:* Thursday, August 02, 2007 1:31 PM
> *To:* andrew.kerber_at_gmail.com
> *Cc:* oracle-l
> *Subject:* Re: RAC nodes list?
>
>
>
> use the srvctl command
>
> On 02/08/07, *Andrew Kerber* <andrew.kerber_at_gmail.com> wrote:
>
> Does anyone know what table or view will show me what nodes and instances
> are supposed to be in a RAC Cluster, oracle 10.2.0.3? gv$instance will
> give me the instances that are currently up, but I would like to be able to
> query to find out what instances and nodes are supposed to be in the
> cluster.
>
>
> ------------------------------------------------------------------------------
> NOTICE: This electronic mail message and any attached files are
> confidential. The information is exclusively for the use of the individual
> or entity intended as the recipient. If you are not the intended recipient,
> any use, copying, printing, reviewing, retention, disclosure, distribution
> or forwarding of the message or any attached file is not authorized and is
> strictly prohibited. If you have received this electronic mail message in
> error, please advise the sender by reply electronic mail immediately and
> permanently delete the original transmission, any attachments and any copies
> of this message from your computer system. Thank you.
>
>
> ==============================================================================
>

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