Last updated on JUNE 13, 2013
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6 - Release: 10.2 to 11.1Information 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;
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