SQL Jobs Hits Error ORA-27614 and Crashes (Doc ID 2193671.1)

Last updated on NOVEMBER 24, 2016

Applies to:

Oracle Exadata Storage Server Software - Version 12.1.1.1.1 and later
Information in this document applies to any platform.

Symptoms

Issue
---------------------------------------------------
Environment:
Image version: 12.1.1.1.1.140712
DB version --> 11.2.0.4.0

Error --> ORA-27614: Smart I/O failed due to an error "4, OSS_DATA_INTERNALERR" from the cell "nnn.nnn.nnn.nnn/". disk: "o/nnn.nnn.nnn.nnn/<<MYCELL_NAME>>", block: "nnnnnnn", disk offset: "nnnnnnn" I/O size: "1048576"

Clarification
---------------------------------------------------
SQL query would contain a REGEXP_LIKE regular expression in the WHERE clause and crash with errors as below:
.
For example:
SELECT *
FROM
<<<TABLE_NAME>>>
WHERE
REGEXP_LIKE(<>)

ORA-12801: error signaled in parallel query server P026, instance <<MYINSTANCE_NAME>>
ORA-27614: Smart I/O failed due to an error "4, OSS_DATA_INTERNALERR" from the cell "nnn.nnn.nnn.nnn/". disk: "o/nnn.nnn.nnn.nnn/<<MYCELLL_NAME>>", block: "nnnnnn", disk offset: "nnnnnnn" I/O size: "1048576"
ORA-27616: ASM Allocation Unit: 4002
ORA-01110: data file <nnn>: '+DATA_<nnn>/<<DIR_NAME>>/<<DIR_NAME>>/<<DATAFILE_NAME>>'

Also, following errors would appear in cell alert log:

2016-08-24T00:45:48+00:00 critical "RS-700 [Celloflsrv crash detected] [SYS_112331_140529] [] [] [] [] [] [] [] [] [] []"
2016-08-24T00:45:47+00:00 critical "ORA-07445: exception encountered: core dump [lxregsergop()+4] [11] [0x7FB812B3ACB8] [] [] []"
2016-08-24T00:47:12+00:00 critical "RS-700 [Celloflsrv crash detected] [SYS_112331_140529] [] [] [] [] [] [] [] [] [] []"

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