My Oracle Support Banner

Datapatch Verbose is taking Long and throwing error ORA-04021: timeout occurred while waiting to lock object SYS.DBMS_AQADM_VAR (Doc ID 3033773.1)

Last updated on DECEMBER 12, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.23.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Post oracle 19.23 GI RU Patching in Oracle AIX Operating System environment Datapatch is taking long and finish with follow erross :

 

Patch 36233263 apply: WITH ERRORS (RETRYABLE)
  logfile: /oraclehome/oracle/app/oracle/cfgtoollogs/sqlpatch/36233263/25639721/36233263_apply_PBFSRS01_2024Jun26_13_45_55.log (errors)
  -> Error at line 50059: script rdbms/admin/prvtaqds.plb
  - ORA-04021: timeout occurred while waiting to lock object SYS.DBMS_AQADM_VAR
  -> Error at line 51753: script rdbms/admin/prvtaqds.plb
  - ORA-04021: timeout occurred while waiting to lock object SYS.DBMS_AQADM_SYS
  -> Error at line 51763: script rdbms/admin/prvtaqds.plb
  - ORA-04021: timeout occurred while waiting to lock object SYS.DBMS_AQADM_SYS
Patch 36199232 apply: WITH ERRORS (PREV PATCH)



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


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