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

          

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31557823/viewspace-2215943/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31557823/viewspace-2215943/