1,安裝getway 并配置以下文件
D:\oracle\product\10.2.0\tg_1\tg4msql\admin\inita24ict.ora
內容修改:
HS_FDS_CONNECT_INFO="SERVER=10.182.15.67;DATABASE=ictdb"
HS_FDS_TRACE_LEVEL=OFF
D:\oracle\product\10.2.0\tg_1\NETWORK\ADMIN\listener.ora
修改內容如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = a24ict)
(ORACLE_HOME = D:\oracle\product\10.2.0\tg_1)
(PROGRAM = tg4msql)
)
(SID_DESC =
(SID_NAME = icttest)
(ORACLE_HOME = D:\oracle\product\10.2.0\tg_1)
(PROGRAM = tg4msql)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.182.15.67)(PORT = 1521))
)
)
2,檢查監聽是否啟動
TNSLSNR.exe
3配置 tnsnames.ora
A24ICT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.182.15.69)(PORT = 1521))
(CONNECT_DATA = (SID = a24ict)) (HS = OK)
)
[oracle@zdttest admin]$ tnsping 10.182.15.69
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 07-OCT-2011 11:05:36
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=10.182.15.69))(ADDRESS=
(PROTOCOL=TCP)(HOST=10.1
82.15.69)(PORT=1521)))
OK (10 msec)
SQL> create public database link ink_ict69
2 connect to sa identified by admin
3 using 'A24ICT';
SQL> select * from where rownum=1;
Partnum Revision Work_Order Line_id Operator
-------------------- ---------- -------------------- ---------- ---------------
No Fixture Instrument
-------------------- -------------------- --------------------
Barcode Result ACVoltage AmpHi AmpLow
------------------------------ ---------- ---------- ---------- ----------
Frequency FreqHi FreqLow TestDate TestTi
--------------- --------------- --------------- -------- ------
FSAP304 A WS8-B20313 P2B23 ???
F0727152 SGGFSAP304-28 20
C4614042PPLDHWWA9 PASS 99.441 150.000 77.500
1012.504 1200.000 800.000 20110930 124231
OK!