My Oracle Support Banner

19c: Datapatch Fails With PLS-00302: Component Must Be Declared (Doc ID 3014764.1)

Last updated on APRIL 09, 2024

Applies to:

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

Symptoms

Datapatch -verbose on a 19.10 (19.10.0.0.210119) to apply the patch 35643107 (19.21.0.0.231017) along with one-off patches 29213893 and 34774667, it fails with PLS-00302: component 'TRACE_PURG_STATS' must be declared.

Validating logfiles...done
Patch 35643107 apply: WITH ERRORS
logfile: /u01/app/oracle/product/19.3.0/cfgtoollogs/sqlpatch/
-> Error at line 70400: script rdbms/admin/prvtaqiu.plb
- Warning: Package Body created with compilation errors.
-> Error at line 70407: script rdbms/admin/prvtaqiu.plb
- 317/5 PL/SQL: Statement ignored
-> Error at line 70408: script rdbms/admin/prvtaqiu.plb
- 317/44 PLS-00302: component 'TRACE_PURG_STATS' must be declared
-> Error at line 70409: script rdbms/admin/prvtaqiu.plb
- 339/5 PL/SQL: Statement ignored
-> Error at line 70410: script rdbms/admin/prvtaqiu.plb
- 339/44 PLS-00302: component 'TRACE_PURG_STATS' must be declared
Patch 29213893 apply: WITH ERRORS (PREV PATCH)
Patch 34774667 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.