Database Instance crashes with ORA-15064
Last updated on OCTOBER 03, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Apr-2013***
***Checked for relevance on 10-OCt-2014***
Database instance can terminate intermittently with the following messages in the alert log file:
Errors in file /opt/oracle/diag/rdbms/db/DB/trace/db_arc1_13467.trc:
ORA-03113: end-of-file on communication channel
Session ID: 41 Serial number: 55245
NOTE: deferred map free for map id 41582
System state dump requested by (instance=1, osid=12401 (ASMB)), summary=[abnormal instance termination].
System State dumped to trace file /opt/oracle/diag/rdbms/db/DB/trace/db_diag_12361.trc
Instance terminated by ASMB, pid = 12401
The ASM instance alert log file show that the DB instance was unresponsive and terminating it.
System state dump requested by (instance=2, osid=14572), summary=[SYSTEMSTATE_GLOBAL: global system state dump request (kjdgdss_g)].
System State dumped to trace file /opt/oracle/diag/asm/+asm/+ASM2/trace/+ASM2_diag_22981.trc
Thu Sep 01 00:04:17 2011
WARNING: client [DB:DB] not responsive for 237s; state=0x1. killing pid 12407
Thu Sep 01 00:05:02 2011
The systemstate dump generated at the DB instance at the time of the crash would indicate that the there was a shared pool latch contention at the DB side and ASMB and other processes is intermittently stuck due to that.
Process Group: DEFAULT, pseudo proc: 0x97ce33298
O/S info: user: oracle, term: UNKNOWN, ospid: 12401
OSD pid info: Unix process pid: 12401, image: oracle@sdb-04p (ASMB)
service name: SYS$BACKGROUND
Current Wait Stack:
Not in wait; last wait ended 1.622120 sec ago
There are 35 sessions blocked by this session.
Dumping one waiter:
inst: 1, sid: 969, ser: 35769
wait event: 'latch: shared pool'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms