Oracle - Can we test if a database is running in RAC mode? How? posted by
Babu Kunwar
Can we test if a database is running in RAC mode? How?
Yes we can test the status of database. There are several ways to check the
status of the RAC. The srvctl utility shows the current configuration and
status of the RAC database.
$ srvctl config database -d RAC
rac1 RAC1 /u01/app/oracle/product/10.2.0/db_1
rac2 RAC2 /u01/app/oracle/product/10.2.0/db_1
$
$ srvctl status database -d RAC
Instance RAC1 is running on node rac1
Instance RAC2 is running on node rac2
$
The V$ACTIVE_INSTANCES view can also display the current status of the
instances.
SQL> SELECT * FROM v$active_instances;
|
