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

MOSC Banner

Sev1: Error applying patch 9231477

edited Mar 15, 2013 4:40AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered
 Hi,
Apps 11.5.10.2

Customer is applying AX patch 9231477 and getting 

The freelists value for table AX_BALANCES is too small.
  [Alter Table freelists from 0 to 4 ]

Alter the table with the statement:

Start time for statement below is: Thu Mar 14 2013 18:00:15

ALTER TABLE AX.AX_BALANCES 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 AX.AX_BALANCES STORAGE (FREELISTS 4)

AD Worker error:
Unable to compare or correct tables or indexes or keys
because of the error above

Time when worker failed:
--------------------------------
apatch log shows
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