ITPub博客

首页 > 数据库 > Oracle > oracle 11G RAC scan监听器配置静态注册

oracle 11G RAC scan监听器配置静态注册

原创 Oracle 作者:OGG-01161 时间:2015-08-25 09:20:20 0 删除 编辑
oracle 11G RAC scan监听器配置静态注册,解决无法访问oem
     oracle 11G Rac,静态监听配置只需要在listener.ora文件中增加SID_LIST——部分,在配置11G RAC时候,经常remote_listener还是按照10 RAC方式配置,
导致11G OEM无法访问,这个时候需要配置scan 监听静态注册。
1、配置静态监听
 /oracle/grid/network/admin/listener.ora
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
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

SID_LIST_LISTENER_SCAN1 =  
             (SID_LIST =
               (SID_DESC =       
                 (SID_NAME = PLSExtProc)
                 (ORACLE_HOME = /oracle/db/product/db1)
                 (PROGRAM = extproc)
               )
               (SID_DESC=         
                  (GLOBAL_DBNAME=gzdb)  
                  (ORACLE_HOME=/oracle/db/product/db1)  
                  (SID_NAME=gzdb1)   
                )
               (SID_DESC=         
                  (GLOBAL_DBNAME=gzdb)  
                  (ORACLE_HOME=/oracle/db/product/db1)  
                  (SID_NAME=gzdb2)   
                )
             )


2、查看scan监听状态,实例1和实例2都已经注册到SCAN监听

# su - grid
DB1-> lsnrctl status LISTENER_SCAN1


LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 25-AUG-2015 09:12:46


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


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date                24-AUG-2015 10:19:11
Uptime                    0 days 22 hr. 53 min. 35 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/grid/network/admin/listener.ora
Listener Log File         /oracle/crs/diag/tnslsnr/DB1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.96.4.55)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "gzdb" has 2 instance(s).
  Instance "gzdb1", status UNKNOWN, has 1 handler(s) for this service...
  Instance "gzdb2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
DB1-> 


3、通过IE访问OEM




来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/27571661/viewspace-1781747/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 自动收集awr报告
请登录后发表评论 登录
全部评论

注册时间:2012-08-11

  • 博文量
    55
  • 访问量
    157573