Wanted to confirm whether database was running RAC - easy way is to use
show parameter CLUSTER_DATABASE
or use the following:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
SQL> BEGIN
2 IF dbms_utility.is_cluster_database THEN
3 dbms_output.put_line('Running in SHARED/RAC mode.');
4 ELSE
5 dbms_output.put_line('Running in EXCLUSIVE mode.');
6 END IF;
7 END;
8 /
PL/SQL procedure successfully completed.
SQL> set serveroutput on
SQL> /
Running in EXCLUSIVE mode.
PL/SQL procedure successfully completed.
Also quick check :
cluvfy comp healthcheck
and node connectivity check
cluvfy comp nodecon -n ora01b,ora02b,ora03b,ora04b -verbose
No comments:
Post a Comment