环境:
DB:11.2.0.2 RAC OS:RHEL 5.6
今天在做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.