Schedulled Jobs Are Failing For The Protected Schema Database Vault: ORA-01031
(Doc ID 1227953.1)
Last updated on JANUARY 28, 2020
Applies to:Oracle Database Vault - Version 10.2.0.5 and later
Information in this document applies to any platform.
When attempting to run a scheduled job in a database protected by Database Vault the following error occurs:
The issue can be reproduced at will with the following steps:
1. Add a rule that has the following condition:
UPPER(SYS_CONTEXT('USERENV','SESSION_USER'))='<USERNAME>' and (UPPER(SYS_CONTEXT('USERENV','IP_ADDRESS'))='<IP Address>' )
2. Create a command rule that will be attached to the rule created at step 1.
3. Create a job that is accessing the objects protected by the realm
The JOB will fail with ORA-01031
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