Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RAC nodes list?

Re: RAC nodes list?

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 3 Aug 2007 07:20:05 -0500
Message-ID: <ad3aa4c90708030520i10f88704gb7bcfa39e48a8620@mail.gmail.com>


gv$instance only shows those nodes that are up. I would like to see both those are up and those that are supposed to be up.

On 8/2/07, Caviness, Jay A <Jay.Caviness_at_mckesson.com> wrote:
>
> You can look at gv$instance which will give you the host name for each
> instance currently on your cluster
>
>
> Thanks,
>
> Jay
>
> Jay Caviness Horizon Clinicals
> Systems Engineering
> Sr. Systems Engineer - Oracle DBA McKesson Information Solutions
> jay.caviness_at_mckesson.com 285 Century Place
> 303-926-2444 Louisville, CO
> 80027
>
> I gotta fever...and the only prescription for it is ... MORE COWBELL!
>
>
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Tim Gorman
> *Sent:* Thursday, August 02, 2007 3:25 PM
> *To:* oracle-l
> *Subject:* Re: RAC nodes list?
>
> Query V$THREAD. It may not have all the information you want, but the
> rows are always there even if the instances aren't up...
>
> Tim Gorman
> consultant - Evergreen Database Technologies, Inc.
> P.O. Box 1802, Evergreen CO 80437-1802
> website = http://www.evdbt.com
> email = tim_at_evdbt.com
> mobile = +1-303-885-4526
> fax = +1-303-484-3608
>
>
>
> Kerber, Andrew W. 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 <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
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 03 2007 - 07:20:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US