ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME SAVEPOINTS LEVEL 1' Raises ORA-03113/ORA-07445[SIGSEGV]/[STRLEN] Errors (Doc ID 342484.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.6 and later
Information in this document applies to any platform.

Symptoms

***Checked for relevance on 22-Jun-2012***

The following errors have been observed for this issue:-

ORA-03113 : From SQLPLUS session
ORA-07445: exception encountered: [SIGSEGV] [Address not mapped to object] : From alert log
ORA-07445[STRLEN] : From alert log

All of the following symptoms will be observed :-

a) Using ALTER SESSION as below

ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME SAVEPOINTS LEVEL 1';

This will raise ORA-03113 from the SQLPLUS session

b) At same timestamp either ORA-07445[SIGSEGV] or 7445[STRLEN] will be reported in the alert log

The stack will be similar to:-
ksedmp ssexhd sigacthandler xctdsp ksddoa ksdsvg ksdsev ksdacn ksdprs kkyase opiexe opiall0  kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o main start

c) ALTER SESSION is fine if a SAVEPOINT is created first

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