oracle使用dblink访问sql server2000问题!!!!!

luoyahu 2008-07-25 10:19:04

测试环境:
机器a:oracle 10g和透明网关..xp系统
IP:192.168.1.152
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

机器b:ms sqlserver 2000 专业版.xp系统
IP:192.168.1.101

现在要使用dblink访问sqlserver 2000中的数据.我参照了网上的一些例子.配置如下:
inittg4msql.ora
HS_FDS_CONNECT_INFO="SERVER=192.168.1.101;DATABASE=pubs"
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 = D:\oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = tg4msql)
(ORACLE_HOME = D:\oracle)
(PROGRAM = tg4msql)
)
)
tnsnames.ora
KINGDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.152)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = kingdb)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
sql2k =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.152)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql)
)
(HS=OK)
)

然后创建dblink;
SQL> connect system/xxxxx
SQL> create database link mslink connect to "sa" identified by "xxxxxx" using 'sql2k';
SQL> select * from jobs@mslink;
结果就卡在这里了.没反映了.也没出错!!!!!
大家来帮帮忙.....

...全文