Oracle: Basic RAC check

Basic RAC check if nodes are balance. The nodes always taking the loads fairly equally otherwise, there is a problem with load balancing and needs to perform RCA.

SQL> select  inst_id, count(*) from gv$session group by inst_id;

   INST_ID   COUNT(*)

---------- ----------

     1     70

     2     71

SQL> select * from v$active_instances;

INST_NUMBER INST_NAME

----------- ------------------------------------------------------------

      1 chuckwagon:qsr10101

      2 foolsgold:qsr10102

SQL> show parameter remote

NAME                     TYPE    VALUE

------------------------------------ ----------- ------------------------------

remote_archive_enable            string  true

remote_dependencies_mode         string  SIGNATURE

remote_listener              string  LISTENERS_RAC

remote_login_passwordfile        string  EXCLUSIVE

remote_os_authent            boolean     FALSE

remote_os_roles              boolean     FALSE

SQL> 



./runcluvfy.sh stage –pre crsinst –n ORARAC1, ORARAC2 –verbose > runcluvfy_chk.txt

./diagcollection.pl --collect --crs --crshome  $CRS_HOME