orcal 网关透明不能连接sql server
我在本机安装了orcal 和sql server2000 在本地调试可能过,但在与远端的sql server2000 就不行,见下文:
网关透明已经装好
1.配置inittg4msql.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=220.168.211.122;DATABASE=vote_2007"
HS_FDS_CONNECT_INFO =220.168.211.122.vote_2007
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
2.配置listener.ora :
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = yjf)
(ORACLE_HOME = F:\oracle\ora90)
(SID_NAME = yjf)
)
(SID_DESC =
(PROGRAM = tg4msql)
(ORACLE_HOME =F:\oracle\ora90)
(SID_NAME = tg4msql)
)
)
3. 配置tnsnames.ora :
tg4msql=
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=TCP)(HOST=zq-7c230e603639)(PORT=1521))
)
(CONNECT_DATA=(SID=tg4msql)
)
(HS=ok)
)
4。设置global_names=false
5.停止listen 然且start listen
6.测试 tnsping tg4msql 成功了
7.进入sqlplus 连接库 并创建 create database link mstest connnect to toupiao identified by ccddee using 'tg4msql'
8. select * from cdtph2008@mstest
这里就报错了
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Transparent gateway for MSSQL]DRV_InitTdp: Could not open MS-SQL Connection
ORA-02063: 紧接着2 lines(源于MSTEST)
请大家帮看看。