oracle 监听启动的时候 lsnrctl start 的显示 什么服务read unknown 之类的解释

Listener Status
June 8, 2009
Tags: oracle listener    

监听有三种状态:block、unkown、ready
Service “+ASM” has 1 instance(s).
Instance “+ASM2″, status BLOCKED, has 1 handler(s) for this service…
监听有动态注册与静态注册两种
动态注册的情况下,服务的状态主要是以下2种:

BLOCKED:表示此实例不能接受客户端连接,只能通过本机访问。ASM实例不需要客户端连接,当然是BLOCK状态。如果客户端需要访问ASM,将ASM实例配置为静态注册即可!
READY:表示此实例可接受连接
UNKNOWN状态,表示此实例在listener.ora文件中注册而不是通过动态服务注册,因而不知道其状态。
下面是RAC监听的配置文件,动态注册
LISTENER_NEWSDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = newsdb1-vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 本机物理IP)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

监听状态:
Service “+ASM_XPT” has 1 instance(s).
Instance “+ASM2″, status BLOCKED, has 1 handler(s) for this service…
Service “dyora” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 2 handler(s) for this service…
Service “newsdb” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 2 handler(s) for this service…
Service “newsdbXDB” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 1 handler(s) for this service…
Service “newsdb_XPT” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 2 handler(s) for this service…
静态注册:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /db/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = IntranetOracle)
(ORACLE_HOME = /db/oracle/product/10.2.0/db_1)
(SID_NAME = cdcIntranet)
)
)
)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值