Hi friends
I am having a problem creating a dblink between oracle xe and sql server 2019 in a ubuntu server 18.04 environment and an ODBC driver for SQL Server (Linux)
SQL:>
select code from "my_table"@remot;
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from REMOT
# cat tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asi)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
master_descriptor=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=192.168.0.100)
(PORT=1521)
)
(CONNECT_DATA=
(SID=master)
)
(HS = OK)
)

#cat listener.ora
# listener.ora Network Configuration File:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME=master)
(ORACLE_HOME= /u01/app/oracle/product/11.2.0/xe)
(PROGRAM=dg4odbc)
(ENVS=LD_LIBRARY_PATH=/opt/microsoft/msodbcsql17/lib64:/u01/app/oracle/product/11.2.0/xe/lib)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = asi)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
# cat initmaster.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC

# HS init parameters

HS_FDS_CONNECT_INFO = master
HS_FDS_TRACE_LEVEL = user
HS_FDS_SHAREABLE_NAME = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1

# ODBC specific environment variables

set ODBCINI=/etc/odbc.ini
set HOME=/u01/app/oracle/product/11.2.0/xe

# Environment variables required for the non-Oracle system

#set <envvar>=<value>
# cat /etc/odbc.ini
[master]
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1
Description=DataDirect 5.20 SQL Server Wire Protocol
Database=master
User=SA
Password=Abril2021+
Server=192.168.0.144
[ODBC]
Trace=ON
TraceFile=/opt/odbc520/odbctrace.out
TraceDll=/opt/odbc520/lib/odbctrac.so
InstallDir=/opt/odb520
ConversionTableLocation=/opt/odbc520/tables
UseCursorLib=0
# cat /etc/odbcinst.ini
[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1
UsageCount=1
Threading=1