Oracle Database Vault Known Bugs
These are the Oracle Database Vault known bugs in Oracle Database 21c.
Parent topic: Open Bugs Affecting All Platforms
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’);
Parent topic: Oracle Database Vault Known Bugs