My Oracle Support Banner

Schema Changes in Migration fails with Error ORA-00054 and Require Downtime (Doc ID 2700211.1)

Last updated on MARCH 26, 2024

Applies to:

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

Symptoms


DDLImport fails with below error and needs downtime during the migration when schema changes are migrated :


2020-06-20 11:50:52 SQL Statement: alter index S_EVT_ACT_F111_X noparallel logging
2020-06-20 11:50:52 [1076673536][ODBC Oracle driver][Oracle]ORA-00054:resource busy and acquire with NOWAIT specified or timeout expired
2020-06-20 11:50:52 Dropping index with the same column signature and retrying...
2020-06-20 11:50:52 alter index S_EVT_ACT_F111_X noparallel logging

 

Changes

 

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
Changes
Cause
Solution
References


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