如何判断是否实施了Oracle RAC?
发布时间：2018-11-13
方法1：
方法2：
实施了RAC
SQL> showparameter cluster_database;
NAME TYPE VALUE
----------------------------------------------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
未实施RAC
SQL> showparameter cluster_database;
NAME TYPE VALUE
----------------------------------------------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1
方法2：
SQL> selectinst_id,instance_number,instance_name from gv$instance;
INST_ID INSTANCE_NUMBER INSTANCE_NAME
---------- --------------- ----------------
1 1 orcl1
2 2 orcl2
