Oracle Database Vault Known Bugs

These are the Oracle Database Vault known bugs in Oracle Database 21c.

Bug 33109335

For all Oracle Scheduler jobs, if the following conditions are met, then the jobs fail with error ORA-01031:

  • The job must access Oracle Database Vault protected objects.
  • The jobs are owned by a non-SYS user.
  • The job must be started before Oracle Database Vault is enabled in the database.

Workaround:

For all jobs failing with error ORA-01031, disable and reenable the job with a user with Oracle Database Vault enabled. If the user enabling the job is not same as the job owner, then scheduler authorization is necessary. The authorization looks like:
execute dbms_macadm.authorize_scheduler_user(‘user_who_enabled_job’, ‘job_owner’);