Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Oracle 19.18 PSU Linux 86_64 issues (ORA-13516: AWR Operation failed: CATPROC not valid)

in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered

I am trying to apply the 'fixed' 19.18 PSU that was release on 1/31/2023. I have Oracle EE 19C DB running on Linux 7 (Oracle Linux). This is for a CDB/PDB DB running on prim (single server).

When performing the ./datapatch -verbose step in the patching process, I get the following errors on the CDB and every PDB:

Error at line 9395: script rdbms/admin/backport_files/bug_33527739_apply.sql

   - ORA-13516: AWR Operation failed: CATPROC not valid

   - ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 328

   - ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 355

   - ORA-06512: at line 12

This was an new install using the 19.3 software (2 years ago). I have applied all of the following patches and have NEVER gotten an error like this (19.11 through 19.17). Has anyone else received this error when applying the 19.18 (Combo) PSU? Could this be related to the addition of Perl that Oracle added to the release? This does not appear to be related to the LMON issues that was causing issues in the original 19.18 release.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center