7445[IIOC_DO_SHARED] SEEN FROM XML BASED SQL WHEN CONNECTED FROM CLIENT VIA LISTENER (Doc ID 736104.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3
This problem can occur on any platform.

Symptoms

This article is written for a specific situation but may contain information that will allow
resolution for other issues, if this is not the case and no suitable note can be found or
if in any doubt a new SR should be created to ORACLE Support.

The following symptoms will be seen :-

a) PLSQL using XML functions is in use.
b) Database version needs to be >=V10203, issue is also seen in V11106
c) ORA-03113 may be seen at client session level
d) Following error is seen in alert log :-

ORA-07445: exception encountered: core dump [€] [SIGSEGV] [unknown code]
[0x400003FF806362A2] [] []

Depending on platform this may differ but unlikely that a meaningful function name will be reported

e) 7445 stack trace will be similar to the following :-

Function List (to Full stack) (to Summary stack)

ssexhd <- sigreturn <- kslgetl <- ioc_do_shared <- iocbf_do_shared
<- ioc_do_call <- joet_switched_env_callback <- ioct_do_shared <- allback
<- eoaint_initialize <- eoa_startup_default <- objmems <- ioesub_init_call
<- seoa_note_stack_out <- side <- ioe_init_call <- side <- jox03_init_call
<- jox_invoke_java_ <- 3948 <- jox_invoke_java <- kkxmjexe <- kgmexcb
<- kkxmswu <- kgmexwi <- kgmexec <- pefjavacal <- pefcal
<- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run
<- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr
<- ttcpip <- opitsk <- opiino <- opiodr <- opidrv
<- sou2o <- opimai_real <- main <- $START$

f) If same PLSQL is run directly on the server we see no 7445 but instead
something similar to  :-

ERROR at line 1:
ORA-20001: ParseXML: ORA-20001: ParseNodes: ORA-29400: data cartridge error
ORA-22922: nonexistent LOB value
ORA-06512: at line 13

g) Within the PLSQL/XML code the XMLAGG function is used

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