oracle crs监听状态为offline处理过程

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:28

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

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】