配置透明网关的步骤

cfdai

我用的平台：
Windows 2000 server + Oracle9i Database 9.2.0.1.0  + Oracle9i Warehouse Builder 9.0.3.0.33
   请问如何配置透明网关获取MS SQL Server数据库中的数据？
   拜读了你的贴子《配置透明网关的步骤》，感谢你的慷慨之举。同时，仍有问题请教，首先如何安装 TRANSPARENT GATEWAY 选件？安装后的菜单名是什么？

jgwang

最初由 hiwanghao 发布
[B]

HS_FDS_CONNECT_INFO=192.168.1.23.masters这样设置可以吗？
上面的SQLDB应该是计算机名吧？

试了一下好像不行:ORA-02019: 未找到远程数据库的连接说明 [/B]

I did connect to SQL 2000 by data source, but no luck with SQLDB.

SQLDB stands for DB Library. According to docs, both DB Library (SQLDB) and data source work with  HS_FDS_CONNECT_INFO for SQL 7.

For simplicity, I suggest HS_FDS_CONNECT_INFO=<your ODBC data source>

Hope it helps.

jgwang

最初由 cfdai 发布
[B]我用的平台：
Windows 2000 server + Oracle9i Database 9.2.0.1.0  + Oracle9i Warehouse Builder 9.0.3.0.33
   请问如何配置透明网关获取MS SQL Server数据库中的数据？
   拜读了你的贴子《配置透明网关的步骤》，感谢你的慷慨之举。同时，仍有问题请教，首先如何安装 TRANSPARENT GATEWAY 选件？安装后的菜单名是什么？ [/B]

Perform a customized install and search previous threads regarding Transparent Gateway.

hiwanghao

Gateway technology is composed of two parts: a component that has the generic
technology to connect to a non-Oracle system, which is common to all the
non-Oracle systems, called Heterogeneous Services and a component that is specific
to the non-Oracle system that the gateway connects to. Heterogeneous Services, in
conjunction with the Transparent Gateway agent, enables transparent access to
non-Oracle systems from an Oracle environment.


如果象jgwang说的那样用ODBC的话，根本没必要用TG4MSQL，用Heterogeneous Services就可以了

marsoo

为什么要加上“透明”，有什么搞头么？
up

hiwanghao

Oracle Transparent Gateways provide the ability to transparently access data
residing in a non-Oracle system from an Oracle environment. This transparency
eliminates the need for application developers to customize their applications to
access data from different non-Oracle systems, thus decreasing development efforts
Heterogeneous Services Technology and increasing the mobility of the application. Applications can be developed using a consistent Oracle interface for both Oracle and Microsoft SQL Server,Sysbase,Acess,DB2

yunsn

太好了，正需要这方面的资料。
马上试试！！

liuxnp

不过我还没有做过，谢谢了！
可能过不久我就要配置这个东西，希望得到你的帮助！

cfdai

我按照guostong的方法进行配置，Listener可以正常侦听:
...
服务 "tg4msql" 包含 1 个例程。
  例程 "SQL2000", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功


但是还是连不上数据库。请指教！！

  工作环境：WIN2000 SERVER + ORACLE Database 9.2.0.1.0 + MS SQL SERVER 2000
    HOSTNAME ： dmserver
    使用 tcp/ip 默认端口
  SQL Server的数据库名为CFDai，用户为CFDai，建表名称为CFDai_Test
     MS ODBC 数据源名称为：SQL2000_CFDai


1: 安装 TRANSPARENT GATEWAY FOR MSSQL选件

2: 配置 LISTENER.ORA
(SID_DESC =
(GLOBAL_DBNAME = tg4sql)  
(PROGRAM = tg4msql)
(SID_NAME = sql2000)
(ORACLE_HOME = D:\oracle\ora92)
)

3: 在 D:\oracle\ora92\tg4msql\admin
建文件 initsql2000.ora
其中内容为：
HS_FDS_CONNECT_INFO="dmserver;CFDai"   # dmserver为SQL服务器名 ,CFDai为数据库名，测试了dmserver.CFDai写法
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

4: 重启 DATABASE AND LISTENER

5: 配置 tnsnames.ora
tg_sql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dmserver)(PORT = 1521))
)
(CONNECT_DATA =
(SID = sql2000)
)
(HS=OK)
)

6: 在 SQL * Plus 中建立 DATABASE LINK，
CREATE PUBLIC DATABASE LINK DB_SQL
CONNECT TO CFDai IDENTIFIED BY PASSWORD   #CFDai为用户名，PASSWORD为口令
USING 'tg_sql'

#未见任何反应

7: 完成，测试
select * from CFDai_Test@DB_SQL

Error   在第1行
ORA-02019：为找到远程数据库的连接说明

coolyl

不错，支持一下