Oracle11g RAC DBCA创建数据库时候报错

一、现象

PRCR-1079 : Failed to start resource ora.mydb.db
CRS-5017: The resource action "ora.mydb.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/mydb/spfilenar.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/mydb/spfilenar.ora
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13 Permission denied
Additional information: 26
Additional information: 9
 For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0

二、原因

在安装oracle soft之后：
$ORACLE_HOME/bin/oracle文件属性权限为oracle:oninstall 751(-rwxr-x--x)
在用安装ASM建库(DBCA)时：
此文件属性会自动被修改为oracle:asmadmin 6751(-rwsr-s--x)
在升级之后：
此文件属性又被自动被修改为oracle:oinstall 751(-rwxr-x--x)

Solution:
chown oracle:asmadmin $ORACLE_HOME/bin/oracle
chmod 6751 $ORACLE_HOME/bin/oracle

三、解决办法

[root@racnode02 ~]# su - oracle
Last login: Wed Jan  5 20:55:31 CST 2022 on pts/0
[oracle@racnode02 ~]$ cd $ORACLE_HOME/bin
[oracle@racnode02 bin]$ ls -ld oracle
-rwsr-s--x 1 oracle asmadmin 239501488 Jan  5 15:43 oracle

[oracle@racnode02 bin]$ su - grid
Password:
Last login: Wed Jan  5 20:58:10 CST 2022 on pts/1

[grid@racnode02 ~]$ cd $ORACLE_HOME/bin
[grid@racnode02 bin]$ ls -ld oracle
-rwxrwxr-x 1 grid oinstall 209840344 Jan  5 12:07 oracle

[grid@racnode02 bin]$  chmod 6751 oracle
[grid@racnode02 bin]$ ls -ld oracle
-rwsr-s--x. 1 grid oinstall 209840344 Jan  5 12:07 oracle

[root@racnode01 ~]# su - oracle
Last login: Wed Jan  5 20:55:07 CST 2022 on pts/0
[oracle@racnode01 ~]$ cd $ORACLE_HOME/bin/
[oracle@racnode01 bin]$ ls -ld oracle
-rwsr-s--x 1 oracle asmadmin 239501488 Jan  5 15:40 oracle

[oracle@racnode01 bin]$ su - grid
Password:
Last login: Wed Jan  5 20:09:43 CST 2022 on pts/0
[grid@racnode01 ~]$ cd $ORACLE_HOME/bin
[grid@racnode01 bin]$ ls -ld oracle
-rwsrwsr-x 1 grid oinstall 209840344 Jan  5 12:05 oracle

[grid@racnode01 bin]$  chmod 6751  oracle
[grid@racnode01 bin]$ ls -ld oracle
-rwsr-s--x. 1 grid oinstall 209840344 Jan  5 12:05 oracle

正确的权限:
[grid@server01 bin]$ ls -ld oracle
-rwsr-s--x. 1 grid oinstall 209836184 Sep 29 11:38 oracle