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 to [Release 11.2]
Oracle Database Gateway for DRDA - Version to [Release 11.2]
Information in this document applies to any platform.


Using Database Gateway for SQL*Server (Dg4MSQL) and RDBMS 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).


The RDBMS has been upgraded to


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