ORA-01565: error in identifying file '+DATA/devdb/spfiledevdb.ora'
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.
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01565: error in identifying file '+DATA/rac/dataile/datfile/system'ErrorIDEAI
- ORA-00205: error in identifying control file, check alert log for more infoErrorIDE
- ORA-00205 error in identifying control file 問題解決一例ErrorIDE
- 建立控制檔案副本出現錯誤ORA-00205: error in identifying control fileErrorIDE
- ORA-00205 error in identifying controlfileErrorIDE
- mysql錯誤: [ERROR] InnoDB: auto-extending data file /data/ibdata1 is of a different size 768 pages...MySqlError
- Error 15: File not found for RedhatErrorRedhat
- HP -Data Protector Restore file systemREST
- ERROR! The server quit without updating PID file (/opt/mysql/mysql/data/cvs.pid)ErrorServerUIMySql
- HPUX Error 23 File table overflowUXError
- sqlldr Field in data file exceeds maximum lengthSQL
- data file int write和db file sequential read個人想法
- Solaris syntax error: unexpected end of fileError
- Unload data to a flat file from Oracle databaseOracleDatabase
- 452 Error writing file: A file cannot be larger than the value set by ulimit.ErrorMIT
- fatal error: openssl/sha.h: No such file or directoryError
- fatal error: sys/cdefs.h: No such file or directoryError
- ELF file data encoding not little-endianEncoding
- HP -Data Protector Restore file system【Blog 搬家】REST
- [轉載]Oracle等待事件Data file init writeOracle事件
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- fatal error: libmemcached/memcached.h: No such file or directoryErrorIBM
- ScalaSigParserError: Unexpected error: Not a valid class fileError
- line 10:syntax error: unexpected end of fileError
- R安裝package報ERROR: a 'NAMESPACE' file is requiredPackageErrornamespaceUI
- linux:ora-27054:nfs file system errorLinuxNFSError
- oracle10g 資料檔案頭data file header(file header)OracleHeader
- GoldenGate replication using a data definition file and DEFGEN utilityGo
- load data infile ERROR 1045 (28000)Error
- "Fatal error: Call to undefined function: file_put_contents()"ErrorUndefinedFunction
- Oracle Database on NFS : unable to lock file - already in use" ErrorOracleDatabaseNFSError
- /usr/bin/xauth: error in locking authority file錯誤Error
- ERROR: Check /etc/pam.conf file permissions and ownershipError
- O/S-Error: (OS 33) The process cannot access the fileError
- 配置NDK syntax error: unexpected end of file 解決Error
- 10.2.0.2 RAC DB ">>> ERROR IN KQLMBIVG SEE LCK TRACE FILEError
- TNS-04414 file error 錯誤解決Error
- The innodb_system data file 'ibdata1' must be writable