My Oracle Support Banner

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

Last updated on APRIL 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to 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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.