Oracle 11g Gateways (transparent Gateway) configuration

The main configuration points are two 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

Note that hs_fds_connect_info, which is configured with the parameters of the gateways connection to the SQL Server database, contains 4 parts

1 server address; 2 ports; 3 instance name; 4 Database name

After I test 1, 4 is required, 2, 3 is not the case can also.

Guess: 1433 port can be omitted (not verified)

Strange experience: Use Localhost/mssqlserver/northwind configuration failed, do not know the reason, have to know the friend please correct me

The full configuration is this: 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)   )) = = = = (PROTOCOL = IPC) (KEY = EXTPROC1521))                     1521))) = C:\oracle\gateways  

The configuration in this is not very clear, the red part is added in with the point 1 corresponds.

Oracle 11g Gateways (transparent Gateway) configuration