SQL Server to take data to Oracle often need to use the transparent gateway provided by Oracle to achieve, before also successfully configured two times, today again when the configuration to forget how to configure before, toss a half-day a variety of errors, the internet a variety of related documents can not solve the problem. It takes half a day to get it right, and to prevent forgetting, the recording process is as follows:
1, from the official website download installation package gateways (fifth installation package P10404530_112030_MSWIN-X86-64_5OF7) began to install;
Important 1: If the Oracle database is installed on the same computer (most of the case), you can run universal Installer in the installed directory, then select Products.xml under Gatewaysstage and select the Oracle that is already installed Home, which simplifies configuration.
Point 2: During the installation process, the information required to enter SQL Server server can choose not to lose, but the input will interfere with the settings;
2, configuration
Point 1: Turn on Initdg4msql.ora Modify hs_fds_connect_info=[server name]//sql servers database instance name (Note:/)
Point 2: Open Listener.ora to add in Sid_list_listener project:
(sid_desc=
(Sid_name=dg4msql)
(Oracle_home= ........) #如果安装时按照上面的要点进行安装可从别的地方直接将ORACLE_HOME值复制进去
(Program=dg4msql)
)
Point 3: Open Tnsnames.ora Add:
Dg4msql =
(DESCRIPTION =
(address = (PROTOCOL = TCP) (HOST = Server machine name) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = dg4msql)
)
(HS = OK)
)
Summary: When a transparent gateway is installed on the same computer as the database, it is best to install it in the original Oracle home directory so that only 3 files can be modified for configuration. Simple and convenient.