Re: Check for database type - RAC , OPS or Standard

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Thu, 10 Apr 2003 04:10:51 GMT
Message-ID: <BABA3CD8.FC08%markbtownsend@attbi.com>

in article 0q2la.575$La4.459_at_news.cpqcorp.net, sarab at sarabjeetd_at_hotmail.com wrote on 4/9/03 4:55 PM:

> Hi ALL,
> Which table can tell if the oracle database is a RAC or OPS or
> Standard?
>
> thanks
> -sarab
>

Well - to tell what's been installed, check the following. What's been licenced is of course a seperate check (with your account rep)

For options and features, check V$OPTION

SQL> select * from v$option;

PARAMETER                                VALUE
---------------------------------------- ------------------------------
Partitioning                             TRUE
Objects                                  TRUE
Real Application Clusters                FALSE
Advanced replication                     TRUE

<snip>

48 rows selected.

For edition, check v$version

SQL> select * from v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Developer's Rele PL/SQL Release 9.2.0.1.0 - Developer's Release CORE 9.2.0.1.0 Production
TNS for MacOS X Server: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production Received on Wed Apr 09 2003 - 23:10:51 CDT