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”

Vijay April 26, 2020 at 9:13 pm

Thanks, Mate. Your article came to my timely rescue today.

LikeLike

Reply ↓

Smart way of Technology

Worked in Database technology for fixed the issues faced in daily activities in Oracle, MS SQL Server, MySQL, MariaDB etc.

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