Ora-07445, ORA-600 or Hanging Errors When Using Database Gateways Due to RDBMS Cursor_Sharing Settings

(Doc ID 1304918.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle Database Gateway for DRDA - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle Database Gateway for Informix - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle Database Gateway for Sybase - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

When using a Database Gateway to select from a non-Oracle database then ORA-7445 or ORA-600 errors can be received.

1. ORA-07445 hocldr2

The following selects using Database Gateway for SQL*Server (DG4MSQL) -


select * from dual@gateway ;


or

select sysdate from dual@gateway ;


 give the following error -

ORA-07445: exception encountered: core dump [hocldr2+0394] [SIGSEGV] [Address not mapped to object] [0x6873736820686F97] [] []
Current SQL statement for this session:
SELECT :"SYS_B_0" DUMMY FROM "dbo"."sysusers"@GATEWAY WHERE "name" = :"SYS_B_1"

 

2. Ora-600 KPOAl8-1

Using an Oracle 10G or 11G database with an 11.2 Database Gateway then queries to the non Oracle database can result in a hung condition or an ORA-600 error.

For example -

SQL>  select * from all_objects@gtw_link where object_id=1;
select * from all_objects@aspinto where object_id=1
                                                  *
ERROR at line 1:
ORA-00600: internal error code, arguments: [kpoal8-1], [], [], [], [], [],
[], [], [], [], [], []

 

3. ORA-7445 hopsmsl_make_select_list

After upgrading a RDBMS to 10.2.0.5 the following error is thrown when performing a select using PL/SQL and 11.2 Database Gateway for Sybase (DG4Sybase):

ORA-07445: exception encountered: core dump [hopsmsl_make_select_list()+62] [SIGSEGV] [Address not mapped to object] [0x000000004] [] []

 

4. ORA-7445 opixrb

A select using any Database Gateway will give the following error -

ORA-07445: exception encountered: core dump [opixrb()+4235] [SIGSEGV] [ADDR:0x0] [PC:0x60615D5] [Address not mapped to object] []

 

5. ORA-7445 hokx_coerce

Using Oracle RDBMS 10.2.0.4 and DG4MSQL 11.2.0.1 the following error may be received -

ORA-07445: exception encountered: core dump [hokx_coerce()+93] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

 

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