oracle crs监听状态为offline处理过程
oracle crs监听状态为offline处理过程
今天帮客户去巡查一个数据库时,用crs_stat 查看状态,发现web2节点监听状态为offline
% crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....S1.lsnr application ONLINE ONLINE web1
ora....is1.gsd application ONLINE ONLINE web1
ora....is1.ons application ONLINE ONLINE web1
ora....is1.vip application ONLINE ONLINE web1
ora....S2.lsnr application ONLINE OFFLINE
ora....is2.gsd application ONLINE ONLINE web2
ora....is2.ons application ONLINE ONLINE web2
ora....is2.vip application ONLINE ONLINE web2
ora.o2000.db application ONLINE ONLINE web1
ora....01.inst application ONLINE ONLINE web1
ora....02.inst application ONLINE ONLINE web2
通过用以下命令去启动,启动失败,hang在那里
srvctl start listener web2
sqlplus 连接也是挂起
% sqlplus system/abcdefg@2000
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 4 15:39:45 2010
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Suspended
查找监听进程,进程存在
% ps -ef|grep tns
oracle 266256 1 0 Jul 16 - 7:37 /oracle/10.2/db_1/bin/tnslsnr LISTENER_WEB2 -inherit
oracle 512324 409744 0 15:28:53 pts/2 0:00 grep tns
看来监听进程是挂死了,外面连接也无法进入,采取的解决方法 kill掉监听进程
kill 266256
再启动监听进程 成功
crs监听状态 正常
% crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....S1.lsnr application ONLINE ONLINE web1
ora....is1.gsd application ONLINE ONLINE web1
ora....is1.ons application ONLINE ONLINE web1
ora....is1.vip application ONLINE ONLINE web1
ora....S2.lsnr application ONLINE ONLINE web2
ora....is2.gsd application ONLINE ONLINE web2
ora....is2.ons application ONLINE ONLINE web2
ora....is2.vip application ONLINE ONLINE web2
ora.o2000.db application ONLINE ONLINE web1
ora....01.inst application ONLINE ONLINE web1
ora....02.inst application ONLINE ONLINE web2