ORA-01565

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. 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29330852/viewspace-2120305/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29330852/viewspace-2120305/