Oracle Audit Vault is on and cannot create database objects for Spotlight on Oracle.
How to resolve this issue?
The problem being seen is down to the fact that the installation wizard within Spotlight needs to create read only views within the SYS Schema and as such needs to be run with a user account that has SYSDBA role granted to it. The issue comes about due to additional rules put on to lock objects in the SYS schema from being modified.
WORKAROUND 1:
It is worth noting that Spotlight does work with the default set of database vault rules. A workaround that can be tried is as follows:
1. Disable the rules preventing SYS objects from being modified
2. Install the Spotlight user
3. Enable the rules again
Once the user is created Spotlight does not need to modify them again, until it is updated to a newer version.
WORKAROUND 2:
