1 Reply Latest reply: Oct 29, 2012 8:41 AM by Iulian J. Dragan RSS

    Problem after upgrade to 11.2.0.1

    475856
      Hi

      After upgrade my RAC from 11.1.0.7 (SE) to 11.2.0.1(SE) i have a lot of problems... :)
      environment
      2x
      Microsoft Windows Server 2003 R2 Server 5.2 Service Pack 2
      ProLiant BL460c G1 AMD64
      Oracle RAC Standard Edition (11.2.0.1.0) Patch 7: 10155838

      In application i get ORA-08177: can't serialize access for this transaction (forms 6i)
      No change was made in application only upgrade database, befor upgrade everythinks work fine.


      Second problem is my job.
      Job runs procedure that in loop do AUTONOMOUS_TRANSACTION;
      When i execute procedure from SQL Plus everything works fine, but when i try to execute it from job i get "Global Enqueue Services Deadlock detected. More info in file......"

      Trace file c:\oracle\diag\rdbms\kalobr\kalobr2\trace\kalobr2_j002_5240.trc
      Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
      With the Real Application Clusters and Automatic Storage Management options
      Windows NT Version V5.2 Service Pack 2
      CPU : 8 - type 8664, 2 Physical Cores
      Process Affinity : 0x0x0000000000000000
      Memory (Avail/Total): Ph:3372M/12285M, Ph+PgF:4015M/13808M
      Instance name: kalobr2
      Redo thread mounted by this instance: 2
      Oracle process number: 90
      Windows thread id: 5240, image: ORACLE.EXE (J002)


      *** 2010-11-08 07:44:28.875
      *** SESSION ID:(90.9506) 2010-11-08 07:44:28.875
      *** CLIENT ID:() 2010-11-08 07:44:28.875
      *** SERVICE NAME:(SYS$USERS) 2010-11-08 07:44:28.875
      *** MODULE NAME:(DBMS_SCHEDULER) 2010-11-08 07:44:28.875
      *** ACTION NAME:(WYM_BFR2ISOOG) 2010-11-08 07:44:28.875

      Single resource deadlock: blocked by granted enqueue, f 0
      Granted global enqueue 00000003390E0420
      ----------enqueue 00000003390E0420------------------------
      lock version : 4267
      Owner node : 1
      grant_level : KJUSEREX
      req_level : KJUSEREX
      bast_level : KJUSERNL
      notify_func : 0000000000000000
      resp : 000000033DC16158
      procp : 000000033ACD44B8
      pid : 5240
      proc version : 0
      oprocp : 0000000000000000
      opid : 5240
      group lock owner : 000000033D485868
      possible pid : 5240
      xid : 5A000-0002-00000003
      dd_time : 0.0 secs
      dd_count : 0
      timeout : 0.0 secs
      On_timer_q? : N
      On_dd_q? : N
      lock_state : GRANTED
      Open Options : KJUSERDEADLOCK
      Convert options : KJUSERNOQUEUE KJUSERNODEADLOCKWAIT
      History : 0x49a51495
      Msg_Seq : 0x0
      res_seq : 77
      valblk : 0x781a225e00000000a841225e00000000 x"^A"^
      user session for deadlock lock 0x00000003390E0420
      sid: 90 ser: 9506 audsid: 42183841 user: 46/ISOOG flags: 0x10041
      pid: 90 O/S info: user: SYSTEM, term: KALORACLE2, ospid: 5240
      image: ORACLE.EXE (J002)
      client details:
      O/S info: user: SYSTEM, term: KALORACLE2, ospid: 5240
      machine: KALORACLE2 program: ORACLE.EXE (J002)
      client info: ISOOG - Inforamtyczny System Obsługi Odbiorców Gazu
      application name: DBMS_SCHEDULER, hash value=2478762354
      action name: WYM_BFR2ISOOG, hash value=2354707023
      current SQL:
      UPDATE BUFOR_WYMIANA SET KOD_BLEDU = :B2 WHERE ID = :B1
      Requesting global enqueue 00000003390E05E0
      ----------enqueue 00000003390E05E0------------------------
      lock version : 2943
      Owner node : 1
      grant_level : KJUSERNL
      req_level : KJUSEREX
      bast_level : KJUSERNL
      notify_func : 0000000000000000
      resp : 000000033DC16158
      procp : 000000033ACD44B8
      pid : 5240
      proc version : 0
      oprocp : 0000000000000000
      opid : 5240
      group lock owner : 000000033D485868
      possible pid : 5240
      xid : 5A000-0002-00000003
      dd_time : 0.0 secs
      dd_count : 0
      timeout : 0.0 secs
      On_timer_q? : N
      On_dd_q? : N
      lock_state : OPENING CONVERTING
      Open Options : KJUSERDEADLOCK
      Convert options : KJUSERGETVALUE
      History : 0x51495149
      Msg_Seq : 0x0
      res_seq : 77
      valblk : 0x00000000000000000000000000000000 .
      user session for deadlock lock 0x00000003390E05E0
      sid: 90 ser: 9506 audsid: 42183841 user: 46/ISOOG flags: 0x10041
      pid: 90 O/S info: user: SYSTEM, term: KALORACLE2, ospid: 5240
      image: ORACLE.EXE (J002)
      client details:
      O/S info: user: SYSTEM, term: KALORACLE2, ospid: 5240
      machine: KALORACLE2 program: ORACLE.EXE (J002)
      client info: ISOOG - Inforamtyczny System Obsługi Odbiorców Gazu
      application name: DBMS_SCHEDULER, hash value=2478762354
      action name: WYM_BFR2ISOOG, hash value=2354707023
      current SQL:
      UPDATE BUFOR_WYMIANA SET KOD_BLEDU = :B2 WHERE ID = :B1
      ----------resource 000000033DC16158----------------------
      resname : [0x2c0000][0x4a21d],[TX]
      Local node : 1
      dir_node : 1
      master_node : 1
      hv idx : 113
      hv last r.inc : 2
      current inc : 4
      hv status : 0
      hv master : 1
      open options : dd
      grant_bits : KJUSERNL KJUSEREX
      grant mode : KJUSERNL KJUSERCR KJUSERCW KJUSERPR KJUSERPW KJUSEREX
      count : 1 0 0 0 0 1
      val_state : KJUSERVS_NOVALUE
      valblk : 0x04200000000000000100000001000000 .
      access_node : 1
      vbreq_state : 0
      state : x0
      resp : 000000033DC16158
      On Scan_q? : N
      Total accesses: 713
      Imm. accesses: 647
      Granted_locks : 2
      Cvting_locks : 0
      value_block: 04 20 00 00 00 00 00 00 01 00 00 00 01 00 00 00
      GRANTED_Q :
      lp 00000003390E0420 gl KJUSEREX rp 000000033DC16158 [0x2c0000][0x4a21d],[TX]
      master 1 gl owner 000000033D485868 possible pid 5240 xid 5A000-0002-00000003 bast 0 rseq 77 mseq 0 history 0x49a51495
      open opt KJUSERDEADLOCK
      CONVERT_Q:


      Thanks in advice
      Oscar