RAC 监听的BLOCKED状态
来源:互联网 发布:女生降低体脂率 知乎 编辑:程序博客网 时间:2024/04/29 20:07
监听程序ASM服务的BLOCKED状态
默认情况下,监控器是不接受从别的节点联入ASM实例的。
因此为ASM创建的服务,状态是"BLOCKED",表示此实例不能接受连接。
Ora10gASM-> lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2008 07:39:03
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora10gASM)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 08-JUN-2008 07:14:45
Uptime 0 days 0 hr. 24 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...Service "+ASM" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "benbo" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benboXDB" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benbo_XPT" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
The command completed successfully
BLOCKED:表示此实例不能接受连接
UNKNOWN:表示此实例在listener.ora文件中注册而不是通过动态服务注册,因而不知道其状态
READY:表示此实例可接受连接
可以通过修改listener.ora文件,通过静态注册ASM实例,可使得从别的主机上可进行客户端登陆。
Ora10gASM-> vi /oracle/product/10.2.0/db_1/network/admin/listener.ora
(PROGRAM = extproc)
# listener.ora Network Configuration File: /oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
) (SID_DESC =
(SID_NAME = +ASM)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
) )
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Ora10gASM)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
"product/10.2.0/db_1/network/admin/listener.ora" 24L, 583C written
重新载入监听信息
Ora10gASM-> lsnrctl reload
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2008 07:40:40
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora10gASM)(PORT=1521)))
The command completed successfully
Ora10gASM-> lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2008 07:40:51
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora10gASM)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 08-JUN-2008 07:14:45
Uptime 0 days 0 hr. 26 min. 6 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "+ASM" has 2 instance(s).
Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service...
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "benbo" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benboXDB" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benbo_XPT" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
The command completed successfully
配置好客户端tnsnames.ora,加入到ASM的连接标识符。
asm =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.111)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
)
)
C:>sqlplus sys/oracle@asm as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on 星期日 6月 8 10:38:14 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
- RAC 监听的BLOCKED状态
- RAC环境下的阻塞(blocking blocked)
- oracle数据库监听例程blocked的处理
- rac监听状态为"Not All Endpoints Registered"
- 蓝牙状态的监听
- gallery状态的监听
- 屏幕状态的监听
- 监听activeMQ的状态
- 线程状态的区别 blocked waitting ,join 详解
- Java线程状态中BLOCKED和WAITING的区别
- RAC正确配置监听的方式
- java——线程生命周期waiting状态和blocked状态的区别
- Android电池状态的监听
- android 电话状态的监听
- Android电池状态的监听
- 监听电话的呼叫状态
- Phone状态的监听机制
- android电话状态的监听
- 内容管理系统 Ametys
- MFC实现QQ抖动
- ffmpeg编译安装支持视频常用格式
- “指定的元素已经是另一个元素的逻辑子元素,请先将其断开连接”问题的解决方法
- Java 枚举类型
- RAC 监听的BLOCKED状态
- 个人站长创业失败的原因总结
- 2012年工作总结
- 草根者创业者前期遇到的一些问题
- 换行和回车的区别
- Sqlserver中tinyint, smallint, int, bigint的区别 及 10进制转换16进制的方法
- Java程序员面试中的多线程问题
- select函数详解
- JS声明变量背后的原理