ORA-12838 during Upgrep to IP2106 (Doc ID 2192085.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 16.0 [IP2016] and later
Information in this document applies to any platform.

Symptoms

When attempting to run Upgrep to IP2016 the following error occurs while executing SQL 220 from upg_data_afterseed.sql

ERROR
-----------------------
ORA-12838: cannot read/modify an object after modifying it in parallel


STEPS
-----------------------
The issue can be reproduced at customer will with the following steps:
1. restore database from previous version
2. enable parallel at database level, done by DBA
3. choose to use parallel when running the db wizard
4. start upgrade. It fails on the mentioned step


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms