这篇博客讲述了在一个Oracle RAC环境中，由于使用root用户进行操作导致节点宕机的问题。错误日志显示为ORA-15025和ORA-27041，表现为数据库无法访问ASM磁盘，错误信息显示权限被拒绝。通过分析ASM实例和系统日志，排除了ASM磁盘权限问题。最终发现是由于root用户尝试对数据库进行操作，由于权限限制引发的错误。建议在操作Oracle数据库时使用专门的数据库用户而非root用户。
天萃荷净
运维DBA反映Oracle RAC环境中节点宕机，alert发现报错ORA-15025 ORA-27041，分析原因为使用root用户操作rac导致节点宕机
接到同事请求,说客户的linux redhat 5.8平台部署的11.2.0.3 RAC 节点2挂掉了,报磁盘IO异常,数据库hang住
Fri Jun 14 12:01:22 2013
Thread 2 advanced to log sequence 369 (LGWR switch)
Current log# 49 seq# 369 mem# 0: +DATA/q9db/onlinelog/group_49.861.817830099
Fri Jun 14 12:01:22 2013
Archived Log entry 89300 added for thread 2 sequence 368 ID 0x35324053 dest 1:
Fri Jun 14 14:26:18 2013
Errors in file /u01/app/oracle/diag/rdbms/q9db/q9db2/trace/q9db2_ora_11788.trc:
ORA-15025: could not open disk "/dev/mapper/q9datalun2"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/q9db/q9db2/trace/q9db2_ora_11788.trc:
ORA-15025: could not open disk "/dev/mapper/q9datalun2"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
WARNING: failed to read mirror side 1 of virtual extent 441 logical extent 0 of file 625
in group [2.3857217523] from disk DATA_0001
allocation unit 377890 reason error; if possible, will try another mirror side
Fri Jun 14 14:31:17 2013
Errors in file /u01/app/oracle/diag/rdbms/q9db/q9db2/trace/q9db2_ora_13767.trc:
ORA-15025: could not open disk "/dev/mapper/q9datalun2"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/q9db/q9db2/trace/q9db2_ora_13767.trc:
ORA-15025: could not open disk "/dev/mapper/q9datalun2"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permi
最低0.47元/天 解锁文章
扫一扫
2876
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
