We use Oracle heterogeneous services to transfer data of several MS SQL Server databases into different ORACLE 19c databases. A few weeks ago some of our load procedures started to fail from time to time with error
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=%s
*Cause: A fatal error occurred in one of the following places
-- the connection between the ORACLE server and the agent
-- the heterogeneous services remote agent itself
-- the connection to the non-Oracle system
This error occurred after communication had been established
successfully.
*Action: Check for network problems and remote host crashes. The problem is
probably in the agent software. If so, contact a customer support
representative of the agent vendor.
Fehler in Zeile: 1 Spalte: 21
In the beginning of the problem the next access to the same table was OK, but last weekend the situation became worse and nearly every access to the SQL Server fails (at least from some of our 19c databases, the access from an other identically configured database is still possible).
Setting HS_FDS_TRACE_LEVEL = 4 in the HS Init-File produces trace files like:
Oracle Corporation --- 2024-11-14 13:14:04.901000000
Heterogeneous Agent Release
19.0.0.0.0
Oracle Corporation --- 2024-11-14 13:14:04.900000000
Version 19.0.0.0.0
Entered hgogprd
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "4"
Entered hgosdip
setting HS_OPEN_CURSORS to default of 50
setting HS_NLS_NUMERIC_CHARACTERS to default of ".,"
setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
setting HS_FDS_RECOVERY_PWD to default value
setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
setting HS_IDLE_TIMEOUT to default of 0
setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
setting HS_NLS_NCHAR to default of "UCS2"
setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
setting HS_FDS_DATE_MAPPING to default of "DATE"
setting HS_FDS_TRUNC_ANSI_DATE to default of "OFF"
setting HS_RPC_FETCH_REBLOCKING to default of "ON"
setting HS_FDS_FETCH_ROWS to default of "100"
setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
setting HS_FDS_MAP_NCHAR to default of "TRUE"
setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
setting HS_FDS_QUERY_DRIVER to default of "TRUE"
setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"
setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION
setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo;gtw$:OPTTables;gtw$:OPTColumns;gtw$:OPTPrimaryKeys;gtw$:OPTForeignKeys;gtw$:OPTProcedures;gtw$:OPTStatistics"
setting HS_FDS_DELAYED_OPEN to default of "TRUE"
setting HS_FDS_WORKAROUNDS to default of "0"
setting HS_WORKAROUNDS to default of "0"
Exiting hgosdip, rc=0
ORACLE_SID is "xxxxxxxxxxxx"
Product-Info:
Port Rls/Upd:0/0 PrdStat:0
Agent:Oracle Database Gateway for ODBC
Facility:hsa
Class:ODBC, ClassVsn:19.0.0.0.0_0024, Instance:xxxxxxxxxxxxx
Exiting hgogprd, rc=0
HS: RPC error reported on agent, GetProductCallBackOut ...TransferAgentDescription; NCR code 1009
HS: RPC error reported on agent, ReceiveGetProduct: ncrosou_send_out_args; NCR code 3010
Entered hgoexit
HS Gateway: NULL connection context at exit
Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:118 ID:Connection context
Where can I find some information about “NCR code 1009” and “NCR code 3010”?
The 19c databases have patchlevel 19.25. but the trace file says Heterogeneous Agent Release 19.0.0.0.0. Are there any patches for the HS agent as well?
Is there any other helpful information about this problem?