Re: Check for Database type(RAC,OPS or Standard)

From: Howard J. Rogers <howardjr20002_at_yahoo.com.au>
Date: Thu, 10 Apr 2003 13:42:43 +1000
Message-ID: <AA5la.10931$1s1.174147@newsfeeds.bigpond.com>

"sarab" <sarabjeetd_at_hotmail.com> wrote in message news:x72la.573$Na4.140_at_news.cpqcorp.net...
> Hi ALL,
> Which table can tell if the oracle database is a RAC or OPS or
> Standard?

Well, you could do select count(*) from gv$instance. If it's anything more than 1, you have a RAC/OPS database. Or you could select * from v$option and see whether RAC/OPS is an installed option. Or you could select * from v$parameter where name='cluster_database'. If it's true, then regardless of the number of instances you actually have running, you have a RAC/OPS-capable instance.

Or did I misunderstand the question?

Regards
HJR
>
> thanks
> -sarab
>
>
>
Received on Wed Apr 09 2003 - 22:42:43 CDT