这篇博客讲述了Oracle RAC环境中遇到的问题，即无法对部分表格进行读写操作，错误信息包括ORA-15080、ORA-15025和ORA-27041。排查过程中，发现是由于/dev/asmdisk/mesdbdata1和/dev/asmdisk/mesdbdata2的权限问题导致，原本应属于grid用户和asmadmin组，但被改为bin用户和sys组。解决办法是将权限恢复为grid用户和asmadmin组，设置为660权限，从而使数据库服务恢复正常。
有一套Oracle RAC，突然反映说不能对部分表格进行读写操作了，但是数据库正常，大部分数据读写也正常，先将服务切至另一台Server使Oracle对外正常服务，然后开始troubleshooting。
HP-UX系统层面没有问题，存储3par没有预警，确认链路正常，以上步骤是为了确认不是个别共享存储出问题导致的数据无法访问。然后查看trace log进行分析(/oracle/app/diag/rdbms/mesdb/mesdb2/trace/alter_mesdb2.log)，发现以下报错且不断循环：
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 713 logical extent 0 of file 532 in group 9 on disk 0 allocation unit 595268
Fri Apr 11 12:13:00 2014
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata2"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata2"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 66 logical extent 0 of file 310 in group 9 on disk 1 allocation unit 171803
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata2"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata2"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 66 logical extent 0 of file 310 in group 9 on disk 1 allocation unit 171803
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata1"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata1"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata1"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata1"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata1"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata1"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors in file /oracle/app/diag/rdbms/mesdb/mesdb2/trace/mesdb2_ora_10102.trc:
ORA-15025: could not open disk "/dev/asmdisk/mesdbdata1"
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3
Errors i
最低0.47元/天 解锁文章
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
