oracle 11g gateway 连接sql server 2000

来源：互联网发布：labview 算编程吗编辑：程序博客网时间：2024/06/06 17:41

到现在为止，测试了很多方法都失败了，就这一种网关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服务器上安装网关问题少！

0 0