ORA-15064 as per ASM instance founds sessions unresponsive for over 3 mins
(Doc ID 1615459.1)
Last updated on DECEMBER 31, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Problem with a GI configuration (RAC or Oracle Restart / Standalone); ASM has issue to communicate with Database.
this causes a shutdown of the Database instance on one node.
On RDBMS alert, the communication message is causing instance to crash:
Errors in file /export/home/oracle/admin/BSCSPROD/bdump/ibscsprod1_asmb_28606.trc:
ORA-15064: Message 15064 not found; No message file for product=RDBMS, facility=ORA
ORA-03113: Message 3113 not found; No message file for product=RDBMS, facility=ORA
Mon Dec 30 17:33:20 WAT 2013
ASMB: terminating instance due to error 15064
On ASM side, session is not responsive and, then, killed:
WARNING: client [IBSCSPROD1:BSCSPROD] not responsive for 188s; state=0x1. killing pid 28608
Despite registered shortly after (once RDMBS restarts):
NOTE: client IBSCSPROD1:BSCSPROD registered, osid 25758, mbr 0x1
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |