Query on v$asm% views give ORA-3113. The alert log shows ORA-7445[PC:0x0]

(Doc ID 816993.1)

Last updated on JANUARY 23, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
UnitedLinux (32-bit)
IBM: Linux on System z
Linux x86
IBM: Linux on POWER Systems
Generic Linux
Miracle Linux x86
Haansoft Linux Itanium
Embedded Linux SH4
Red Hat Enterprise Linux Advanced Server x86-64 (AMD Opteron Architecture)
Oracle Enterprise Linux 4.0
IBM S/390 Based Linux (31-bit)
Red Hat Enterprise Linux Advanced Server Itanium
x86 64 bit
Miracle Linux x86-64
SUSE \ UnitedLinux x86-64
Linux x86-64
Haansoft Linux x86
z*OBSOLETE: IBM Linux on POWER Systems - alternate
x86 32 bit
Miracle Linux Itanium
Red Hat Enterprise Linux Workstation
UnitedLinux Itanium
Haansoft Linux x86-64
Embedded Linux xScale
Linux Itanium
***Checked for relevance on 21-Jan-2011***


Symptoms

Note: This issue may be also applicable to 10gR2

ASM instance is up and running but any queries on v$asm views give only errors and ORA-7445[PC:0X0] are shown in the ASM instance's alert log.

v$asm% queries fail with:

SQL> select name,state from v$asm_diskgroup; 
select name,state from v$asm_diskgroup 

ERROR at line 1: 
ORA-03113: end-of-file on communication channel  
Process ID: 18655 
Session ID: 97 Serial number: 563 


Error in the ASM instance's alert log: 

...
Thu Apr 30 09:58:34 2009 
ERROR:lib:/opt/oracle/extapi/64/asm/orcl/1/libasm.so Open err: /opt/oracle/extapi/64/asm/orcl/1 
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x0, {empty}] 
Errors in file /c1/app/oracle/diag/asm/+asm/+ASM2/trace/+ASM2_ora_17763.trc (incident=12161): 
ORA-07445: exception encountered: core dump [PC:0x0] [SIGSEGV] [ADDR:0x0] [PC:0x0] [Address not mapped to object] []  
Incident details in: /c1/app/oracle/diag/asm/+asm/+ASM2/incident/incdir_12161/+ASM2_ora_17763_i12161.trc 
Thu Apr 30 09:58:36 2009 
Trace dumping is performing id=[cdmp_20090430095836]
...

@For Oracle Support:

@Call stack functions: skdstdst << ksedst1 << ksedst << dbkedDefDump << ksedmp << ssexhd 

 
If the ASM instance is restarted, no diskgroups will be mounted.

The ASM instance's alert log will show:

...
WARNING::lib=/opt/oracle/extapi/64/asm err:9 rc:Directory does not exist 
... 
...<truncated for space savings and to show relevant entries only> 
... 
ERROR: no PST quorum in group 1: required 2, found 0 
NOTE: cache dismounting group 1/0xFFB79951 (DATA1) 
NOTE: dbwr not being msg'd to dismount 
NOTE: lgwr not being msg'd to dismount 
NOTE: cache dismounted group 1/0xFFB79951 (DATA1) 
kfdp_dismount(): 2 
kfdp_dismountBg(): 2 
ERROR: diskgroup DATA1 was not mounted 
ERROR: no PST quorum in group 2: required 2, found 0 
NOTE: cache dismounting group 2/0xFFC79952 (FLASH1) 
NOTE: dbwr not being msg'd to dismount 
NOTE: lgwr not being msg'd to dismount 
NOTE: cache dismounted group 2/0xFFC79952 (FLASH1) 
kfdp_dismount(): 4 
kfdp_dismountBg(): 4 
ERROR: diskgroup FLASH1 was not mounted 
ORA-15032: not all alterations performed 
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FLASH1" 
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA1" 
ERROR: ALTER DISKGROUP ALL MOUNT 
...

 

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