Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

14284509 : 12.1.3 : ORA-10620 on executing xlatabh.odf

edited Jan 3, 2013 7:56AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 14 commentsAnswered
Hi Paul:Welcome to the new EBS Patching community.

This thread will address your following issue

Worker fails at running file xlatabh.odf; from worker log:
The freelists value for table XLA_LINE_DEFN_JLT_ASSGNS is too small.
 [Alter Table freelists from 0 to 4 ]

Alter the table with the statement:
Start time for statement below is: Wed Dec 12 2012 11:10:39

ALTER TABLE XLA.XLA_LINE_DEFN_JLT_ASSGNS STORAGE (FREELISTS 4)
AD Worker error:
The following ORACLE error:

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
occurred while executing the SQL statement:
ALTER TABLE XLA.XLA_LINE_DEFN_JLT_ASSGNS STORAGE (FREELISTS 4)
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center