看来是第二节点监听的问题 但是不会修复 高手再帮我看看吧
这是我crs状态
crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM2.asm application ONLINE ONLINE cprhelbs
ora....BS.lsnr application ONLINE ONLINE cprhelbs
ora....lbs.gsd application ONLINE ONLINE cprhelbs
ora....lbs.ons application ONLINE ONLINE cprhelbs
ora....lbs.vip application ONLINE ONLINE cprhelbs
ora....SM1.asm application ONLINE ONLINE cprhelds
ora....DS.lsnr application ONLINE ONLINE cprhelds
ora....lds.gsd application ONLINE ONLINE cprhelds
ora....lds.ons application ONLINE ONLINE cprhelds
ora....lds.vip application ONLINE ONLINE cprhelds
第一节点lsnrctl status
lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-SEP-2009 15:36:28
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_CPRHELDS
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 30-SEP-2009 15:35:25
Uptime 0 days 0 hr. 1 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/rac_db/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/rac_db/network/log/listener_cprhelds.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.111.41.195)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", 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...
The command completed successfully
这是第二节点的结果报错
lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-SEP-2009 15:37:13
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS: no listener
TNS-12560: TNS: protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
看来是第二节点的监听没起来
但是crs_stat显示如下结果
crs_stat -t |grep lsnr
ora....BS.lsnr application ONLINE ONLINE cprhelbs
ora....DS.lsnr application ONLINE ONLINE cprhelds
我已经尝试过用dbca删除监听以后重新配置
删除正常,重新添加也正常
crs_start ora.cprhelbs.LISTENER_CPRHELBS.lsnr 也能正常启动和停止
可是用lsnrctl status还是不行 请问下一步该怎么查呢?
[本帖最后由 dfrog 于 2009-9-30 15:44 编辑]