I've been attempting to install Spotlight to an Oracle 11g instance on a Cent OS 5 remote server. It fails to install saying it doesn't have privileges to run DBMS_SQL. The error is:
An error has occurred in table MakeXViews in connection D2S with the following error:
ORA-29471: DBMS_SQL access denied
ORA-06512: at "SYS.DBMS_SQL", line 980
ORA-06512: at "SYS.BUILD_XVIEW", line 28
ORA-06512: at line 12
in table MakeXviews
Is Spotlight capable of being used with 11g?
This version of Spotlight does not support Oracle 11g
Install the latest version of Spotlight on Oracle 4.5.2 to resolve this issue
(Please download release notes from support link, http://support.quest.com, for information on Spotlight 4.5.2 and Oracle 11g)
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center