Thursday, February 28, 2013

HOW TO FIND IF A DATABASE IS A RAC DATABASE OR A STANDALONE DATABASE


USING PARAMETERS :


SQL> show parameter CLUSTER_DATABASE;

NAME                                 TYPE        VALUE
               
cluster_database                     boolean     TRUE
cluster_database_instances           integer     2


Or  you can check in parameter file from $ORACLE_HOME/dbs

*.cluster_database=TRUE

If  the value for cluster_database is  "TRUE"  the it means that the node is RAC enabled.

OR

SQL> select name, value from v$parameter where name=’cluster_database’;

NAME VALUE
——————— ———————
cluster_database TRUE

OR

USING PL/SQL PACKAGE


set serveroutput on
BEGIN
IF dbms_utility.is_cluster_database THEN
dbms_output.put_line(‘Running in SHARED/RAC mode.’);
ELSE
dbms_output.put_line(‘Running in EXCLUSIVE mode.’);
END IF;
END;
/

Running in SHARED/RAC mode.
PL/SQL procedure successfully completed.

You can tell how many instances are active by:-


SQL> select * from v$active_instances;

INST_NUMBER   INST_NAME

  1             Stage1
  2             Stage2