到现在为止,测试了很多方法都失败了,就这一种网关oracle连接sql server 2000
(一)下载oracle网关,网上可用最新
http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_gateways.zip
(二)在sql server 2000服务器上安装oracle网关
1 解压
2 运行setup 然后默认下一步
3 选择 oracel gateway for sql server
4 创建监听端口最好选择1521
(三)参数配置
initdg4msql.ora ---------【这个名称与监听里的名称对应关系】
HS_FDS_CONNECT_INFO=[www-826718d2b88]//pubs --------【这一步很关键】
HS_FDS_TRACE_LEVEL=debug
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
(四) 监听文件添加
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = C:\product\11.2.0\tg_1)
(PROGRAM = dg4msql)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = www-826718d2b88)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = C:\product\11.2.0\tg_1
(五)在ORACLE服务器端配置tnsnames.ora进行其他创建dblink操作!
文档简介参考:
http://www.doc88.com/p-669150608868.html
附:在sql server 服务器上安装网关问题少!