AOL - I have applied a patch. at the time of applying he update a table and suddenly he gives the error th

GeekInterview.com > Interview Questions > Oracle Apps > AOL

Go To First | Previous Question | Next Question

AOL | Question 17 of 34

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?

Total Answers and Comments: 4

Last Update: August 20, 2006 Asked by: devesh

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

February 18, 2006 08:27:37

sanjeeb Rakshit

RE: i have applied a patch. at the time of applying he...

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.

Is this answer useful? Yes | No

February 23, 2006 13:17:39

KAP

RE: i have applied a patch. at the time of applying he...

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

Is this answer useful? Yes | No

June 21, 2006 12:49:08

ravikanthk

Member Since: June 2006 Contribution: 1

where would i find the .rf9 files what actualy it dose

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

Is this answer useful? Yes | No

August 20, 2006 04:19:46

Atul

RE: i have applied a patch. at the time of applying he...

.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

Is this answer useful? Yes | No

Go To Top