数据库日志大量错误如下:
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
解决方法:
ASM Database Instance Is Reporting: “[WARNING: ASM communication error: op 0 state 0x0 (15055)]” (文档 ID 1665311.1)
SOLUTION
1) Please add the patrolag OS user in the "asmdba" OS group on all the nodes.
+ASM1@bdwswu1:/optware/oracle/11.2.0.2/grid/bin> grep asmdba /etc/group
asmdba:!:1300:grid,oracle, patrolag <(==============
asmdba:!:1300:grid,oracle, patrolag <(==============
2) Once customer you add the "patrolag" OS user into the " asmdba" OS group the alerts/warnings will stop:
Wed Apr 09 14:45:26 2014
Thread 1 advanced to log sequence 12690 (LGWR switch)
Current log# 2 seq# 12690 mem# 0: +DATA/mstru/redo02.log
Wed Apr 09 14:45:26 2014
Archived Log entry 20828 added for thread 1 sequence 12689 ID 0x4cae0d0f dest 1
Thread 1 advanced to log sequence 12690 (LGWR switch)
Current log# 2 seq# 12690 mem# 0: +DATA/mstru/redo02.log
Wed Apr 09 14:45:26 2014
Archived Log entry 20828 added for thread 1 sequence 12689 ID 0x4cae0d0f dest 1