Greetings to Every One.
Below Issue occured in our environment can you please suggest me with the solutions.
Error Msg from OEM "Operational error () detected in /u01/app/oracle/diag/rdbms/mda/mda1/alert/log.xml at time/line number: Sun Jun 16 07:10:33 2013/134170" (It is Critical alert in OEM).
From log:-
********************************************************************************************
<msg time='2013-06-16T06:10:23.729+05:30' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='uidl1-rac-a16-001' host_addr='10.3.96.247' module=''
pid='29034'>
<txt>Archived Log entry 92652 added for thread 1 sequence 25469 ID 0x3e91ce8c dest 1:
</txt>
</msg>
<msg time='2013-06-16T07:10:33.538+05:30' org_id='oracle' comp_id='rdbms'
msg_id='kesaiKillProcess:2503:3170456095' client_id='' type='ERROR'
group='SQL_Tune' level='2' host_id='uidl1-rac-a16-001'
host_addr='10.3.96.247' module='' pid='28958'>
<txt>Process 0x0x21a59b168 appears to be hung in Auto SQL Tuning task
</txt>
</msg>
<msg time='2013-06-16T07:10:33.538+05:30' org_id='oracle' comp_id='rdbms'
msg_id='kesaiKillProcess:2507:1670650406' client_id='' type='ERROR'
group='SQL_Tune' level='2' host_id='uidl1-rac-a16-001'
host_addr='10.3.96.247' module='' pid='28958'>
<txt>Current time = 1371346833, process death time = 1371346802
</txt>
</msg>
<msg time='2013-06-16T07:10:33.538+05:30' org_id='oracle' comp_id='rdbms'
msg_id='kesaiKillProcess:2518:2480300341' client_id='' type='ERROR'
group='SQL_Tune' level='2' host_id='uidl1-rac-a16-001'
host_addr='10.3.96.247' module='' pid='28958'>
<txt>Attempting to kill process 0x0x21a59b168 with OS pid = 32246
</txt>
</msg>
<msg time='2013-06-16T07:10:33.538+05:30' org_id='oracle' comp_id='rdbms'
msg_id='kesaiKillProcess:2532:234340873' client_id='' type='ERROR'
group='SQL_Tune' level='2' host_id='uidl1-rac-a16-001'
host_addr='10.3.96.247' module='' pid='28958'>
<txt>OSD kill succeeded for process 0x21a59b168
</txt>
</msg>
<msg time='2013-06-16T07:25:47.172+05:30' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='uidl1-rac-a16-001' host_addr='10.3.96.247' module=''
pid='28946'>
<txt>Thread 1 advanced to log sequence 25471 (LGWR switch)
</txt>
</msg>
<msg time='2013-06-16T07:25:47.172+05:30' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='uidl1-rac-a16-001' host_addr='10.3.96.247' module=''
pid='28946'>
<txt> Current log# 5 seq# 25471 mem# 0: +REDO_1/mda/onlinelog/group_5.260.763898025
</txt>
</msg>
*********************************************************************************************************************
One more log found from alert log i.e :-
Mon Jun 17 00:33:32 2013
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Mon Jun 17 01:03:35 2013
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Mon Jun 17 01:18:36 2013
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Tue Jun 18 02:05:40 2013
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Thanks & Regards
Prasanth