Verify if Oracle database is clustered (RAC)

Configurare noua (How To)

Situatie

Solutie

You can query for these background processes to tell if you are using RAC:

select
   name,
   value
from
   v$parameter
where
   name='cluster_database';

NAME                  VALUE
--------------------- ------
cluster_database      TRUE

or

SQL> show parameter cluster_database

NAME             TYPE        VALUE
---------------- ----------- ------
cluster_database boolean     TRUE

 

You can also verify the number of instances of the cluster by:

SQL> select * from v$active_instances;

INST_NUMBER INST_NAME      CON_ID
----------- ---------- ----------
          1 node1:NDI1   0
          2 node2:NDI2   0

SQL> show parameter cluster_database_instances

NAME                         TYPE        VALUE
---------------------------- ----------- ------
cluster_database_instances   integer     2

Tip solutie

Permanent

Voteaza

(29 din 55 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?