ORA-7445: exception encountered: core dump [slmecpy()+132] when FGA is enabled
(Doc ID 560544.1)
Last updated on MARCH 28, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.6 [Release 10.2 to 11.1]Information in this document applies to any platform.
Symptoms
DML on a view with a base table that has an audit predicate fails with
ERROR at line 1:
ORA-3113: end-of-file on communication channel
ORA-3113: end-of-file on communication channel
Alert.log shows
ORA-7445: exception encountered: core dump [slmecpy()+132] [SIGSEGV] [Address not mapped to object] [0x400000000] [] []
Or an
ORA-00600: internal error code, arguments: [evapls1], [], [], [], [], [], [], []
The call stack for the ORA-7445 [slmecpy()+132] is as follows:
ksedmp <- ssexhd <- sigacthandler <- slmecpy
<- kzctxEUsrEnv <- evactx <- evaopn2 <- evaopn2
<- evareo <- expepr <- kzftChkAudit
<- kzctxEUsrEnv <- evactx <- evaopn2 <- evaopn2
<- evareo <- expepr <- kzftChkAudit
The call stack for the ORA-600 [evapls1] is as follows:
ksedst <- ksedmp <- ksfdmp <- kgerinv <- kgeasnmierr
<- evapls <- evaopn2 <- evareo <- expepr <- kzftChkAudit
<- evapls <- evaopn2 <- evareo <- expepr <- kzftChkAudit
The following queries can confirm if FGA is enabled on the base table's column(s):
SQL> select object_schema, object_name, policy_name
from DBA_FGA_AUDIT_TRAIL;
SQL> select OBJECT_SCHEMA, OBJECT_NAME, POLICY_NAME,
POLICY_COLUMN, POLICY_COLUMN_OPTIONS, ENABLED,
SEL, INS, UPD, DEL
from DBA_AUDIT_POLICIES;
from DBA_FGA_AUDIT_TRAIL;
SQL> select OBJECT_SCHEMA, OBJECT_NAME, POLICY_NAME,
POLICY_COLUMN, POLICY_COLUMN_OPTIONS, ENABLED,
SEL, INS, UPD, DEL
from DBA_AUDIT_POLICIES;
Changes
NONE
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 |
| Changes |
| Cause |
| Solution |
| References |