Custom Index Re-Creating Every Time When Performing Migration from Source to Target and Failing with ERROR: ORA-00054 (Doc ID 2698786.1)

Last updated on AUGUST 17, 2022

Applies to:

Symptoms

On : 18.12 version, System Admin

Schema Error for Siebel Migration

Migration process - Async

During migration process, when there is schema changes, majority of times, it fails while updating index CX_VSINTE1. This is index on custom table which is heavily used in our integration. We confirmed that DB team does not make any modifications to index after the migration is done.
Also there is no changes to the index for which the error is thrown.

Please let us know why migration process fails on index even though we have neither modified the index in Siebel tools nor on Database side.


ERROR
-----------------------

“alter index CX_VSINTE1 noparallel logging
2020-05-16 02:24:34 [1076673536][ODBC Oracle driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

2020-05-16 02:24:34
2020-05-16 02:24:34 S1000: [1076673536][ODBC Oracle driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
2020-05-16 02:24:34
2020-05-16 02:24:34 Dropping index with the same column signature and retrying...
2020-05-16 02:24:34 alter index CX_VSINTE1 noparallel logging
2020-05-16 02:24:34
2020-05-16 02:24:34 ;
2020-05-16 02:24:34 SQL Statement:
drop index CX_VSINTE1
2020-05-16 02:24:34 [1076673536][ODBC Oracle driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

2020-05-16 02:24:34
2020-05-16 02:24:34 S1000: [1076673536][ODBC Oracle driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
2020-05-16 02:24:34
2020-05-16 02:24:34 drop index CX_VSINTE1
2020-05-16 02:24:34
2020-05-16 02:24:34 ;
2020-05-16 02:24:34 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
2020-05-16 02:24:34 writeExecDDL error (pOperCallback UTLDbDdlOperIndDrop).
2020-05-16 02:24:34 Error in MainFunction (UTLDbDdlDbMerge).”

Changes

Cause

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