Oracle 11gR2 RAC TNS-12542: TNS:address already in use 故障一例(二)

2014-11-24 18:09:56 · 作者: · 浏览: 1
ave-db1 Started
ONLINE ONLINE dave-db2 Started
ora.gsd
OFFLINE OFFLINE dave-db1
OFFLINE OFFLINE dave-db2
ora.net1.network
ONLINE ONLINE dave-db1
ONLINE ONLINE dave-db2
ora.ons
ONLINE ONLINE dave-db1
ONLINE ONLINE dave-db2
ora.registry.acfs
ONLINE ONLINE dave-db1
ONLINE ONLINE dave-db2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE INTERMEDIATE dave-db1 Not All Endpoints Registered

ora.cvu
1 ONLINE ONLINE dave-db1
ora.dave-db1.vip
1 ONLINE ONLINE dave-db1
ora.dave-db2.vip
1 ONLINE ONLINE dave-db2
ora.oc4j
1 ONLINE ONLINE dave-db1
ora.oradb.db
1 ONLINE ONLINE dave-db2 Open
2 ONLINE ONLINE dave-db1 Open
ora.scan1.vip
1 ONLINE ONLINE dave-db1


注意2:


通过crsctl stat resource –t命令,我们可以看到节点1上的ora.LISTENER.lsnr状态是 INTERMEDIATE,和Not All Endpoints Registered 。


[grid@dave-db2 admin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE dave-db1
ora....ER.lsnr ora....er.type ONLINE ONLINE dave-db1
ora....N1.lsnr ora....er.type ONLINE ONLINE dave-db1
ora.asm ora.asm.type ONLINE ONLINE dave-db1
ora.cvu ora.cvu.type ONLINE ONLINE dave-db1
ora....SM2.asm application ONLINE ONLINE dave-db1
ora....B1.lsnr application ONLINE ONLINE dave-db1
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application ONLINE ONLINE dave-db1
ora....db1.vip ora....t1.type ONLINE ONLINE dave-db1
ora....SM1.asm application ONLINE ONLINE dave-db2
ora....B2.lsnr application ONLINE ONLINE dave-db2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application ONLINE ONLINE dave-db2
ora....db2.vip ora....t1.type ONLINE ONLINE dave-db2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE dave-db1
ora.oc4j ora.oc4j.type ONLINE ONLINE dave-db1
ora.ons ora.ons.type ONLINE ONLINE dave-db1
ora.oradb.db ora....se.type ONLINE ONLINE dave-db2
ora....ry.acfs ora....fs.type ONLINE ONLINE dave-db1
ora.scan1.vip ora....ip.type ONLINE ONLINE dave-db1


Listener.ora 文件内容如下:


[grid@dave-db1 admin]$ more listener.ora
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent