Re: Rac-Standalone info view

From: Mark Brinsmead <pythianbrinsmead_at_gmail.com>
Date: Sun, 6 Feb 2011 17:50:27 -0500
Message-ID: <AANLkTintBT5mRrVp+tqODhQnD4-UZYc-O1LW_d-2nvYM_at_mail.gmail.com>

Working from member (no database handy at the moment) that would be something like:

SELECT name, type, value
 FROM v$parameter
WHERE name like '%cluster%';

On Sat, Feb 5, 2011 at 2:04 PM, Alex List <alex_at_octanti.com.br> wrote:

> 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_at_ubs.com> 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_at_ubs.com
>> www.ubs.com
>>
>>
>> ------------------------------
>> *From:* oracle-l-bounce_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *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.
>>
>
>

-- 
Cheers,
-- Mark Brinsmead
   Senior DBA,
   The Pythian Group
   http://www.pythian.com/blogs

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

Received on Sun Feb 06 2011 - 16:50:27 CST