My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

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/<
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 <>
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/<ORA-27616: ASM Allocation Unit: 4002
ORA-01110: data file <nnn>: '+DATA_<nnn>/<>/<>/<>'

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

To view full details, 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 a vibrant support community of peers and Oracle experts.