Ora-07445 Core Dump Hopsmsl_make_select_list Using DG4MSQL or DG4DRDA (Doc ID 1395475.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Oracle Database Gateway for DRDA - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Using Database Gateway for SQL*Server (Dg4MSQL) and RDBMS 11.2.0.2 gives the following error -

ORA-07445: exception encountered: core dump [hopsmsl_make_select_list()+48] [SIGSEGV] [ADDR:0x4] [PC:0x7955D58] [Address not mapped to object] []


for a statement such as -

select pay_id, company_id, e_status,
user_id, vendor_id, curr_id, prj_id
from ownwer.table_name@gtwtest
where pay_id = uv_pay_id ;


The dump file shows the following statement causing the ORA-7445 error -

----- Current SQL Statement for this session (sql_id=xxsyuzfs0y3znu) -----
select pay_id, company_id, e_status, user_id, vendor_id, curr_id, prj_id from
ownwer.table_name@gtwtes where pay_id = :A0


and the Call Stack Trace in the dump file shows the following functions -

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
<- ssexhd <- sighandler <- hopsmsl_make_select <- list <- hopsetu
<- _list <- hokxe <- hoklls <- hokll <- hokl8
<- hogdre <- hogodr <- upirtrc <- kpurcsc <- kpuexec
<- kpnexe <- opiexe <- opiefn <- opiodr <- ttcpip
<- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- opimai_real <- ssthrdmain <- main <- libc_start_main <- start


This problem can also happen when using the Database Gateway for DRDA (DG4DRDA).

Changes

The RDBMS has been upgraded to 11.2.0.2.

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