ORA-02002 and ORA-00942 while upgrading OWM to 19c

This is a quick post about a problem that we have had while upgrading a DB to 19c.

At 91% of the upgrade, the OWM (Workspace Manager) upgrade was failing with this error error:

Indeed, executing the statement was leading consistently to this problem:

and we have had this result:

So, resuming the autoupgrade job was not a solution.

The view definition is:

but the package wmsys.ltUtil is wrapped, so no chance to understand what was happening.

As a quick fix, we have recompiled the binaries with mixed auditing:

and put the audit_trail=DB in the upgrade pfile (was NONE in this specific case).

After that, restarted the DB in upgrade mode using the same pfile.

After that, the view was giving no errors anymore and we resumed the autoupgrade job.

This is an old troubleshooting method that I call “Database Administration by guess”: I am not sure about the real cause, but the workaround just worked fine for us.

It would be interesting to know if anyone of you have had the same problem, and what were the auditing parameters in your case…


The following two tabs change content below.


Principal Product Manager at Oracle
Ludovico is a member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle. He focuses on Oracle Data Guard, Flashback technologies, and Cloud MAA.

2 thoughts on “ORA-02002 and ORA-00942 while upgrading OWM to 19c

  1. Hi Ludovico,
    I had the same issue while updating my 12cr1 instance (with OWM) to 19c.
    What i did :
    – test if OWM is used
    – if not : remove it on 12c
    – upgrade to 19c
    -and reInstall it again

    Now , i have an other issue with DVSYS schema :

    2:01:58 13 END;
    12:01:58 14
    12:01:58 15 IF (simTblExists = TRUE) THEN
    12:01:58 16 — If no simulation log records exist, drop the existing table. It is
    12:01:58 17 — created in rdbms/admin/catmacc.sql.
    12:01:58 18 IF (cnt = 0) THEN
    12:01:58 19 EXECUTE IMMEDIATE ‘drop table dvsys.simulation_log$’;
    12:01:58 20 ELSE
    12:01:58 21 — If simulation log records exist, move them to
    12:01:58 22 — dvsys.old_simulation_log$ table.
    12:01:58 23 EXECUTE IMMEDIATE ‘ALTER TABLE dvsys.simulation_log$
    12:01:58 24 RENAME TO old_simulation_log$’;
    12:01:58 25 sys.dbms_registry.set_progress_value(‘DV’, ‘SIMULATION LOGS’,
    12:01:58 26 ‘The existing simulation logs have been moved to dvsys.old_simulation_log$’);
    12:01:58 27 END IF;
    12:01:58 28 END IF;
    12:01:58 29 END;
    12:01:58 30 /
    ERROR at line 1:
    ORA-02002: error while writing to audit trail
    ORA-06512: at line 11
    ORA-00942: table or view does not exist
    ORA-00942: table or view does not exist
    ORA-06512: at line 6

    Have you met this situation ?


    Hafedh KADDACHI

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.