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 DECEMBER 08, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 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=sedcbvtc0000)(PORT=1541)))(CONNECT_DATA=(SID=covo))), NCR status = -2147385341
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FFFB2CE5C38] [PC:0x719DF5B, npixfc()+225] [flags: 0x0, count: 1]
Errors in file /srv/oracle/log/diag/rdbms/pppcvtc/pppcvtc/trace/pppcvtc_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=sedcbvtc0000)(PORT=1541)))(CONNECT_DATA=(SID=covo))) abgebrochen
ORA-02063: vorherige line von COVO


The trace file shows characteristics like:

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

INSERT INTO VTCOVO_DBA.il_covo_tmp_103 (SELECT TRIM (v3.c103_c_zustand_kz), TRIM (v3.c103_c_an1), TRIM (v3.c103_c_an2), TRIM (v3.c103_c_an3_5), TRIM (v3.c103_c_an6_10), TRIM (v3.C103_C_CODE), TRIM(v3.C103_C_AN1) || TRIM(v3.C103_C_AN2) || TRIM(v3.C103_C_AN3_5) || TRIM(v3.C103_C_AN6_10) AS CO_AUFTRAG_ID, :1 FROM D$DV1I.V1IVT103@COVO v3 WHERE v3.c103_c_zustand_kz = :2 AND v3.c103_c_an1 = :3 AND v3.c103_c_an2 = :4 AND v3.c103_c_an3_5 = :5 AND v3.c103_c_an6_10 = :6 ) 

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

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

object line object handle number name

0x18283f318 699 package body VTCOVO_DBA.COVO_SL_ETL

0x18283f318 234 package body VTCOVO_DBA.COVO_SL_ETL

0x1660cdae8 1 anonymous block

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

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

 

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