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

张维照 2019-05-31
54
0 0
摘要:把ocr_home目录改了权限,chown -R grid.oinstall 11.2.0,今天发现启动数据库实例无法启动,但asm实例正常,而且diskgroup 也都是mounted状态

问题描述

环境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.

「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
Oracle
订阅
欢迎订阅Oracle频道,订阅之后可以获取最新资讯和更新通知。
墨值排行
今日本周综合
近期活动
全部
相关课程
全部