ITPUX技术网

交流 . 资讯 . 分享
Make progress together!
Oracle数据库DBA高级工程师培训视频
Oracle数据库培训-备份恢复-性能优化-集群容灾
mysql数据库视频教程

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

内容发布:paulyi| 发布时间:2014-2-23 15:21:01
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


上一篇:oracle 10g impdp与imp参数选项的区别
下一篇:linux操作系统下切换到oracle用户报权限不够问题解决方法
回复

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表