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 application ONLINE OFFLINE
ora.serp.db application ONLINE ONLINE myrac02
ora....p1.inst application ONLINE ONLINE myrac01
ora....p2.inst application ONLINE OFFLINE
检查有问题节点的alert日志
ORA-29702 RAC一个节点资源offline/unknown
最新推荐文章于 2023-04-04 15:07:14 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)