有一段時間沒有用RAC的測試環境了,重新啟動後,發現報錯了
[oracle@oracle01 ~]$ crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon.
我記得itpub上有人處理過類似的問題,今天終於有機會實踐一把了
在/var/tmp/有一個.oracle目錄
將這個目錄中的東西清空
rm –rf *
然後在root用戶下啟動crs
crsctl start crs
等待一段時間發現還是沒有辦法帶動起來crs全部的services
[oracle@oracle01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE OFFLINE
ora....01.lsnr application ONLINE OFFLINE
ora....e01.gsd application ONLINE OFFLINE
ora....e01.ons application ONLINE OFFLINE
ora....e01.vip application ONLINE OFFLINE
ora....SM2.asm application ONLINE ONLINE croracle02
ora....02.lsnr application ONLINE ONLINE croracle02
ora....02.lsnr application ONLINE OFFLINE
ora....e02.gsd application ONLINE OFFLINE
ora....e02.ons application ONLINE ONLINE croracle02
ora....e02.vip application ONLINE ONLINE croracle02
ora....SM3.asm application ONLINE OFFLINE
ora....03.lsnr application ONLINE OFFLINE
ora....e03.gsd application ONLINE OFFLINE
ora....e03.ons application ONLINE OFFLINE
ora....e03.vip application ONLINE OFFLINE
ora....SM4.asm application ONLINE OFFLINE
ora....04.lsnr application ONLINE OFFLINE
ora....e04.gsd application ONLINE OFFLINE
ora....e04.ons application ONLINE OFFLINE
ora....e04.vip application ONLINE OFFLINE
ora....02.inst application ONLINE OFFLINE
ora....d1.inst application ONLINE OFFLINE
ora....d3.inst application ONLINE OFFLINE
ora....d4.inst application ONLINE OFFLINE
ora.crprod.db application ONLINE OFFLINE
看到之後oracle02 這個node的服務啟動了
沒有辦法重新啟動服務器(我的是vmware 呵呵)
reboot後正常
[oracle@oracle01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE croracle01
ora....01.lsnr application ONLINE ONLINE croracle01
ora....e01.gsd application ONLINE ONLINE croracle01
ora....e01.ons application ONLINE ONLINE croracle01
ora....e01.vip application ONLINE ONLINE croracle01
ora....SM2.asm application ONLINE ONLINE croracle02
ora....02.lsnr application ONLINE ONLINE croracle02
ora....02.lsnr application ONLINE OFFLINE
ora....e02.gsd application ONLINE ONLINE croracle02
ora....e02.ons application ONLINE ONLINE croracle02
ora....e02.vip application ONLINE ONLINE croracle02
ora....SM3.asm application ONLINE OFFLINE
ora....03.lsnr application ONLINE OFFLINE
ora....e03.gsd application ONLINE OFFLINE
ora....e03.ons application ONLINE OFFLINE
ora....e03.vip application ONLINE ONLINE croracle01
ora....SM4.asm application ONLINE OFFLINE
ora....04.lsnr application ONLINE OFFLINE
ora....e04.gsd application ONLINE OFFLINE
ora....e04.ons application ONLINE OFFLINE
ora....e04.vip application ONLINE ONLINE croracle02
ora....02.inst application ONLINE ONLINE croracle02
ora....d1.inst application ONLINE ONLINE croracle01
ora....d3.inst application ONLINE OFFLINE
ora....d4.inst application ONLINE OFFLINE
ora.crprod.db application ONLINE ONLINE croracle02
[oracle@croracle01 ~]$
[oracle@oracle01 ~]$ sqlplus / as sysdba;
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Feb 3 01:50:41 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select * from v$active_instances;
INST_NUMBER
-----------
INST_NAME
--------------------------------------------------------------------------------
1
croracle01.localdomain:crprod1
2
croracle02.localdomain:croracle02
SQL>
看來reboot對oracle也是好使的!
没有评论:
发表评论