Oracle 11g gateways (transparent gateway) configuration, 11 ggateways

Oracle 11g gateways (transparent gateway) configuration, 11 ggateways

There are two main configuration points::

1.% GATEWAYS_HOME % (transparent gateway installation directory) \ dg4msql \ admin \ initdg4msql. ora

Content:

HS_FDS_CONNECT_INFO = localhost // DATABASENAME
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_RECOVERY_ACCOUNT = RECOVER
HS_FDS_RECOVERY_PWD = RECOVER

Please note that HS_FDS_CONNECT_INFO is configured here, which is the parameter for connecting gateways to the SQL SERVER database, including four parts

1 server address; 2 port; 3 Instance name; 4 Database Name

I have tested that 1 and 4 are required, and 2 and 3 are not required.

Guess: port 1433 can be omitted (not verified)

Strange experience: configuration failed with localhost/MSSQLSERVER/Northwind. If you know the reason, please correct it.

The complete configuration is as follows: localhost: 1433/MSSQLSERVER/Northwind

2.% GATEWAYS_HOME % (transparent gateway installation directory) \ NETWORK \ admin \ listener. ora

Content:

SID_LIST_LISTENER =    (SID_LIST =    (SID_DESC =      (SID_NAME = dg4msql)      (ORACLE_HOME = C:\oracle\gateways)      (PROGRAM = dg4msql)    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-VV5TMJBQ3LN)(PORT = 1521))    )  )ADR_BASE_LISTENER = C:\oracle\gateways

The configuration here is not very clear, and the red part corresponds to key 1.