ORA-01565: error in identifying file '+DATA/devdb/spfiledevdb.ora'

jude_king發表於2016-06-16
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-2120303/,如需轉載,請註明出處,否則將追究法律責任。

相關文章