1. 首页 > ITPUX技术网 > 正文

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

本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html

联系我们

在线咨询:点击这里给我发消息

微信号:itpux-com

工作日:9:30-18:30,节假日休息