请教一个Oracle透明网关的问题(oracle连接sqlserver)
之前dblink是可以连接的，tnsnames中加入了一个新服务后，不能连接这个新连接名，然后删除了这个新服务，之前的dg4msql还在。

我是在windows服务里面关闭了oracle11g的透明网关监听，再启动的时候就不能启动了
我通过net manager 删除了监听，建了一个LISTENER1522的监听，监听就启动起来了
删除dblink后重新创建，使用
drop public database link test;
create public database link test connect to sa identified by "test123$" using 'dg4msql';
select 1 from dual@test;
第 1 行出现错误:
ORA-28545: 连接代理时 Net8 诊断到错误
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: 紧接着 2 lines (起自 TEST)

------------------

透明网关的配置如下：

IP规划

192.168.1.149 sqlserver　ip

192.168.1.143 oracle ip 数据库SID ORCL

Oracle数据库和Oracle透明网关在同一个机器192.168.1.143上，通过odbc，使用pos用户连接上了sqlserver，服务名testdb有驱动了。

透明网关的配置

D:\product\11.2.0\tg_1\dg4msql\admin\initdg4msql.ora

HS_FDS_CONNECT_INFO=[192.168.1.149]//testdb

HS_FDS_TRACE_LEVEL=OFF

HS_FDS_RECOVERY_ACCOUNT=RECOVER

HS_FDS_RECOVERY_PWD=RECOVER

D:\product\11.2.0\tg_1\NETWORK\ADMIN\listener.ora

SID_LIST_LISTENER =  

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = dg4msql)

      (ORACLE_HOME = D:\product\11.2.0\tg_1)

      (PROGRAM = dg4msql)

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.143)(PORT = 1522))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))

    )

  )

ADR_BASE_LISTENER = D:\product\11.2.0\tg_1

D:\product\11.2.0\tg_1\NETWORK\ADMIN\tnsnames.ora

改为

dg4msql =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.143)(PORT = 1522))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = dg4msql)

    )

    (HS = OK)

  )

D:\app\Admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = D:\app\Admin\product\11.2.0\dbhome_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Admin\product\11.2.0\dbhome_1\bin\oraclr11.dll")

    )

    (SID_DESC =

      (GLOBAL_DBNAME = ORCL)

      (ORACLE_HOME = D:\app\Admin\product\11.2.0\dbhome_1)

      (SID_NAME = ORCL)

    )

    (SID_DESC =

      (SID_NAME = dg4msql)

      (ORACLE_HOME = D:\app\Admin\product\11.2.0\dbhome_1)

      (PROGRAM = dg4msql)

    )

  )

LISTENER1522 =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.143)(PORT = 1522))

    )

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))

    )

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))

    )

  )

ADR_BASE_LISTENER1522 = D:\product\11.2.0\tg_1

Oracle服务器配置tns

D:\app\Admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

dg4msql =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.143)(PORT = 1522))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = dg4msql)

    )

    (HS = OK)

  )