在RAC中lsnrctl和srvctl操作监听区别
来源:互联网 发布:python可视化开发工具 编辑:程序博客网 时间:2024/05/29 05:57
朋友今天询问了一个问题RAC中使用srvctl 操作监听和lsnrctl 操作监听结果不一样,下面我通过实验说明问题
0.listener.ora文件内容
LISTENER_RAC1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521)(IP = FIRST))
)
)
SID_LIST_LISTENER_RAC1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =
/u01/app/oracle/product/10
.2.0
/db_1
)
(PROGRAM = extproc)
)
)
1.srvctl 启动监听
rac1-> srvctl start listener -n rac1
rac1-> lsnrctl status
LSNRCTL
for
Linux: Version 10.2.0.1.0 - Production on 11-MAR-2012 22:09:34
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_RAC1
Version TNSLSNR
for
Linux: Version 10.2.0.1.0 - Production
Start Date 11-MAR-2012 22:07:21
Uptime 0 days 0 hr. 2 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/u01/app/oracle/product/10
.2.0
/db_1/network/admin/listener
.ora
Listener Log File
/u01/app/oracle/product/10
.2.0
/db_1/network/log/listener_rac1
.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.21)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=1521)))
Services Summary...
Service
"PLSExtProc"
has 1 instance(s).
Instance
"PLSExtProc"
, status UNKNOWN, has 1 handler(s)
for
this service...
The
command
completed successfully
rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.....XFF.cs application ONLINE ONLINE rac1
ora....db1.srv application ONLINE ONLINE rac2
ora.devdb.db application ONLINE ONLINE rac2
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
srvctl操作监听,自动反馈到crs中
2.使用srvctl关闭监听
rac1-> srvctl stop listener -n rac1
rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.....XFF.cs application ONLINE ONLINE rac1
ora....db1.srv application ONLINE ONLINE rac2
ora.devdb.db application ONLINE ONLINE rac2
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
3.使用lsnrctl查看监听状态
rac1-> lsnrctl status
LSNRCTL
for
Linux: Version 10.2.0.1.0 - Production on 11-MAR-2012 22:15:54
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) <--host为空
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
rac1-> lsnrctl
LSNRCTL
for
Linux: Version 10.2.0.1.0 - Production on 11-MAR-2012 22:16:55
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to LSNRCTL,
type
"help"
for
information.
LSNRCTL> status listener_rac1
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)(IP=FIRST)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1521)(IP=FIRST)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
这里可以发现问题:
1)如果当前没有监听在运行,使用lsnrctl status的时候,会去检查默认的监听名称为listener的监听,如果该监听不存在不会使用hostname填充到hostname项中(注意下面的启动默认监听过程)
2)lsnrctl查看指定监听为listener_rac1,发现和listener.ora中配置相同
4.lsnrctl 关闭监听
rac1-> srvctl start listener -n rac1
rac1-> lsnrctl stop
LSNRCTL
for
Linux: Version 10.2.0.1.0 - Production on 11-MAR-2012 22:43:14
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) <--host为空
The
command
completed successfully
rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.....XFF.cs application ONLINE ONLINE rac1
ora....db1.srv application ONLINE ONLINE rac2
ora.devdb.db application ONLINE ONLINE rac2
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
这里可以说明问题:
1)lsnrctl stop虽然是要停止掉默认监听,但是也会停止掉非默认监听
2)lsnrctl stop如果默认监听不存在,那么注册host也为空
5.使用lsnrctl启动默认监听
rac1-> lsnrctl start
LSNRCTL
for
Linux: Version 10.2.0.1.0 - Production on 11-MAR-2012 22:17:37
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting
/u01/app/oracle/product/10
.2.0
/db_1/bin/tnslsnr
: please wait...
TNSLSNR
for
Linux: Version 10.2.0.1.0 - Production
System parameter
file
is
/u01/app/oracle/product/10
.2.0
/db_1/network/admin/listener
.ora
Log messages written to
/u01/app/oracle/product/10
.2.0
/db_1/network/log/listener
.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR
for
Linux: Version 10.2.0.1.0 - Production
Start Date 11-MAR-2012 22:17:37
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/u01/app/oracle/product/10
.2.0
/db_1/network/admin/listener
.ora
Listener Log File
/u01/app/oracle/product/10
.2.0
/db_1/network/log/listener
.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=1521))) <--主机名
The listener supports no services
The
command
completed successfully
rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.....XFF.cs application ONLINE ONLINE rac1
ora....db1.srv application ONLINE ONLINE rac2
ora.devdb.db application ONLINE ONLINE rac2
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
这里发现问题:
1)监听的ip只有主机名的一个,和srvctl启动的监听不一样
2)虽然监听启动了,crs中依然显示为offline状态
6.使用lsnrctl启动listener_rac1监听
LSNRCTL> start listener_rac1
Starting
/u01/app/oracle/product/10
.2.0
/db_1/bin/tnslsnr
: please wait...
TNSLSNR
for
Linux: Version 10.2.0.1.0 - Production
System parameter
file
is
/u01/app/oracle/product/10
.2.0
/db_1/network/admin/listener
.ora
Log messages written to
/u01/app/oracle/product/10
.2.0
/db_1/network/log/listener_rac1
.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.21)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias listener_rac1
Version TNSLSNR
for
Linux: Version 10.2.0.1.0 - Production
Start Date 11-MAR-2012 22:19:04
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/u01/app/oracle/product/10
.2.0
/db_1/network/admin/listener
.ora
Listener Log File
/u01/app/oracle/product/10
.2.0
/db_1/network/log/listener_rac1
.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.21)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=1521)))
Services Summary...
Service
"PLSExtProc"
has 1 instance(s).
Instance
"PLSExtProc"
, status UNKNOWN, has 1 handler(s)
for
this service...
The
command
completed successfully
rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.....XFF.cs application ONLINE ONLINE rac1
ora....db1.srv application ONLINE ONLINE rac2
ora.devdb.db application ONLINE ONLINE rac2
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
这里可以说明两个问题:
1)使用lsnrctl启动监听和srvctl启动一样
2)启动listener_rac1后,crs中监听资源变成online
7.问题原因分析
rac1-> srvctl config listener -n rac1
rac1 LISTENER_RAC1
通过这里可以发现,其实srvctl操作的监听就是LISTENER_RAC1,所以当我使用lsnrctl 操作LISTENER_RAC1监听时候crs会自动offline或者online,而lsnrctl 操作默认监听时crs不会online
原文地址:http://www.xifenfei.com/2658.html
- 在RAC中lsnrctl和srvctl操作监听区别
- 在RAC 中解决 vipca 和 srvctl 无法执行的错误
- Oracle RAC中Srvctl命令详细说明
- ORACLE RAC 中 SRVCTL 命令详细说明
- Oracle RAC中Srvctl命令详细说明
- 11g R2 RAC使用srvctl工具删除监听
- ORACLE RAC 中 SRVCTL 命令详细说明文档
- oracle rac数据库的CRSCTL和SRVCTL命令
- 11g R2 RAC使用srvctl工具添加监听并手动加入静态注册信息
- oracle 监听 lsnrctl 命令
- 配置和自动启动Oracle的监听(lsnrctl)
- 【转】配置和自动启动Oracle的监听(lsnrctl)
- RAC 管理(crs_stat、crsctl、srvctl)
- RAC 管理(crs_stat、crsctl、srvctl)
- RAC 管理(crs_stat、crsctl、srvctl)
- 利用srvctl管理Oracle RAC
- RAC 管理(crs_stat、crsctl、srvctl)
- 监听程序控制实用程序命令:lsnrctl
- Guvnor学习
- Buyer's Call
- android fragment详解
- form表单文字垂直居中设计方案
- 在VS.net(C#)里,设置程序在启动时默认"以管理员身份运行"的方法
- 在RAC中lsnrctl和srvctl操作监听区别
- Fragment对比Activity
- 简单制作Android开机动画
- ExtAsp.Net中弹出新窗口并得到返回值(TriggerBox控件)
- 一步一步学做游戏 第一回:游戏分析
- Get - When you don't know phrasal verbs, use "GET"
- 一步一步学做游戏 第二回:让蘑菇随鼠标动起来
- 典型的 C++ 程序员成长经历
- input框二例子提交检测的示范例子