While using the Spotlight on Oracle manual install script it fails to install giving the following errors:
PLS-00201: identifier 'QUEST_SOO_LOCK_TREE' must be declared
PLS-00201: identifier 'DBMS_SQL' must be declared
PLS-00201: identifier 'DBMS_LOB' must be declared
The compilation of the following packages failed:
quest_soo_alerttrace
quest_soo_pkg
quest_soo_user_manager
Spotlight on Oracle database user misses privileges on DBMS packages due to security guidelines.
Run the following commands as the sys user via SQL*Plus:
grant execute on DBMS_SQL to <Spotlight user>;
grant execute on DBMS_LOB to <Spotlight user>;
For additional information why Spotlight needs execute privileges on these packages have a look at solution sol41045:
https://support.quest.com/SUPPORT/index?page=solution&id=SOL41045
