I have applied a patch. at the time of applying he update a table and suddenly he gives the error that table is lock. Now what i do?

  • Interview Candidate
  • 4
  • 2452

Showing Answers 1 - 4 of 4 Answers

sanjeeb Rakshit

  • Feb 18th, 2006
 

one case could be multiple upgrade scripts in the patch are there, and ad workers are running them parally , so when the first worker was upading the table and second one also gone for the update at the same time, in this case locking error will come.

To resolve this kind of issues patch should not contain different upgrade scripts for a single table ,all the upgrades should happen in the same file.

  Was this answer useful?  Yes

KAP

  • Feb 23rd, 2006
 

use adctrl utility to monitor and restart adworkers after fixing your locking problem. check ad workers log file that show you which table has problem and error message

  Was this answer useful?  Yes

ravikanthk

  • Jun 21st, 2006
 

where would i find .rf9 file, and what execatly it dose

  Was this answer useful?  Yes

Atul

  • Aug 20th, 2006
 

.rf9 files are created while applying patches usually in $APPL_TOP/admin/SID/restart   directory .

I'll check more on this & explain

Atul

http://teachmeoracle.com/interview.html

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions