I just set up 10.2.0.4RAC.
I just set up 10.2.0.4RAC today. I cannot get up after I shut down and restart it. I'm glad to start filling in the problem:
[oracle@rac2 ~]$ crs_stat -t -vName Type R/RA F/FT Target State Host ----------------------------------------------------------------------ora.orcl.db application 0/0 0/1 ONLINE ONLINE rac2 ora.orcl.db.cs application 0/0 0/1 ONLINE ONLINE rac2 ora....cl1.srv application 0/0 0/0 ONLINE OFFLINE ora....cl2.srv application 0/0 0/0 ONLINE ONLINE rac2 ora....l1.inst application 0/5 0/0 ONLINE OFFLINE ora....l2.inst application 0/5 0/0 ONLINE ONLINE rac2 ora....SM1.asm application 0/5 0/0 ONLINE OFFLINE ora....C1.lsnr application 0/5 0/0 ONLINE OFFLINE ora.rac1.gsd application 0/5 0/0 ONLINE OFFLINE ora.rac1.ons application 0/3 0/0 ONLINE OFFLINE ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac2 ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2 ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2 ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2
First, start up in rac1.
[oracle@rac1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Mon Dec 21 16:40:06 2015Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to an idle instance.SQL> startupORA-01078: failure in processing system parametersORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.oraORA-15077: could not locate ASM instance serving a required diskgroupORA-29701: unable to connect to Cluster Manager
The storage is suspended.
[oracle@rac1 ~]$ cd /dev/raw[oracle@rac1 raw]$ lltotal 0crw-r----- 1 root oinstall 162, 1 Dec 21 15:43 raw1crw-r----- 1 root oinstall 162, 2 Dec 21 15:43 raw2crw-r----- 1 root oinstall 162, 3 Dec 21 15:43 raw3crw------- 1 root root 162, 4 Dec 21 15:43 raw4crw------- 1 root root 162, 5 Dec 21 15:43 raw5crw------- 1 root root 162, 6 Dec 21 15:43 raw6crw------- 1 root root 162, 7 Dec 21 15:43 raw7
This type of permission makes rac1 very easy !!!
View logs
more /u01/crs/oracle/product/10/app/log/rac1/cssd/ocssd.log[ CSSD]2015-12-21 02:07:38.367 [4291541888] >TRACE: clssnmDiskStateChange: state from 1 to 2 disk (0//dev/raw/raw3)[ CSSD]2015-12-21 02:07:38.367 [1136974144] >TRACE: clssnmvDPT: spawned for disk 0 (/dev/raw/raw3)[ CSSD]2015-12-21 02:07:38.367 [1136974144] >ERROR: Internal Error Information: Category: 1234 Operation: scls_block_open Location: open Other: open failed /dev/raw/raw3 Dep: 13
Set permissions and restart.