ORACLE 11GR2 配置GATEWAY FOR SERVER 问题

配置GATEWAY FOR SERVER 的过程如下： 1、环境：           Oracle Database 11 g  Release 2 (11.2)                    Oracle Database 11 g  Release 2 (11.2) Gateways           (oracle db 和gateway 位于同一台服务器（linux redhat6.5)）           SQL SERVER 2008 R2           (位于另一台服务器（window server 2008)) 2、按matalink的步骤，安装完成gateway。       由于gateway和database 版本一致，所以安装的 ORACLE_HOME目录相同 3、配置相关文件initdg4msql.ora ，如下   [oracle@TieshengTest admin]$ cat initdg4msql.ora # This is a customized agent init file that contains the HS parameters # that are needed for the Database Gateway for Microsoft SQL Server # # HS init parameters # HS_FDS_CONNECT_INFO=[10.38.100.17]:1433//EBSData # alternate connect format is hostname/serverinstance/databasename HS_FDS_TRACE_LEVEL=OFF HS_FDS_RECOVERY_ACCOUNT=RECOVER HS_FDS_RECOVERY_PWD=RECOVER 4、配置listener.ora 如下 [oracle@TieshengTest admin]$ cat listener.ora  # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dghome_1/network/admin/listener.ora # Generated by Oracle configuration tools. GW_LINK =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = TieshengTest.gj.com)(PORT = 1522))     )   ) SID_LIST_GW_LINK =   (SID_LIST =     (SID_DESC =       (SID_NAME = dg4msql)       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dghome_1)       (PROGRAM = dg4msql)     )    ) ADR_BASE_GW_LINK = /u01/app/oracle 5、配置tnsnames.ora 如下 [oracle@TieshengTest admin]$ cat tnsnames.ora  # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. TESTDB =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = TieshengTest.gj.com)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = TESTDB)     )   ) dg4msql  =   (DESCRIPTION=     (ADDRESS=(PROTOCOL=tcp)(HOST=TieshengTest.gj.com)(PORT=1522))     (CONNECT_DATA=(SID=dg4msql))     (HS=OK)   )  6、启动监听--OK 7、创建DBLINK Create public database link VBA connect to "sa" identified by "root" using 'dg4msql'; 8、查询提示如下错误，反复尝试，一直提示如下异常（看看哪位有没有碰到过这种情况，怎么处理的？） SQL> select * from hwtest@VBA; select * from hwtest@VBA                      * ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from VBA