Gateway

 Setting up new databases for Gateway server 
===================================================
hostvm01
export ORACLE_HOME-/apps/oracle/product/19.3.0/tghome_1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TNS ADMIN=$ORACLE_HOME/network/admin
export ODBCINI=/apps/oracle/product/19.3.0/tghome_1/hs/admin/odbc.ini
For SQL Server
================
cd /apps/oracle/product/19.3.0/tghome_1/hs/admin
==create initORA file for the database you wish to connect :
[oracle@hostvm01 admin]$ cat initIMS.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 = LMS
HS_FDS_TRACE_LEVEL = 255
HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so 
#ODBC specific environment variables
set ODBCINI=/apps/oracle/product/19.3.0/tghome_1/hs/admin/odbc.ini
[oracle@hostvm01 admin]$
============created entry in odbc.ini file for the database.
[oracle@hostvm01 admin]$ cat odbc.ini
[ODBC Data Sources]
LMS = ODBC Driver 18 for SQL Server
[LMS]
Driver=/opt/microsoft/msodbcsq118/lib64/libmsodbcsql-18.3.so.1.1 
Description=Microsoft ODBC Driver 18 for SQL
Database= LMS
Server=TCP: qwawsqlsvrdb01.rl-core.rliaig.net, 1433
QuotedId= Yes
AnsiNPW= Yes
TrustServerCertificate=yes
[ODBC]
Trace = 0
TraceFile= /opt/microsoft/msodbcsql/odbctrace.out
[oracle@hostvm01 admin]$
-Now in network_admin location add db entry to the listener file-
[oracle@hostvm01 admin]$ pwd
/apps/oracle/product/19.3.0/tghome_1/network/admin
[oracle@hostvm01 admin]$ cat listener.ora
#listener.ora  Network Configuration File:/apps/oracle/product/19.3.0/tghome_1/network/admin/listener.ora 
#Generated by Oracle configuration tools.
LISTENER_GTW
 (DESCRIPTION =
  (ADDRESS (PROTOCOL = TCP) (HOST=hostvm01.ri-core.ri.aig.net) (PORT = 1535))
 )
SID_LIST_LISTENER_GTW =
(SID_LIST =
(SID_DESC = 
(SID_NAME = LMS)
(ORACLE_HOME = /apps/oracle/product/19.3.0/tghome_1)
(ENV="LD_LIBRARY_PATH=/opt/microsoft/msodbcsql18/lib64: /usr/lib64: /apps/oracle/product/19.3.0/tghome_1/lib")
(PROGRAM dg4odbc)
)
)
LISTENER SAP =
(DESCRIPTION=
 (ADDRESS (PROTOCOL = TCP) (HOST hostvm01.rl-core.r1.aig.net) (PORT = 1526))
SID_LIST_LISTENER_SAP=
(SID_LIST=
  (SID_DESC=