当前位置:  数据库>oracle

Oracle RAC下添加静态注册监听器listener

    来源: 互联网  发布时间：2017-05-08

    本文导语: 通过设置不同的listener，可以在一台服务器多实例c环境下实现业务的隔离，方便业务起停和管理。添加的方法除了netca外，比较简单的方式是使用srvctl命令，具体用法如下 [grid@dtydb5 ~]$ srvctl add listener -h Adds a listener configuration to th...

通过设置不同的listener，可以在一台服务器多实例c环境下实现业务的隔离，方便业务起停和管理。添加的方法除了netca外，比较简单的方式是使用srvctl命令，具体用法如下

[grid@dtydb5 ~]$ srvctl add listener -h

Adds a listener configuration to the Oracle Clusterware.

Usage: srvctl add listener [-l ] [-s] [-p "[TCP:][, ...][/IPC:][/NMP:][/TCPS:] [/SDP:]"] [-o ] [-k ]
    -l            Listener name (default name is LISTENER)
    -o          ORACLE_HOME path (default value is CRS_HOME)
    -k              network number (default number is 1)
    -s                       Skip the checking of ports
    -p "[TCP:][, ...][/IPC:][/NMP:][/TCPS:] [/SDP:]"       Comma separated tcp ports or listener endpoints
    -h                       Print usage





具体过程如下，数据库是oracle 11gr2版本


1，开始添加 ，使用grid用户 

[grid@dtydb5 admin]$ srvctl add listener -l listener_epm -p 1522 -o $ORACLE_HOME

2，启动
srvctl start listener -l listener_epm


启动后相关文件才发生变化
[grid@dtydb5 admin]$ cat listener.ora
LISTENER_EPM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_EPM))))            # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
#LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))           # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent







ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_EPM=ON          # line added by Agent
[grid@dtydb5 admin]$
[grid@dtydb5 admin]$
[grid@dtydb5 admin]$
[grid@dtydb5 admin]$ cat endpoints_listener.ora
LISTENER_EPM_DTYDB5=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dtydb5-vip)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.235)(PORT=1522)(IP=FIRST))))                # line added by Agent
LISTENER_DTYDB5=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dtydb5-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.235)(PORT=1521)(IP=FIRST))))            # line added by Agent





3,查看资源的状态online
ora.LISTENER_EPM.lsnr
               ONLINE  ONLINE       dtydb3                                      
               ONLINE  ONLINE       dtydb4                                      
               ONLINE  ONLINE       dtydb5



[grid@dtydb5 admin]$ lsnrctl status listener_epm

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 13-SEP-2012 10:16:48

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_EPM)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_EPM
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                13-SEP-2012 10:14:17
Uptime                    0 days 0 hr. 2 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/11.2.0/grid/network/admin/listener.ora
Listener Log File         /oracle/11.2.0/grid/log/diag/tnslsnr/dtydb5/listener_epm/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_EPM)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.235)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.245)(PORT=1522)))
The listener supports no services
The command completed successfully
















4,vi listener.ora 添加以下信息，主要要修改三个节点的信息（后来证实，本步骤可以省略，可能因为静态监听信息已在endpoints_listener.ora文件中了）

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
     (GLOBAL_DBNAME = epmdb)
     (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1)
     (SID_NAME = epmdb3)
    )
   )






5, 重启listener
[grid@dtydb5 admin]$ srvctl stop listener -l listener_epm
[grid@dtydb5 admin]$ srvctl start listener -l listener_epm


这时服务还是没有注册上来
[grid@dtydb5 admin]$ lsnrctl status listener_epm

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 13-SEP-2012 10:27:15

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_EPM)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_EPM
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                13-SEP-2012 10:26:35
Uptime                    0 days 0 hr. 0 min. 40 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/11.2.0/grid/network/admin/listener.ora
Listener Log File         /oracle/11.2.0/grid/log/diag/tnslsnr/dtydb5/listener_epm/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_EPM)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.235)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.245)(PORT=1522)))
The listener supports no services
The command completed successfully
















6,什么原因？应该是local_listener设置问题,还需要修改该参数

sys@EPMDB3(dtydb5)> show parameter local

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                 DRESS=(PROTOCOL=TCP)(HOST=10.4
                                                 .124.245)(PORT=1521))))



sys@EPMDB3(dtydb5)> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.245)(PORT=1522))))' scope=both sid='*';

系统已更改。
 alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.243)(PORT=1522))))' scope=both sid='epmdb1';
  alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.244)(PORT=1522))))' scope=both sid='epmdb2';
   alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.245)(PORT=1522))))' scope=both sid='epmdb3';


 

7，已成功注册
[grid@dtydb5 admin]$ lsnrctl status  LISTENER_EPM

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 13-SEP-2012 10:40:47

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_EPM)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_EPM
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                13-SEP-2012 10:26:35
Uptime                    0 days 0 hr. 14 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/11.2.0/grid/network/admin/listener.ora
Listener Log File         /oracle/11.2.0/grid/log/diag/tnslsnr/dtydb5/listener_epm/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_EPM)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.235)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.245)(PORT=1522)))
Services Summary...
Service "epmdb" has 1 instance(s).
  Instance "epmdb3", status READY, has 1 handler(s) for this service...
The command completed successfully



















    
 
 
 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。












  • 相关文章推荐
  • Oracle静态注册与动态注册详解
  • Oracle 12c发布简单介绍及官方下载地址
  • 在linux下安装oracle,如何设置让oracle自动启动！也就是让oracle那个服务自动启动，不是手动的
  • oracle 11g最新版官方下载地址
  • 请问su oracle 和su - oracle有什么不同？
  • Oracle 数据库(oracle Database)Select 多表关联查询方式
  • 虚拟机装Oracle R12与Oracle10g
  • Oracle数据库(Oracle Database)体系结构及基本组成介绍
  • Oracle 数据库开发工具 Oracle SQL Developer
  • 如何设置让Oracle SQL Developer显示的时间包含时分秒
  • Oracle EBS R12 支持 Oracle Database 11g
  • Oracle 10g和Oracle 11g网格技术介绍
  • SCO unix下安装oracle，但没有光盘，请大家推荐一个oracle下载站点（unix版本的）。谢谢！！！！
  • oracle中如何把表中具有相同值列的多行数据合并成一行
  • 请问大家用oracle数据库, 用import oracle.*;下的东西么? 还是用标准库?
  • Oracle 数据库(oracle Database)性能调优技术详解
  • Linux /$ORACLE_HOME $ORACLE_HOME
  • ORACLE日期相关操作
  • 请问在solaris下安装ORACLE，用root用户和用oracle用户安装有什么区别么？
  • ORACLE数据库常用字段数据类型介绍
  • 网间Oracle的连接，远程连接Oracle服务器？？
  • Oracle 12c的九大最新技术特性介绍
  • 请教：.profile中：if [ -d /opt/oracle/db01/app/oracle/product/9.2.0 ]是什么意思？


    • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除！

    ©2012-2021,