Re: Rac-Standalone info view
- From: sreejith s <sreejithsna@xxxxxxxxx>
- To: paul.baumgartel@xxxxxxx, alex@xxxxxxxxxxxxxx
- Date: Sun, 06 Feb 2011 20:36:25 +0530
Please check if you get something from v$database?
Sorry, I am away and I cannot check it at the moment.
SSN.
Sent from my Android phone
-----Original Message-----
*From:* Alex List [alex@xxxxxxxxxxxxxx]
*Received:* 06/02/11 12:35 AM
*To:* paul.baumgartel@xxxxxxx [paul.baumgartel@xxxxxxx]
*CC:* oracle-l@xxxxxxxxxxxxx [oracle-l@xxxxxxxxxxxxx]
*Subject:* 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.
Thanks.
Alex
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*
> UBS AG
> IB Accounting Solutions
> 400 Atlantic Street
> Stamford, CT 06904
>
> 203.719.4368
>
> paul.baumgartel@xxxxxxx
> www.ubs.com
>
>
> ------------------------------
> *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 http://www.ubs.com
>
> 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:
