第二节点启库时报错
- SQL> startup
- ORA-01078: failure in processing system parameters
- ORA-01565: error in identifying file \'+DATA/RACDB/spfileRACDB.ora\'
- ORA-17503: ksfdopn:2 Failed to open file +DATA/RACDB/spfileRACDB.ora
- ORA-12547: TNS:lost contact
【MOS 1322959.1】
Cause：
For Case I, the issue is caused wrong group (dba) is chosen for “ASM Database Administrator”,”ASM Instance Administration Operator” and “ASM Instance Administrator”
group during installing grid infrastructure, while the ASM disks are owned by oinstall group.
The missing setuid and setgid bit causing oracle user access failure to ASM diskgroup even though the ASMADMIN group is set correctly.
检查
==第一节点==
[root@rac1 ~]# cd /u01/app/11.2.0/grid/bin
[root@rac1 bin]# ll oracle
-rwsr-s--x. 1 grid oinstall 169801518 Oct 27 10:04 oracle
==第二节点==
[root@rac2 bin]# ll oracle
-rwxr-x--x. 1 grid oinstall 169801518 Oct 27 10:08 oracle
修复 ：第二节点执行 chmod 6755 oracle
-rwsr-sr-x. 1 grid oinstall 169801518 Oct 27 10:08 oracle
再次startup时，又报错，详见
ORA-01078 bORA-01565 ORA-17503 ORA-01031
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29437301/viewspace-1348495/ ，如需转载，请注明出处，否则将追究法律责任。
