In 11.2.0.2, Selects From GV$ Views Fails and gives IPC Send timeout Errors (Doc ID 1329218.1)

Last updated on JANUARY 14, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2.0 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

Ref: 2 node RAC - 11.2.0.2.2(asm) - Solaris10

Selecting from gv$ views fails in ASM after upgrade to 11.2.0.2


select gv$asm_diskgroup.GROUP_NUMBER||'|'||gv$instance.INSTANCE_NAME||'|'||gv$asm_diskgroup.NAME||'|'||round(gv$asm_diskgroup.TOTAL_MB)||'|'||
round(gv$asm_diskgroup.FREE_MB)||'|'||round(gv$asm_diskgroup.USABLE_FILE_MB)||'|'||nvl(gv$asm_diskgroup.TYPE, 'DBCA_NULL')||'|'||gv$asm_diskgroup.STATE||'|'||
nvl(gv$asm_diskgroup.COMPATIBILITY, 'DBCA_NULL')||'|'||nvl(gv$asm_diskgroup.DATABASE_COMPATIBILITY, 'DBCA_NULL')
from gv$instance,gv$asm_diskgroup where gv$instance.INST_ID=gv$asm_diskgroup.INST_ID order by NAME;


alert_+ASM2.log:

...
Wed Jun 01 18:02:26 2011
IPC Send timeout detected. Sender: ospid 248 [oracle@ny-dw-db2 (PZ99)]
Receiver: inst 1 binc 4 ospid 21570
...

Also, ASMCA does not display any details for ASM disk groups.

However ASM seems otherwise to be functioning properly (disk groups mounted, etc.) after the upgrade to 11202.


Other details
~~~~~~~~~~~~~~~
* RECENT CHANGES : upgrade to 11.2.0.2
* O/S DETAILS : SunOS 5.10
* Cluvfy show MTU 9000 for interconnect interface.

.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms