oracle 10g 透明网关访问 sql server2008查询没有反应

[an5168]

我是内网测试,我的oracle和透明网关都是10.2的版本
1.oracle 10g gateways 环境 window xp
ip:192.168.1.147
2.oracle database
ip:192.168.1.101
3.sql server 2008
ip: 192.168.1.111

透明网关的两个配置
tg4msql\admin下的inittest.ora

# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for SQL Server
# HS init parameters
HS_FDS_CONNECT_INFO="SERVER=192.168.111;DATABASE=test"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

listener.ora
SID_LIST_LISTENER =
(SID_LIST =
( SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\10.2.0\tg_1)
(PROGRAM = extproc)
)
( SID_DESC=
(SID_NAME = test)
(ORACLE_HOME = c:\oracle\10.2.0\tg_1 (PROGRAM = tg4msql)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.147)(PORT = 1521))
)
)

oracle 10g中的配置 tnsnames.ora
# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
test=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=TCP) (HOST=192.168.1.147) (PORT=1521))
(CONNECT_DATA= (SID=test))
(HS=OK)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


创建数据库连接以后,查询没有任何反应.就是无限等待.小弟跪求啊。哪位高手大哥知道的解决下

[an5168]

高手求救啊..

[an5168]

自己先顶下.tnsping test.是成功的.
透明网关中的监听test也是有的.

[jsjrj_1]

楼主，你的问题解决了吗？我也遇到同样的问题。