First, hardware and software environment
1, system 1: Windows2000 Server Oracle8.17 Oracle 9i Transparent Gateway
2, System 2: Windows2000 Server SQL Server 2000
3, system 3: Windows2000 Server SQL Server2000
Second, the database environment
System 1 Contains Oracle 8i Database and Oracle9i Transparent Gateway, IP: 10.89.54.152
System 2 Target Database is PDA, IP: 10.89.54.162
System 3 Target Database is EMS, IP: 10.89.54.36
Third, installation instructions
The version of the transparent gateway for MS SQL Server must be installed under the Windows platform. Oracle9i Installed CDs Bring this assembly, but Oracle8i needs to be purchased. When the Oracle 9i is installed, Transparent Gateway is not installed by default. To install the component, you need to select a custom installation when you install Oracle9i, then select Oracle Transparent Gateway-> Transparent Gateway for MS SQL Server .. Oracle in the installation product list. Databases and Oracle transparent gateways can be on different servers.
After the transparent gateway is installed, you can find the TG4MSQL directory under the $ Oracle_home (9i installation directory).
Fourth, modify the configuration file.
1, the system 1 $ Oracle_Home / TG4MSQL / Admin / Under, the newly established two. Ota files - ITPDA. ORA and IITEMS.ORA..
The content is:
INitpda.ora:
HS_FDS_CONNECT_INFO = "Server = 10.89.54.162; database = PDA"
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_RECOVERY_ACCOUNT = Recover
HS_FDS_RECOVERY_PWD = Recover
InItems.ora:
HS_FDS_CONNECT_INFO = "Server = 10.89.54.36; Database = EMS"
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_RECOVERY_ACCOUNT = Recover
HS_FDS_RECOVERY_PWD = Recover
2. Modify the Listener.ora file of the transparent gateway where Server (under $ Oracle_home / network / admin), add the corresponding content, the $ ORACLE_HOME is the installation directory of the 9i.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PDA)
(Oracle_Home = E: / Oracle / ORA92)
(Program = TG4MSQL)
)
(SID_DESC =
(SID_NAME = EMS)
(Oracle_Home = E: / Oracle / ORA92)
(Program = TG4MSQL)
)
)
3. Modify the TNSNames.ora file of the Oracle database (under $ oracle_home / network / admin, add two services.
$ Oracle_home here is an installation directory of 8i.
Add content:
PDA =
(Description =
(Address_list =
(Address = (Protocol = TCP) (Host = 10.89.54.152) (port = 1521))) // The Host here must fill the gateway site SERVER address
(Connect_data =
(SID = PDA) // This SID is corresponding to the SID_NAME in the Listener.ora changed by the transparent gateway
)
(HS = PDA)
)
EMS =
(Description =
(Address_list =
(Address = (protocol = TCP) (Host = 10.89.54.152) (port = 1521)))
) // The Host here must fill the gateway where the gateway is located.
(Connect_data =
(SID = EMS) // This SID corresponds to the SID_NAME in the Listener.ora changed by the transparent gateway
)
(HS = EMS)
)
4, set the Oracle database parameter global_names = false.
Modify the Oracle Database (: / Oracle / Admin / Sidora / Pfile), set global_name to false., The resulting database link and the global name of the destination database are not required. Modify the init file to restart the database.
5. Establish a public database link:
Create Public Database Link PDA
Connect to testuser identified by testuser_pwd using pda;
Create Public Database Link EMS
Connect to Testuser Identified by Testuser_PWD Using EMS;
(Suppose SQL Server libraries E4PDM and EMS have sufficient permissions, users log in to Testuser, password to testUser_PWD)
6. Heavy roots Oracle8i database, restart 9i listening services.
7, test connection
Enter lsnrctl under DOS.
LSNRCTL> Status
-------------------------------------------------- -------------------------------------------------- ----------------------------
Connecting to (deSCription = (protocol = TCP) (Host = 10.89.54.152) (port = 1521)
))
Status of the listener
---------------------------------------------------------------------------------------------------------------------------------------
Alias Listener
Version TNSLSNR for 32-Bit Windows: Version 9.2.0.1.0 - Product
Tion
START DATE 23-SEP-2004 13:13:13
Uptime 0 days 1 HR. 29 min. 10 SEC
Trace Level Off
Security off
SNMP OFF
Listener Parameter File E: /oracle/ora92/neetwork/admin/listener.ora
Listener log file e: /oracle/ora92/neetwork/log/listener.log
Listening Endpoints Summary ... (address = (protocol = tcp) (Host = 10.89.54.152) (port = 1521))))
Services Summary ...
Service "PDA" HAS 1 Instance (s).
Instance "PDA", STATUS UNKNOWN, HAS 1 Handler (s) for this service ...
Service "EMS" HAS 1 Instance (s).
Instance "EMS", Status Unknown, HAS 1 Handler (s) for this service ...
THE Command Complated SuccessFully
Unknown's state is normal and there is no effect on the results.
Go to the bin directory of 8i:
D: / Oracle / ORA81 / BIN> TNSPING PDA
If you see
Attempting to contact (pecol = tcp) (host = 10.89.54.152) (port = 1521))
OK (0 msec)
The information is connected to OK.
Look at the connection of the EMS.
D: / Oracle / ORA81 / BIN> TNSPING EMS
Attempting to contact (pecol = tcp) (host = 10.89.54.152) (port = 1521))
OK (0 msec)
8, test
SQL> SELECT "DNO" from DM @ E4PDM WHERE ROWNUM <2
DNO
---------
C0-000
SQL> SELECT "Dep_co" from EMS @ Ems WHERE ROWNUM <2
DEP_CO
-------------
DC0001
