When trying to connect with Spotlight the following error occurs:
Error: "ORA-00942: table or view does not exist in table Instance Info"
The Spotlight datatabase objects have not been installed.
Perform the following to resolve this issue
1) Please run the SQL statement from SQLPlus:
select owner, object_name, object_type, status
from dba_objects
where object_name like 'QUEST_SOO%';
and see if there any invalid objects and make sure that there is only one owner.
2) If this was an upgrade or fresh install run upgrading Spotlight objects from the Spotlight's File menu : Oracle User Wizard
3) If the above things were already OK then the only option left is that you need to check the connection details (connection manager/properties) and make sure that the Oracle user that you have entered was correct. IT SHOULD BE THE USER THAT OWNS SPOTLIGHT OBJECTS (you will know it from the output of the above SQL statement in step 1).
You have to put in the correct user and then connect Spotlight. You can delete any other connection in connection manager (right click) and recreate them.
