4 Replies Latest reply: Jul 11, 2013 2:18 AM by PrasanthkumarReddy.M RSS

    Generic Operational Error--Oracle11gr2

    PrasanthkumarReddy.M

      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

        • 1. Re: Generic Operational Error--Oracle11gr2
          PrasanthkumarReddy.M

          Hi All,

           

          Can you please let me know what is this issue..and how to resolve this?

           

           

          Thanks & Regards

          Prasanth

          • 2. Re: Generic Operational Error--Oracle11gr2
            Ed Rudans

            First one is telling you that some session been killed. You need to check other traces to see more info on what exactly been killed. If everything working fine, then the process wast critical, and the message can be ignore, however further investigation is required why this happened

            Second, may be caused by incorrect permissions and groups assigned, check

             

            WARNING: ASM Communication Error: Op 0 State 0x0 (15055), ERROR: Direct Connection Failure With ASM. ORA-1031 reported additionally [ID 1519413.1]

            Regards

            Ed

            • 3. Re: Generic Operational Error--Oracle11gr2
              PrasanthkumarReddy.M

              Hi EdRudans,

               

              Again came with same issue on 2nd jully 2013 with the below error on OEM.and it is in critical status bit worried actually can you please let me know whether we need to take any action on this or we can ignore?

               

              ERROR:-Operational error () detected in /u01/app/oracle/diag/rdbms/mda/mda1/alert/log.xml at time/line number: Tue Jul 2 23:10:14 2013/199895.

               

              Error from log.xml :-

              =============

               

              ==================================================================

              <msg time='2013-07-02T23:10:14.734+05:30' org_id='oracle' comp_id='rdbms'

              msg_id='kesaiKillProcess:2503:3170456095' client_id='' type='ERROR'

              group='SQL_Tune' level='2' host_id='*****-rac-a16-001'

              host_addr='10.3.96.247' module='' pid='28958'>

              <txt>Process 0x0x21f618988 appears to be hung in Auto SQL Tuning task

              </txt>

              </msg>

              <msg time='2013-07-02T23:10:14.734+05:30' org_id='oracle' comp_id='rdbms'

              msg_id='kesaiKillProcess:2507:1670650406' client_id='' type='ERROR'

              group='SQL_Tune' level='2' host_id='*****-rac-a16-001'

              host_addr='10.3.96.247' module='' pid='28958'>

              <txt>Current time = 1372786813, process death time = 1372786804

              </txt>

              </msg>

              <msg time='2013-07-02T23:10:14.734+05:30' org_id='oracle' comp_id='rdbms'

              msg_id='kesaiKillProcess:2518:2480300341' client_id='' type='ERROR'

              group='SQL_Tune' level='2' host_id='*****-rac-a16-001'

              host_addr='10.3.96.247' module='' pid='28958'>

              <txt>Attempting to kill process 0x0x21f618988 with OS pid = 2346

              </txt>

              </msg>

              <msg time='2013-07-02T23:10:14.735+05:30' org_id='oracle' comp_id='rdbms'

              msg_id='kesaiKillProcess:2532:234340873' client_id='' type='ERROR'

              group='SQL_Tune' level='2' host_id='*****-rac-a16-001'

              host_addr='10.3.96.247' module='' pid='28958'>

              <txt>OSD kill succeeded for process 0x21f618988

              </txt>

              </msg>

              =====================================================================================

               

               

              Thanks & Regards

              Prasanth

              • 4. Re: Generic Operational Error--Oracle11gr2
                PrasanthkumarReddy.M

                Hi All,

                 

                Can any one let me know what extactly i can do follow up on this..!

                 

                Thanks