首页 » ORACLE » ORA-01078: failure in processing system parameters when srvctl start instance

ORA-01078: failure in processing system parameters when srvctl start instance

环境11gr2 RAC +linux
昨天把ocr_home目录改了权限
chown -R grid.oinstall 11.2.0
今天发现启动数据库实例无法启动,但asm实例正常,而且diskgroup 也都是mounted状态

[grid@znode1 ~]$ srvctl start instance -d rac -i rac1
PRCR-1013 : Failed to start resource ora.rac.db
PRCR-1064 : Failed to start resource ora.rac.db on node znode1
CRS-5017: The resource action "ora.rac.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DBDG/rac/spfilerac.ora'
ORA-17503: ksfdopn:2 Failed to open file +DBDG/rac/spfilerac.ora
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/znode1/agent/crsd/oraagent_oracle//oraagent_oracle.log".

CRS-2674: Start of 'ora.rac.db' on 'znode1' failed

查了一下MOS 1322959.1有记载是oracle执行文件权限问题
[grid@znode1 bin]$ pwd
/u01/app/11.2.0/grid/bin
[grid@znode1 bin]$ ll oracle
-rwxr-x–x 1 grid oinstall 169802036 Jul 6 12:06 oracle

[grid@znode1 bin]$ chmod 6755 oracle

[grid@znode1 bin]$ ll oracle
-rwsr-sr-x 1 grid oinstall 169802036 Jul 6 12:06 oracle

[grid@znode1 bin]$ srvctl start instance -d rac -i rac1

[grid@znode1 bin]$ srvctl status instance -d rac -i rac1
Instance rac1 is running on node znode1

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.

打赏

,

对不起,这篇文章暂时关闭评论。