Linux安装getway路径不一致,【Gateway安装】Linux下 已存在DB10gR2 安装Gateway11gR2 for sybase...

在已装有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为本机ip或hostname

(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