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

最新推荐文章于 2023-11-21 14:37:30 发布

转载最新推荐文章于 2023-11-21 14:37:30 发布 · 953 阅读

在尝试将Oracle 11g R2从单机升级到RAC的过程中，遇到了ORA-01078等错误。经过排查发现是由于grid用户的oracle可执行文件权限设置不当导致的问题。

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/，如需转载，请注明出处，否则将追究法律责任。

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