Oracle Gateways Way to create Dblink connected SQL Server database

1. Install multiple discovery on the same machine there is always a problem, so it is recommended to find a machine that does not have Oracle installed gateways

2. Download the Oracle gateways and unzip it, see the website for details. Download the installation file: Winx64_12201_gateways

Installation.

3. Installation Precautions:

Components compare multiple installations

Setting Up Database-related

Perform the installation complete.

4. After the installation is complete, modify the main configuration file:

Modify the following initdg4msql.ora in the directory

Automatic file content generation

hs_fds_connect_info=[10.24.160.1]/mssqlserver/cwbasem871
Hs_fds_trace_level=off
Hs_fds_recovery_account=recover
Hs_fds_recovery_pwd=recover

General requirements in the following directories are monitored and tnsnames files

C:\app\tg\Administrator\product\12.2. 0 \tghome_1\network\admin

The file content is basically the same

This example

Listener.ora

# This was a sample listener.ora that contains the NET8 parameters that was
# needed to connect to an HS Agent

LISTENER =
(address_list=
(Address= (PROTOCOL=TCP) (HOST=WIN2008R2SP1) (port=1521))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)

Sid_list_listener=
(sid_list=
(sid_desc=
(Sid_name=dg4msql)
(oracle_home=c:\app\tg\administrator\product\12.2.0\tghome_1)
(Program=dg4msql)
)
)

#ADR_BASE_LISTENER = C:\app\tg\Administrator\product\12.2.0\tghome_1

#CONNECT_TIMEOUT_LISTENER = 0

Tnsname.ora

# This was a sample tnsnames.ora that contains the NET8 parameters that was
# needed to connect to an HS Agent

Dg4msql =
(description=
(Address= (PROTOCOL=TCP) (HOST=WIN2008R2SP1) (port=1521))
(Connect_data= (Sid=dg4msql))
(Hs=ok)
)

5. After modifying the configuration file, restart the LSNRCTL command:

cmd-> lsnrctl>stop>start tnsping dg4msql validation prompt on the cmd command line. The alias attempt connection was resolved using the TNSNames adapter ( DESCRIPTION= (address= (protocol=tcp) (HOST=WIN2008R2SP1) (port=1521)) (Connect_data = (sid= Dg4msql)) (hs=OK)) OK (0 ms)

6. Create the configuration in the Oracle server

" lcm8719999 " " Test6530 " using ' (DESCRIPTION =    10.24. 101.105 1521             ) =      dg4msql)) (HS = OK)) '

7. Query validation

  Select  from [Email protected]

Main points of Discovery:

1. Initdg4msql.ora must be a directory:

C:\app\tg\Administrator\product\12.2. 0\tghome_1\dg4msql\admin

and must follow the format. This link can be changed casually, do not need to restart Lsnrctl. Re-create Dblink Auto refresh should be a walk once disk IO

2. The network in the DG directory must exist, and there is a static registration of the Dg4msql SID can be, or will be error, put in the directory just now the file is not used. Must be placed in this directory

C:\app\tg\Administrator\product\12.2. 0\tghome_1\network\admin

3. I found that the 11g and 12c gateways are compatible with each other and are not subject to version limitations. However, some table field tables will have a special error, showing

Oracle Gateways Way to create Dblink connected SQL Server database