A connection to Oracle 12C database will throw the following error:
"DATE TIME","Alarm raised","The Oracle connection has failed with the error: ORA-01031: insufficient privileges in table RollbackInfo. Spotlight will attempt to re-establish this connection.",High,"Versions (Oracle Status)"
Before Oracle 12c, if you had the SELECT ANY DICTIONARY privilege, that meant you could select from the SYS.USER$ table; however with Oracle 12c, they took SYS.USER$ out of the SELECT ANY DICTIONARY privilege.
Grant the Spotlight User "SELECT on SYS.USER$" will resolved the issue.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center