GV$ view of ASM instance does not identify other instance in RAC environment

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

1 thought on “GV$ view of ASM instance does not identify other instance in RAC environment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.