This discussion is archived
4 Replies Latest reply: Jul 7, 2013 7:09 PM by Hemant K Chitale RSS

Deadlock issues when a program runs first time after Database bounce but doesn't face issue later on until again db is bounced

BLKR Newbie
Currently Being Moderated

Current configuration of database:

Database version -- 11.2.0.3

OS: Linux x86-64

DB Server: EXADATA

 

Recently upgraded from 10.2.0.4 to 11.2.0.3

 

 

To Explain the issue:

 

Recently it has come to our notice that 1 of our concurrent program gets locking issues immediately after a Database and application bounce.

This issue had been coming up after we upgraded our Database from 10g to 11g.

We generally have our maintenance during the weekend(sunday) once or twice a month depending on business need.

 

Immediately after the Database Upgrade when the Program was submitted it failed with the below error.

Error ORA-20001: FLEX-DSQL EXCEPTION

 

Team then applied the fix as in note id: 974396.1

Fix:

execute immediate('ALTER session SET '||'"_fix_control"'||'='||'''5909305:OFF''');

 

It then has been brought up to us now that the same program is now facing problems with Locks.

In general what's happening is whenever we have a DB and application services bounce, the very first time after bounce when the program is submitted it gets locking issues as below:

 

Issue with Application program is not completely ruled out but same code worked fine in 10g and it also works fine after a few days of maintenance.

 

 

Cause: You are trying to lock a row in the pay_org_paym

Error creating Paycard Payment Method for Employee Number :1031699 :ORA-20001: The current row is locked

 

 

After a week or two of bounce when the Program is submitted it never faces any locks issue.

Legend

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