Siebel Upgrade: Upgrep Process is Failing with Error ORA-00054: Resource Busy and Acquire with NOWAIT Specified or Timeout Expired
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 8.2.1 SIA and later
Information in this document applies to any platform.
Upgrep process is failing during ddlimp process execution, because Oracle database client timed-out and returned error "ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired".
This was noticed in the traces from the upgwiz.log and ddlctl_indx1.log
During the current upgrade attempt, the Oracle database client timed-out while processing the S_EVT_ACT table, during index creation.
2014-08-21 16:03:58 Merging table S_EVT_ACT ...
2014-08-21 16:32:40 Creating index S_EVT_ACT_F26 ... 28:41.969m
Notice that it was taking longer, and longer to create the indexes, until the error was returned...
2014-08-21 22:22:20 Creating index S_EVT_ACT_F65 ... 32:53.531m
This trace clearly indicates the issue that occurred during the upgrade process:
2014-08-21 22:22:20 [tp][ODBC Oracle driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
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