SQL> select * from v$version where rownum<2;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
主机异常关机,集群状态异常
[root@myrac02 oracle]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE myrac01
ora....01.lsnr application ONLINE ONLINE myrac01
ora....c01.gsd application ONLINE ONLINE myrac01
ora....c01.ons application ONLINE ONLINE myrac01
ora....c01.vip application ONLINE ONLINE myrac01
ora....SM2.asm application ONLINE OFFLINE
ora....02.lsnr application ONLINE OFFLINE
ora....c02.gsd application ONLINE ONLINE myrac02
ora....c02.ons application ONLINE ONLINE myrac02
ora....c02.vip app