oracle dblink sqlserver,oracle DBLink sqlserver

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！