This discussion is archived
1 Reply Latest reply: Oct 29, 2012 6:41 AM by Iulian J. Dragan RSS

Problem after upgrade to 11.2.0.1

475856 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points