ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/devdb/spfiledevdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/devdb/spfiledevdb.ora
ORA-12547: TNS:lost contact


解决办法：
环境：


DB:11.2.0.3 RAC  OS:OracleEnterpriseLinux6



今天在做Oracle 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.