Upgrep Fails With ORA-01554 (Doc ID 2224008.1)

Last updated on APRIL 07, 2021

Applies to:

Symptoms

Upgrep fails when running IRM from Siebel 8.1.1.10 to 16.7 in the step Prepare for index creation ,
the following error occurs.

ERROR
-----------------------
create unique index S_ACCELERATOR_U1 on S_ACCELERATOR
("COMMAND_ID", "NAME", "WS_ID", "WS_OBJ_VER") parallel nologging
tablespace SIEBELINDEX
2017-01-05 01:23:01 [tp][ODBC Oracle driver][Oracle]ORA-12801: error signaled in parallel query server P057
ORA-01554: transaction concurrency limit reached reason:no undo segment found with available slot params:0, 0
2017-01-05 01:23:01
2017-01-05 01:23:01 S1000: [tp][ODBC Oracle driver][Oracle]ORA-12801: error signaled in parallel query server P057
2017-01-05 01:23:01 ORA-01554: transaction concurrency limit reached reason:no undo segment found with available slot params:0, 0
2017-01-05 01:23:01
2017-01-05 01:23:01 Dropping index with the same column signature and retrying...
2017-01-05 01:23:01 create unique index S_ACCELERATOR_U1 on S_ACCELERATOR
2017-01-05 01:23:01 ("COMMAND_ID", "NAME", "WS_ID", "WS_OBJ_VER") parallel nologging
2017-01-05 01:23:01 tablespace SIEBELINDEX



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. set the undo_management to manual as per the upgrade guide.
2.Run upgrep.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.