ORA-01565: error in identifying file '+DATA/rac/dataile/datfile/system'

環境：RHEL 5.1  32位 ，ORACLE 11.2.01
在安裝11G RAC建庫的時候DBCA出現
 ORA-1503 CREATE CONTROLFILE FAILED
 ORA-01565 error in identifying file '+DATA/rac/dataile/datfile/system'

解決辦法：
 1、首先檢查ASM例項起來沒有    
status asm -n rac1
ASM is running on rac1
status asm -n rac2
ASM is running on rac2
補充案例：

案例1：陣列壞了塊硬碟導至ora-01078 ora-01565 ora-17503 ora-15077一例解決
連結： http://www.aixchina.net/home/space.php?uid=20260&do=blog&id=24793
步驟：先看在ASMCMD檢視磁碟狀態（lsdsk）,然後重啟ASM例項

案例2：因為磁碟DISMOUNTED，出現了問題，導致這樣的錯誤 ORA-01078;ORA-01565;ORA-17503;ORA-15077
SQL> startup;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
……
export ORACLE_SID=+ASM1
sqlplus / as sysdba
SQL>shutdown immediate;
……
SQL>startup;
SQL>select name,state from v$asm_diskgroup;
NAME                             STATE
—————————— ———–
RECOVERYDEST          MOUNTED
DG1                            DISMOUNTED
SQL>alter diskgroup DG1 mount;

 2、檢查許可權問題
 節點1：
  -l /oracle/app/oracle/product/11.2.0/db_1/bin/oracle
-r-sr-s--x 1 oracle asmadmin 173515925 Dec 24 03:15 /oracle/app/oracle/product/11.2.0/db_1/bin/oracle
6751 /oracle/app/oracle/product/11.2.0/db_1/bin/oracle
-l /oracle/app/oracle/product/11.2.0/db_1/bin/oracle
-rwsr-x--x 1 oracle asmadmin 173515925 Dec 24 03:15 /oracle/app/oracle/product/11.2.0/db_1/bin/oracle
 節點2：
 [oracle@rac2 ~]# ls -l /oracle/app/oracle/product/11.2.0/db_1/bin/oracle    
-rwsr-s--x 1 oracle oinstall 173515925 Dec 24 03:31 /oracle/app/oracle/product/11.2.0/db_1/bin/oracle  ---問題所在
[root@rac2 ~]# su - grid
-l /oracle/app/crs_home/bin/oracle
-rwsr-s--x 1 grid oinstall 152462748 Dec 24 01:20 /oracle/app/crs_home/bin/oracle
 修改許可權：
  o=/oracle/app/oracle/product/11.2.0/db_1/bin/oracle
-l /oracle/app/oracle/product/11.2.0/db_1/bin/oracle
-r-sr-s--x 1 oracle asmadmin 173515925 Dec 24 03:31 /oracle/app/oracle/product/11.2.0/db_1/bin/oracle

 到此解決。

 

其他摘要：
網上也有類似的錯誤，但出現在升級到RAC的時候
連結：http://luoping.blog.51cto.com/534596/1019993
ORA-01565: error in identifying file '+DATA/spfilerac.ora'
環境：DB:11.2.0.2 RAC  OS:RHEL 5.6
今天在做11GR2下面單機升級到RAC時遇到下面的問題
[oracle@11rac5 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 9 19:06:51 2012
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/spfilerac.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/spfilerac.ora
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 3833863
Additional information: 10
檢視grid與oracle使用者下面的oracle檔案的許可權

檢視grid使用者下面的oracle的許可權
[root@11rac5 log]# su - grid
[grid@11rac5 ~]$ ls -l $ORACLE_HOME/bin/oracle
-rwxr-x--x 1 grid oinstall 200678430 Oct  9 13:35 /u01/app/11.2.0/grid/bin/oracle
許可權不正確，修改。
[grid@11rac5 ~]$ chmod 6751 $ORACLE_HOME/bin/oracle
[grid@11rac5 ~]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 200678430 Oct  9 13:35 /u01/app/11.2.0/grid/bin/oracle
檢視oracle使用者下面的oracle許可權
[oracle@11rac5 trace]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-x--x 1 oracle asmadmin 228886426 Oct  9 15:29 /u01/app/oracle/product/11.2.0/db_2/bin/oracle
在grid使用者下面修改
[oracle@11rac5 trace]$ su - grid
Password: 
[grid@11rac5 ~]$ cd $ORACLE_HOME/bin/
[grid@11rac5 bin]$ set
set            setasmgid      setasmgidwrap  setfattr       setkeycodes    setmetamode    setsid         setup          
setarch        setasmgid0     setfacl        setfont        setleds        setserial      setterm        setxkbmap      
[grid@11rac5 bin]$ setasmgidwrap o=/u01/app/oracle/product/11.2.0/db_2/bin/oracle
[grid@11rac5 bin]$ ls -l /u01/app/oracle/product/11.2.0/db_2/bin/oracle
-rwsr-s--x 1 oracle asmadmin 228886426 Oct  9 15:29 /u01/app/oracle/product/11.2.0/db_2/bin/oracle
再次啟動資料庫：

再次啟動正常
[oracle@11rac5 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 9 19:28:34 2012
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area  839282688 bytes
Fixed Size                  2231128 bytes
Variable Size             557843624 bytes
Database Buffers          276824064 bytes
Redo Buffers                2383872 bytes
Database mounted.
Database opened.