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 laterInformation in this document applies to any platform.
Symptoms
When attempting to run a scheduled job in a database protected by Database Vault the following error occurs:
ERROR
-----------------------
ORA-01031
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
Cause
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
Symptoms |
Cause |
Solution |
References |