My Oracle Support Banner

ORA-7445 [npixfc] and ORA-28511 Errors When Job Connects to Remote Host and Trying to Access via HS Gateway (Doc ID 2082557.1)

Last updated on JULY 25, 2023

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

The alert log reports errors like:

HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhostname)(PORT=1541)))(CONNECT_DATA=(SID=<sid>))), NCR status = -2147385341
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FFFB2CE5C38] [PC:0x719DF5B, npixfc()+225] [flags: 0x0, count: 1]
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_j000_358.trc (incident=153834):
ORA-07445: Exception aufgetreten: CORE Dump [npixfc()+225] [SIGSEGV] [ADDR:0x7FFFB2CE5C38] [PC:0x719DF5B] [Address not mapped to object] []
ORA-28511: RPC-Verbindung zu heterogenem Remote Agent mit SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhostname)(PORT=1541)))(CONNECT_DATA=(SID=<sid>))) abgebrochen
ORA-02063: vorherige line von <sid>


The trace file shows characteristics like:

----- Current SQL Statement for this session (sql_id=bd8ts6k6rq9g3) -----

INSERT INTO <TABLE_NAME1> (SELECT * FROM <TABLE_NAME2> ) 

----- PL/SQL Stack -----

----- PL/SQL Call Stack -----

object line object handle number name

0x18283f318 699 package body <OWNER>.<PACKAGE_NAME>

0x18283f318 234 package body <OWNER>.<PACKAGE_NAME>

0x1660cdae8 1 anonymous block

----- Call Stack Trace ------

... npixfc  npicls  qerrmApcl  kxsffir  kxsFreeWorkArea  kxsFreeExecutionHea  kxsClean  kksSeverInstantiati  kkscpn  npixfc  npicls  qerrmApcl  kxsffir  kxsFreeWorkArea ...

 

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
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.