Re: RAC nodes list?
- From: "Rajeev Prabhakar" <rprabha01@xxxxxxxxx>
- To: Andrew.Kerber@xxxxxxx
- Date: Thu, 2 Aug 2007 17:14:40 -0400
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@xxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *David Sharples
> *Sent:* Thursday, August 02, 2007 1:31 PM
> *To:* andrew.kerber@xxxxxxxxx
> *Cc:* oracle-l
> *Subject:* Re: RAC nodes list?
>
>
>
> use the srvctl command
>
> On 02/08/07, *Andrew Kerber* <andrew.kerber@xxxxxxxxx> 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.
>
>
> ==============================================================================
>
Other related posts:
