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

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配置成功。

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新工程科技AIX+Oracle 11gR2安装及配置Gateway透明网关 (2)全文阅读和word下载服务。