问题描述
环境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.
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
相关阅读
【纯干货】Oracle 19C RU 19.27 发布,如何快速升级和安装?
Lucifer三思而后行
671次阅读
2025-04-18 14:18:38
Oracle RAC 一键安装翻车?手把手教你如何排错!
Lucifer三思而后行
630次阅读
2025-04-15 17:24:06
Oracle数据库一键巡检并生成HTML结果,免费脚本速来下载!
陈举超
539次阅读
2025-04-20 10:07:02
【活动】分享你的压箱底干货文档,三篇解锁进阶奖励!
墨天轮编辑部
488次阅读
2025-04-17 17:02:24
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
482次阅读
2025-04-22 00:20:37
一页概览:Oracle GoldenGate
甲骨文云技术
464次阅读
2025-04-30 12:17:56
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
459次阅读
2025-04-22 00:13:51
火焰图--分析复杂SQL执行计划的利器
听见风的声音
412次阅读
2025-04-17 09:30:30
3月“墨力原创作者计划”获奖名单公布
墨天轮编辑部
371次阅读
2025-04-15 14:48:05
OR+DBLINK的关联SQL优化思路
布衣
350次阅读
2025-05-05 19:28:36
TA的专栏
Java中间件
收录0篇内容
热门文章
一次Connection reset by peer的问题排查
2021-12-07 34197浏览
Java8-Stream: no instance(s) of type variable(s) R exist so that void conforms to R
2021-02-19 32435浏览
nginx: [emerg] "user" directive is not allowed here in /etc/nginx/conf.d/nginx.conf:1
2022-02-15 24325浏览
ORA-00904: "POLTYP": invalid identifier
2019-06-19 12944浏览
PageHelper排坑,处理排序失败: net.sf.jsqlparser.JSQLParserException
2022-05-19 12839浏览