Re: Rac-Standalone info view

Is there another way to get these values through a view or something
(select) ??

My application will connect and then verify preferably by "select" if its a
Cluster or Standalone DB.


On Sat, Feb 5, 2011 at 16:52, <paul.baumgartel@xxxxxxx> wrote:

>  Instance parameters cluster_database and cluster_database_instances will
> tell you:
> SQL> show parameter cluster
> NAME                                 TYPE        VALUE
> ------------------------------------ ----------- -----
> cluster_database                     boolean     TRUE
> cluster_database_instances           integer     3
> cluster_interconnects                string
> *Paul Baumgartel*
> IB Accounting Solutions
> 400 Atlantic Street
> Stamford, CT 06904
> 203.719.4368
> paul.baumgartel@xxxxxxx
>  ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Alex List
> *Sent:* Saturday, February 05, 2011 1:37 PM
> *To:* Oracle I List
> *Subject:* Rac-Standalone info view
> Hi,
> I was trying to find out which view could provide me information if I am
> logged on Rac or Standalone instance.
> Disregard many ways to look for this info, but considering only when
> connected, and through the views find out if I am logged in a Standalone or
> in a Rac Instance.
> According to the database connection I have to enable or disable some
> features in my application, that's why I am looking for this.
> Thank you in advance.
> Alex
> Visit our website at
> This message contains confidential information and is intended only
> for the individual named.  If you are not the named addressee you
> should not disseminate, distribute or copy this e-mail.  Please
> notify the sender immediately by e-mail if you have received this
> e-mail by mistake and delete this e-mail from your system.
> E-mails are not encrypted and cannot be guaranteed to be secure or
> error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses.  The sender
> therefore does not accept liability for any errors or omissions in the
> contents of this message which arise as a result of e-mail transmission.
> If verification is required please request a hard-copy version.  This
> message is provided for informational purposes and should not be
> construed as a solicitation or offer to buy or sell any securities
> or related financial instruments.
> UBS reserves the right to retain all messages. Messages are protected
> and accessed only in legally justified cases.

Other related posts: