请高手给排障,多谢了

岁月如歌

我用ODBC 到 MSSQL已通DSN:TRAFFIC,现在要用 GENERIC CONNECT 在ORACLE连MSSQL
我配置了三个文件
INITTRAFFIC.ORA
      HS_FDS_CONNECT_INFO = traffic
       HS_FDS_TRACE_LEVEL = ON
LISTENER.ORA增加
    (SID_DESC=
      (SID_NAME=traffic)
      (ORACLE_HOME=C:\oracle\ora9)
      (PROGRAM=hs)
   
TNSNAMES.ORA增加
traffic  =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
    (CONNECT_DATA=(SID=traffic))
    (HS=OK)
  )

建好 DBLINK后
查询MSSQL中的表报错
SQL>; /
select count(*) from dbo.RESULT0@test
                                 *
ERROR 位于第 1 行:
ORA-28509: 无法创建与非 Oracle 系统的连接
ORA-02063: 紧接着line（源于TEST）

LISTERNER.LOG中有
22-1月 -2003 10:38:02 * (CONNECT_DATA=(SID=traffic)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=3199)) * establish * traffic * 12500
TNS-12500: TNS：监听器未能启动专用的服务器进程
TNS-12560: TNS: 协议适配器错误
  TNS-00530: 协议适配器错误
   32-bit Windows Error: 2: No such file or directory

哪位高手帮忙给看一下啊,多谢了

岁月如歌

谢 了

岁月如歌

各位请帮忙呀

流云飞渡

ORA-28509: unable to establish a connection to non-Oracle system
Cause:
Initialization of a database link to a non-Oracle system failed to connect
to the Heterogeneous Services agent process for this non-Oracle system.
Action：
Check the Net8 service name definition in the following places:
n in the USING clause of the CREATE DATABASE LINK statement
n in the TNSNAMES.ORA file
n in the Oracle Names Server
Possible reasons for name mismatches are:
n The USING clause in the CREATE DATABASE LINK statement has to
match the service name defined in TNSNAMES.ORA or in the Oracle
Names Server
n The service name definition to connect to a non-Oracle system, requires
additional Heterogeneous Services information. This information is agent
specific.Please see the agent’s Installation and User’s Guide for more infor-mation.
n The protocol-specific information in the service name definition must
match the protocol-specific definition of the listener.
n The SID=<name>; in the service name definition (TNSNAMES.ORA file or
in Oracle Names Server) must match the value in the LISTENER.ORA file
for the responding listener.
－－－－－－－－－－－－－－
ORA-02063: preceding str from name
Cause: An Oracle error message was received from a remote database link.
Action: Refer to the preceding messages. Correct the problem mentioned in
the preceding messages and try the operation again.

岁月如歌

楼上的，这个错误信息我也会查
我把我做的配置都给出来了，你要是真会，就帮我看看，谢了