ITPub博客

ORACLE 11GR2 配置GATEWAY FOR SERVER 问题

原创 Oracle 作者:skyyang2018 时间:2018-10-11 10:58:01 2 删除 编辑

配置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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2018-10-11

  • 博文量
    1
  • 访问量
    318