oracle 10g change crs status unknown to offline
oracle 10g change crs status unknown to offline
在oracle 10g crs资源状态中,因为出现异常,导致部分资源状态出现unknown状态
[oracle@p650:/oracle/app/oracle]$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....20.lsnr application ONLINE UNKNOWN p520
ora.p520.gsd application ONLINE ONLINE p520
ora.p520.ons application ONLINE ONLINE p520
ora.p520.vip application ONLINE ONLINE p520
ora....50.lsnr application ONLINE UNKNOWN p650
ora.p650.gsd application ONLINE ONLINE p650
ora.p650.ons application ONLINE ONLINE p650
ora.p650.vip application ONLINE ONLINE p650
如上所示:实例和监听的状态都为UNKNOWN,那如何变成offline
用以下命令即可
[font=新宋体]E.g.
% cd $ORA_CRS_HOME/bin
% ./crs_stop -f ora.node4.ASM4.asm
This will ensure the state of the resource changes from UNKNOWN status to OFFLINE status.
[font=新宋体]crs_stop -f ora.listener_p650.lsnr
[font=新宋体]crs_stop -f ora.listener_p520.lsnr
ora....20.lsnr application ONLINE OFFLINE
ora.p520.gsd application ONLINE ONLINE p520
ora.p520.ons application ONLINE ONLINE p520
ora.p520.vip application ONLINE ONLINE p520
ora....50.lsnr application ONLINE OFFLINE
ora.p650.gsd application ONLINE ONLINE p650
ora.p650.ons application ONLINE ONLINE p650
ora.p650.vip application ONLINE ONLINE p650
修改成功