AIX+Oracle 11gR2安装及配置Gateway透明网关

环境信息：

Oracle

操作系统： AIX 6.1版本 oracle版本：11.2.0.3 oracle IP：172.16.7.80 ORACLE_SID = orcl

ORACLE_HOME = /orcl/app/product/11.2.0/orcl

SQLServer

操作系统： Windows Server 2008 SQLServer版本: SQL Server 2008 SQLServer IP: 192.168.8.90 数据库名:oadata

Gateway

操作系统： AIX 6.1 版本: 11.2.0.3

安装目录: /home/gateway/gwhome IP： 172.16.7.80

Oracle与Gateway均安装在AIX小机172.16.7.80上，连接Windows Server上的SQLServer 2008.

操作步骤：

1. 从oracle官网上下载透明网关的安装包。 2. 创建gateway用户, 用户组与oracle用户相同:

#useradd -u 224 -g oinstall -G oinstall,dba -m -d /home/gateway -s /usr/bin/ksh gateway #passwd gateway

3. 以gateway用户登陆，在/home/gateway目录下mkdir gwhome.

4. 修改gateway用户的.profile文件，增加如下内容： export ORACLE_HOME=/home/gateway/gwhome export LD_LIBRARY_PATH=$ORACLE_HOME/lib export TNS_ADMIN=$ORACLE_HOME/network/admin export PATH=$ORACLE_HOME/bin:$PATH

5. 安装gateway软件。选择相应的sqlserver组件。在配置SQLServer的时候，需注意，SQL Server Database Name应该填写需要连接的数据库名称，这里应填写oadata；SQLServer Instance Name为空。 最后配置监听的时候选择典型配置。 6. 修改gateway的参数文件

/home/gateway/gwhome/dg4msql/admin/initdg4msql.ora. initdg4msql.ora文件是默认生成的. 为方便统一管理, 将该文件改名为init+SID.ora。在本例中，应将该文件改名为initoadata.ora。 修改文件内容如下：

HS_FDS_CONNECT_INFO=[192.168.8.90]:1433//oadata

# alternate connect format is hostname/serverinstance/databasename HS_FDS_TRACE_LEVEL=OFF HS_FDS_RECOVERY_ACCOUNT=sa HS_FDS_RECOVERY_PWD=yilingpass 7. 修改gateway的监听文件

/home/gateway/gwhome/network/admin/listener.ora。 文件内容如下： SID_LIST_LISTENER = (SID_LIST = (SID_DESC =

(SID_NAME = oadata)

(ORACLE_HOME = /home/gateway/gwhome) (PROGRAM =dg4msql) ) )

LISTENER =

(DESCRIPTION_LIST = (DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.7.80)(PORT = 1522)) ) )

ADR_BASE_LISTENER = /home/gateway/gwhome

8. 修改gateway的tnsnames.ora文件

（/home/gateway/gwhome/network/admin/tnsnames.ora），内容如下： ORCL =

(DESCRIPTION = (ADDRESS_LIST =

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

(CONNECT_DATA = (SERVICE_NAME = orcl) ) )

dg4msql = (DESCRIPTION = (ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.7.80)(PORT = 1522)) )

(CONNECT_DATA = (SID = oadata) ) (HS=OK) )

9. 以oracle用户登陆，修改oracle的监听文件listener.ora（/orcl/app/product/11.2.0/orcl/network/admin），内容如下： SID_LIST_LISTENER = (SID_LIST = (SID_DESC =

(SID_NAME = oadata)

(ORACLE_HOME = /orcl/app/product/11.2.0/orcl) ) )

LISTENER =

(DESCRIPTION_LIST = (DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) )

(DESCRIPTION =

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

ADR_BASE_LISTENER = /orcl/app

10. 修改oracle的tnsnames.ora文件。

（/orcl/app/product/11.2.0/orcl/network/admin） DG4MSQL = (DESCRIPTION = (ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.7.80)(PORT = 1522)) )

(CONNECT_DATA = (SID = oadata) )

(HS=OK) ) ORCL =

(DESCRIPTION = (ADDRESS_LIST =

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

(CONNECT_DATA = (SERVICE_NAME = orcl) ) )

11. 查看gateway监听的状态，应存在一个oadata服务，如下： $ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 19-FEB-2014 09:03:33

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))

STATUS of the LISTENER ------------------------ Alias LISTENER

Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production

Start Date 18-FEB-2014 16:09:34 Uptime 0 days 16 hr. 53 min. 58 sec Trace Level off

Security ON: Local OS Authentication SNMP ON

Listener Parameter File /home/gateway/gwhome/network/admin/liste

ner.ora

Listener Log File /home/gateway/gwhome/diag/tnslsnr/test1/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.7.80)(PORT=1522)))

Services Summary...

Service \

Instance \ The command completed successfully

12. 重启oracle 的监听。查看状态，应如下： $ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 19-FEB-2014 09:04:38

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER ------------------------ Alias LISTENER

Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production

Start Date 18-FEB-2014 16:51:15 Uptime 0 days 16 hr. 13 min. 23 sec Trace Level off

Security ON: Local OS Authentication SNMP ON

Listener Parameter File /orcl/app/product/11.2.0/orcl/network/admin/l

istener.ora

Listener Log File /orcl/app/diag/tnslsnr/test1/listener/alert/log.xml Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.7.80)(PORT=1521)))

Services Summary...

Service \

Instance \Service \

Instance \Service \

Instance \The command completed successfully

13. 用pl/sql连接Oracle，执行如下命令创建数据库链接db link：

create database link oadata connect to sa identified by yilingpass using 'DG4MSQL';

14. 执行如下命令验证db link是否创建成功： select count(0) from hrmresource@oadata;

如果查询后能够显示正常数据，表明Gateway配置成功。

本文来源：https://www.bwwdw.com/article/nd3h.html