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

MOSC Banner

Patch 18390915 : R12.OTA.B - FAILED: file otaolms.odf

edited May 21, 2014 9:51AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered ✓

Hello Support,

Patch 18390915 : R12.OTA.B - FAILED: file otaolms.odf  on worker

===== Table OTA_LEARNING_OBJECTS all columns match.

The freelists value for table OTA_LEARNING_OBJECTS is too small.

[Alter Table freelists from 0 to 4 ]

Alter the table with the statement:

Start time for statement below is: Tue Apr 29 2014 16:43:46

ALTER TABLE OTA.OTA_LEARNING_OBJECTS STORAGE (FREELISTS 4)

AD Worker error:

The following ORACLE error:

ORA-00604: error occurred at recursive SQL level 1

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at line 34

ORA-10620: Operation not allowed on this segment

occurred while executing the SQL statement:

ALTER TABLE OTA.OTA_LEARNING_OBJECTS 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