4 Replies Latest reply on Sep 25, 2009 12:27 PM by Billy~Verreynne

    3 of 5 instances crashaed in RAC:ORA-00494: enqueue [CF] held for too long

    65484
      I have Oracle 11g 11.1.0.7 runnin on HP UX ..Not sure if its the known bug in 11g ...Plz help if somebody have encountered this error

      Thanks in Advance

      Alert log says

      ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 3, osid 26041'
      Incident details in: /ora00/app/oracle/diag/rdbms/ngprod/ngprod3/incident/incdir_124052/ngprod3_diag_26011_i124052.trc
      Thu Sep 24 22:50:47 2009
      Killing enqueue blocker (pid=26041) on resource CF-00000000-00000000
      by killing session 537.1
      Killing enqueue blocker (pid=26041) on resource CF-00000000-00000000
      by terminating the process
      ARC2 (ospid: 26346): terminating the instance due to error 2103
      Thu Sep 24 22:50:47 2009
      ORA-1092 : opiodr aborting process unknown ospid (23146_1)
      Thu Sep 24 22:50:47 2009
      ORA-1092 : opitsk aborting process
      Thu Sep 24 22:50:47 2009
      System state dump is made for local instance
      System State dumped to trace file /ora00/app/oracle/diag/rdbms/ngprod/ngprod3/trace/ngprod3_diag_26011.trc
      Thu Sep 24 22:50:48 2009
      ORA-1092 : opitsk aborting process
      Thu Sep 24 22:50:48 2009
      License high water mark = 47
      Instance terminated by ARC2, pid = 26346
      USER (ospid: 18214): terminating the instance
      Instance terminated by USER, pid = 18214
      Thu Sep 24 22:51:04 2009