Hi I am trying to connect to Teradata where isql works but when selecting with database I got
"ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=TERADATA)))
ORA-02063: preceding line from TERRADATA1
28511. 00000 - "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.
Error at Line: 1 Column: 28"
My odbc.ini is :
```
[TERADATA]
Description = TERADATA
Driver = /opt/teradata/client/20.00/odbc_64/lib/tdataodbc_sb64.so
InstallDir=/opt/teradata/client/20.00/odbc_64
DBCName=192.168.1.8
Trace=Yes
```
My initTERRADATA.ora is :
```
HS_FDS_CONNECT_INFO=TERADATA
HS_FDS_SHAREABLE_NAME=/opt/teradata/client/20.00/lib64/libodbc.so
HS_LANGUAGE=AMERICAN_AMERICA.AL32UTF8
HS_FDS_SQLLEN_INTERPRETATION=32
set ODBCINI=/etc/odbc.ini
```
My tnsnames.ora:
```
TERADATA=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TERADATA)
)
(HS = OK)
)
```
my listener.ora:
```
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC = (PROGRAM = dg4odbc) (SID_NAME = TERADATA) (ORACLE_HOME = /app/oracle/product/19.0.0/db_home))
)
```
My odbcinst.ini:
```
[TERADATA]
Description=Driver For TeraData
Driver=/opt/teradata/client/20.00/odbc_64/lib/tdataodbc_sb64.so
```
I want to know if I am mising some config I want to create database link to teradata
The Log:
```
Oracle Corporation --- 2025-05-15 02:17:08.523360000
Heterogeneous Agent Release
19.0.0.0.0
Oracle Corporation --- 2025-05-15 02:17:08.523230000
Version 19.0.0.0.0
Entered hgogprd
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "255"
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 "AL32UTF8"
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"
HOSGIP returned value of "32" 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 "TERRADATA"
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:TERRADATA
Exiting hgogprd, rc=0
hostmstr: 0: HOA After hoagprd
HOA 05/15 02:17:08.524286000: (hotker_ExecuteRpcs) ncrorpi: status = 0
HOA 05/15 02:17:08.526036000: (hotker_ExecuteRpcs) ncrorpi: status = 0
hostmstr: 0: HOA Before hoainit
Entered hgoinit
HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=873
HOCXU_DRV_NCHAR=873
HOCXU_DB_CSET=873
HS_LANGUAGE is AMERICAN_AMERICA.AL32UTF8
LANG=en_US.UTF-8
HOCXU_SEM_VER=122020
HOCXU_VC2_MAX=4000
HOCXU_RAW_MAX=2000
Entered hgolofn at 2025/05/15-02:17:08
HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/opt/teradata/client/20.00/lib64/libodbc.so"
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLAllocHandle
symbol_peflctx=0xf12ecf30
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLBindCol
symbol_peflctx=0xf12ed610
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLBindParameter
symbol_peflctx=0xf12ed7ac
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLCancel
symbol_peflctx=0xf12ee056
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLDescribeParam
symbol_peflctx=0xf12f046c
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLDisconnect
symbol_peflctx=0xf12f0608
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLEndTran
symbol_peflctx=0xf12f0ad2
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLExecute
symbol_peflctx=0xf12f1564
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLFetch
symbol_peflctx=0xf12f1814
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLFreeHandle
symbol_peflctx=0xf12f238a
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLFreeStmt
symbol_peflctx=0xf12f2e18
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetData
symbol_peflctx=0xf12f4784
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetEnvAttr
symbol_peflctx=0xf12f5aee
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetFunctions
symbol_peflctx=0xf12f5c7a
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLMoreResults
symbol_peflctx=0xf12f66de
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLNumResultCols
symbol_peflctx=0xf12f6c8e
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLParamData
symbol_peflctx=0xf12f6dd6
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLPutData
symbol_peflctx=0xf12f7f70
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLRowCount
symbol_peflctx=0xf12f80d8
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLSetEnvAttr
symbol_peflctx=0xf12f9ef8
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLSetDescRec
symbol_peflctx=0xf12f9cc4
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLColAttributeW
symbol_peflctx=0xf12ee2fa
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLColumnsW
symbol_peflctx=0xf12eeecc
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLConnectW
symbol_peflctx=0xf12ef344
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLDescribeColW
symbol_peflctx=0xf12f002e
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLDriverConnectW
symbol_peflctx=0xf12f072a
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLExecDirectW
symbol_peflctx=0xf12f1276
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLForeignKeysW
symbol_peflctx=0xf12f1a9e
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetConnectAttrW
symbol_peflctx=0xf12f33e0
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetDescFieldW
symbol_peflctx=0xf12f4922
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetDescRecW
symbol_peflctx=0xf12f4c6a
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetDiagFieldW
symbol_peflctx=0xf12f5136
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetDiagRecW
symbol_peflctx=0xf12f55c2
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetInfoW
symbol_peflctx=0xf12f5de2
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetStmtAttrW
symbol_peflctx=0xf12f6102
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLGetTypeInfoW
symbol_peflctx=0xf12f641a
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLPrepareW
symbol_peflctx=0xf12f7084
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLPrimaryKeysW
symbol_peflctx=0xf12f7378
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLProcedureColumnsW
symbol_peflctx=0xf12f7738
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLProceduresW
symbol_peflctx=0xf12f7bb0
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLSetConnectAttrW
symbol_peflctx=0xf12f8220
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLSetStmtAttrW
symbol_peflctx=0xf12fa570
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLSetDescFieldW
symbol_peflctx=0xf12f99a4
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLStatisticsW
symbol_peflctx=0xf12fad34
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Entered hgolofns at 2025/05/15-02:17:08
libname=/opt/teradata/client/20.00/lib64/libodbc.so, funcname=SQLTablesW
symbol_peflctx=0xf12fb588
hoaerr:0
Exiting hgolofns at 2025/05/15-02:17:08
Exiting hgolofn, rc=0 at 2025/05/15-02:17:08
HOSGIP for "HS_OPEN_CURSORS" returned "50"
HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
HOSGIP for "HS_NLS_NUMERIC_CHARACTERS" returned ".,"
HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
treat_SQLLEN_as_compiled = 0
Exiting hgoinit, rc=0 at 2025/05/15-02:17:08
hostmstr: 0: HOA After hoainit
hostmstr: 0: HOA Before hoalgon
Entered hgolgon at 2025/05/15-02:17:08
reco:0, name:dbc, tflag:0
Entered hgosuec at 2025/05/15-02:17:08
Exiting hgosuec, rc=0 at 2025/05/15-02:17:08
Entered hgopoer at 2025/05/15-02:17:08
hgopoer, line 240: got native error 408 and sqlstate 410; message follows...
408
Exiting hgopoer, rc=0 at 2025/05/15-02:17:08
hgolgon, line 204: calling SQLSetConnectAttr got sqlstate 410
Exiting hgolgon, rc=28500 at 2025/05/15-02:17:08 with error ptr FILE:hgolgon.c LINE:204 ID:Connection Attribute: TRACE
hostmstr: 0: HOA After hoalgon
RPC Calling nscontrol(0), rc=0
HOA 05/15 02:17:08.532096000: (hotker_ExecuteRpcs) ncrorpi: status = 0
hostmstr: 0: RPC Before Exit Agent
hostmstr: 0: HOA Before hoaexit
Entered hgoexit at 2025/05/15-02:17:08
Exiting hgoexit, rc=0
hostmstr: 0: HOA After hoaexit
hostmstr: 0: RPC After Exit Agent
HOA 05/15 02:17:08.532228000: (hotker_ExecuteRpcs) Exiting...
HOA 05/15 02:17:08.532245000: (horcrces_CleanupExtprocSession) Entered!
HOA 05/15 02:17:08.532252000: (horcrpooe_PopOciEnv) Entered!
HOA 05/15 02:17:08.532257000: (horcrfoe_FreeOciEnv) Entered!
HOA 05/15 02:17:08.532262000: (horcrfoe_FreeOciEnv) Exiting...
HOA 05/15 02:17:08.532268000: (horcrfse_FreeStackElt) Entered!
HOA 05/15 02:17:08.532273000: (horcrfse_FreeStackElt) Exiting...
HOA 05/15 02:17:08.532278000: (horcrpooe_PopOciEnv) Exiting...
HOA 05/15 02:17:08.532284000: (horcrces_CleanupExtprocSession) Exiting...
HOA 05/15 02:17:08.532290000: (hotkcc_CleanupConnection) Entered!
HOA 05/15 02:17:08.532465000: (hotkcc_CleanupConnection) Exiting...
HOA 05/15 02:17:08.532505000: (hotkctc_CleanupTaskContext) Entered!
HOA 05/15 02:17:08.532513000: (hotkctc_CleanupTaskContext) Exiting...
HOA 05/15 02:17:08.532846000: (homtcro_CleanupRemoteOps) Entered!
HOA 05/15 02:17:08.532868000: (homtcro_CleanupRemoteOps) Exiting...
```