DeleteObsoleteSearch.sql Is Failing with ORA-00054 Error
(Doc ID 2878778.1)
Last updated on JANUARY 24, 2024
Applies to:
Oracle Agile PLM Framework - Version 9.3.5.0 and laterInformation in this document applies to any platform.
Symptoms
deleteObsoleteSearch.sql is failing with below error:
ERROR
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at line 9
STEPS
The issue can be reproduced at will with the following steps:
1. Stop Agile Application Server
2. Log into sqlplus as agile database user, and run deleteObsoleteSearch.sql available from Doc ID 2723384.1
3. Gets error in the console. Also see the error in deleteObsoleteSearch_XXXXXXXXXXXXXX.log
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 |