在已装有Oracle DB 10gR2的Linux环境下安装 gateway 11g for sybase


1.建立安装目录

[oracle@QGYT01~]$ mkdir /u03/gateway

 

2.使用OUI安装

[oracle@QGYT01gateways]$ ./runInstaller

 


注意:由于数据库版本与gateway版本不同,因此不能在原oracle_home目录下安装gateway,要使用新目录,否则bin下的程序会被覆盖,导致oracle软件不可用。

 





[root@QGYT01 ~]# /u03/gate/root.sh

RunningOracle 11g root.sh script...

 

Thefollowing environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u03/gate

 

Enter thefull pathname of the local bin directory: [/usr/local/bin]: /u03/gate/local/bin

Creating/u03/gate/local/bin directory...

   Copying dbhome to /u03/gate/local/bin ...

   Copying oraenv to /u03/gate/local/bin ...

   Copying coraenv to /u03/gate/local/bin ...

 

Entrieswill be added to the /etc/oratab file as needed by

DatabaseConfiguration Assistant when a database is created

Finishedrunning generic part of root.sh script.

Nowproduct-specific root actions will be performed.

 


此处是配置监听,由于我安装之前有装数据库,已经安装了监听,因此在这里不再安装。



 

3.确认或修改HS初始话参数文件initdg4sybs.ora

[oracle@QGYT01admin]$ more initdg4sybs.ora

# This isa customized agent init file that contains the HS parameters

# thatare needed for the Database Gateway for Sybase

 

#

# HS initparameters

#

HS_FDS_CONNECT_INFO=[192.168.131.57]:4100/amtrix

HS_FDS_TRACE_LEVEL=OFF

HS_FDS_RECOVERY_ACCOUNT=RECOVER

HS_FDS_RECOVERY_PWD=RECOVER

这个是我们之前安装gateway写的sybase数据库连接信息,如果当初没有写错,则无需修改,忽略此步。


4.修改监听,增加静态监听服务

[oracle@QGYT01 admin]$ vi listener.ora

 

#listener.ora Network Configuration File: /u01/oracle/product/10.2.0/db/network/admin/listener.ora

#Generated by Oracle configuration tools.

 

SID_LIST_LISTENER=

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME =/u01/oracle/product/10.2.0/db)

      (PROGRAM = extproc)

)

    (SID_DESC=

        (SID_NAME=dg4sybs)                  --initdg4sybs.ora一致

        (ORACLE_HOME=/u03/gateway)             --gateway安装目录(bin的上级目录)

        (PROGRAM=dg4sybs)                 --gateway安装目录bin目录下的程序

    )

  )

 

LISTENER=

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST =QGYT01)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC0))

    )

  )

 

ADR_BASE_LISTENER = /u01/oracle

配置好之后,重启监听

 

5.配置tnsnames.ora

--加入以下内容

dg4sybs =

  (DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.131.120)(PORT=1521))       

--HOST为本机iphostname

    (CONNECT_DATA=(SID=dg4sybs))

    (HS=OK)

  )

 

--用 tnsping dg4sybs测试一下:

[oracle@QGYT01 admin]$ tnsping dg4sybs

 

TNS PingUtility for Linux: Version 10.2.0.5.0 - Production on 12-JUN-2014 13:53:43

 

Copyright(c) 1997,  2010, Oracle.  All rights reserved.

 

Usedparameter files:

 

 

UsedTNSNAMES adapter to resolve the alias

Attemptingto contact (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.131.120)(PORT=1521))(CONNECT_DATA=(SID=dg4sybs)) (HS=OK))

OK (0msec)

 

6.建立db_link

CREATE  DATABASELINK sybase_ssdd_linkCONNECTTO"sa"IDENTIFIEDBY" "USING'dg4sybs'

 

7.测试

select count(*)from"XQW_ERROR_INFO"@sybase_ssdd_link; 

COUNT(*)

----------

    140928

1 row selected.

 

成功!


8.建立新的sybase数据库连接


1.新建initdg4sybs2.ora

[oracle@QGYT01 admin]$ cp initdg4sybs.ora initdg4sybs2.ora

[oracle@QGYT01 admin]$ vi initdg4sybs2.ora

 

# This isa customized agent init file that contains the HS parameters

# thatare needed for the Database Gateway for Sybase

 

#

# HS initparameters

#

HS_FDS_CONNECT_INFO=[192.168.131.57]:4100/amtrix

HS_FDS_TRACE_LEVEL=OFF

HS_FDS_RECOVERY_ACCOUNT=RECOVER

HS_FDS_RECOVERY_PWD=RECOVER

 

# This isa customized agent init file that contains the HS parameters

# thatare needed for the Database Gateway for Sybase

 

#

# HS initparameters

#

HS_FDS_CONNECT_INFO=[192.168.131.57]:4100/amtrix

HS_FDS_TRACE_LEVEL=OFF

HS_FDS_RECOVERY_ACCOUNT=RECOVER

HS_FDS_RECOVERY_PWD=RECOVER

 

2.新增tns服务

dg4sybs2 =

  (DESCRIPTION=

   (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.131.120)(PORT=1521))

    (CONNECT_DATA=(SID=dg4sybs2))                     --与initdg4sybs2.ora一致

    (HS=OK)

  )

 

3.修改并重启listener

[oracle@QGYT01 admin]$ vi listener.ora

 

#listener.ora Network Configuration File:/u01/oracle/product/10.2.0/db/network/admin/listener.ora

# Generatedby Oracle configuration tools.

 

SID_LIST_LISTENER=

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME =/u01/oracle/product/10.2.0/db)

      (PROGRAM = extproc)

    )

    (SID_DESC=

         (SID_NAME=dg4sybs)

         (ORACLE_HOME=/u03/gateway)

         (PROGRAM=dg4sybs)

    )

    (SID_DESC=

         (SID_NAME=dg4sybs2)                               --与initdg4sybs2.ora一致

         (ORACLE_HOME=/u03/gateway)

        (PROGRAM=dg4sybs)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST =QGYT01)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC0))

    )

  )

 

ADR_BASE_LISTENER= /u01/oracle


4.建立db_link

CREATE  DATABASELINK sybase_amtrix_linkCONNECTTO"sa"IDENTIFIEDBY" "USING 'dg4sybs2';

 

5.测试

select * from "test"@sybase_amtrix_link;

id            

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

3             

1 row selected.

 

成功!



Sharon

2014.06.12


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

转载须注明出处!

http://blog.csdn.net/sharqueen_wu/article/details/30244317

转载须注明出处!

http://blog.csdn.net/sharqueen_wu/article/details/30244317

转载须注明出处!

http://blog.csdn.net/sharqueen_wu/article/details/30244317








 

Logo

权威|前沿|技术|干货|国内首个API全生命周期开发者社区

更多推荐