select statement failing with ORA-03113: end-of-file on communication channel (Doc ID 3026436.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

select statement failing with ORA-03113: end-of-file on communication channel. When alertlog reviewed, the query failing with ORA-07445

Error: ORA-07445: exception encountered: core dump [kkpamFList2()]

Error Stack:

ORA-07445: exception encountered: core dump [kkpamFList2()+3122] [SIGSEGV] [ADDR:0x40] [PC:0xB831DD2] [Address not mapped to object] []

Main Stack:

kkpamFList2 <- kkpamFList <- kkpapbDIGetList <- kkpapiItOpen <- kkpapItOpen

<- qergiStart <- rwsstd <- qerhnFetch <- opifch2 <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino

<- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main

Error: ORA-7445 [kkpamFList2] [SIGSEGV] [ADDR:0x40] [PC:0xB831DD2] [Address not mapped to object] [] [] [] [] [] [] []

[00]: dbgexExplicitEndInc [diag_dde]

[01]: dbgeEndDDEInvocationImpl [diag_dde]

[02]: ssexhd []

[03]: sslssSynchHdlr []

[04]: sslsshandler []

[05]: __sighandler []

[06]: kkpamFList2 [PART]<-- Signaling

[07]: kkpamFList [PART]

[08]: kkpapbDIGetList [PART]

[09]: kkpapiItOpen [PART]

[10]: kkpapItOpen [PART]

[11]: qergiStart [PART]

[12]: rwsstd []

[13]: qerhnFetch [SQL_Execution]

[14]: opifch2 [OPI]

[15]: kpoal8 [PROGINT_MISC]

[16]: opiodr [OPI]

[17]: ttcpip []

[18]: opitsk [OPI]

[19]: opiino [OPI]

[20]: opiodr [OPI]

[21]: opidrv [OPI]

[22]: sou2o []

[23]: opimai_real [OPI]

[24]: ssthrdmain []

[25]: main []

Cause

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