Categories

Oracle Database link to SQL Server using Oracle Gateway ODBC

Naseer Cheruvote
Naseer Cheruvote Member, Orion GCS Customer Posts: 1 Green Ribbon
in General

Hi,

Created the following.

  1. system DSN created at SQL - Machine with name - DSNEMPEXAM
  2. Install "WINDOWS.X64_193000_gateways" on SQL Machine, choose ODBC

At " D:\app\tg\HASQLADMIN\product\19.0.0\tghome_1\hs\admin" change name of the init file initDSNEMPEXAM - values (HS_FDS_CONNECT_INFO = DSNEMPEXAM

HS_FDS_TRACE_LEVEL = OFF

3 .Listener configured in SQL Machine

path: D:\app\tg\HASQLADMIN\product\19.0.0\tghome_1\hs\admin

========================================================

LISTENERDSNEMPEXAM =

 (ADDRESS_LIST=

   (ADDRESS=(PROTOCOL=tcp)(HOST=(HOST=IP of the SQL)(PORT=1443))

 )

SID_LIST_LISTENER=

 (SID_LIST=

   (SID_DESC=

     (SID_NAME=DSNEMPEXAM)

     (ORACLE_HOME=D:\app\tg\HASQLADMIN\product\19.0.0\tghome_1)

     (PROGRAM=dg4odbc)

   )

=============================================================

and getting error for tnsping

---------------------------

C:\Windows\system32>lsnrctl stop LISTENERDSNEMPEXAM

LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 03-MAR-2021 09:08:28

Copyright (c) 1991, 2019, Oracle. All rights reserved.

TNS-01101: Could not find listener name or service name LISTENERDSNEMPEXAM

--------------------------

Please any one support?