GV$ view of ASM instance does not identify other instance in RAC environment
Error
ASM instance does not identify other instance in RAC Environment:
We have a 2 node RAC cluster on 12.2 on Solaris.
The cluster is up and running but querying gv$instance view of ASM instance does not show both instances. It only shows local instance info.
select count(*) from gv$instance;
COUNT(*)
----------
1
Cause
Check the node is in rolling upgrade state
sqlplus / as sysasm
From node1 ASM instance:
SQL> select sys_context ('sys_cluster_properties','cluster_state') from dual;
SYS_CONTEXT('SYS_CLUSTER_PROPERTIES','CLUSTER_STATE')
--------------------------------------------------------------------------------
In Rolling Upgrade
From node2 ASM instance:
SQL> select sys_context ('sys_cluster_properties','cluster_state') from dual;
SYS_CONTEXT('SYS_CLUSTER_PROPERTIES','CLUSTER_STATE')
--------------------------------------------------------------------------------
In Rolling Upgrade
Solution
1. Check the patch level at both NODE is equal.
kfod op=patchlvl
kfod op=patches
crsctl query crs activeversion -f
2. Stop the rolling migration from SQLPLUS (no downtime required)
sqlplus / as sysasm
alter system stop rolling migration;
3. Verify the nodes from asm
select count(*) from gv$instance;
COUNT(*)
----------
2
Thanks, Mate. Your article came to my timely rescue today.
LikeLike