Upgrep Fails With ORA-01554
(Doc ID 2224008.1)
Last updated on APRIL 07, 2021
Applies to:
Siebel Financial Services CRM - Version 16.7 [IP2016] and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |