-
Title
after upgrade error ORA-00955: name is already used by an existing object -
Description
After upgrade experinced the following error:
The following error occurred while configuring the existing user:
The Spotlight User Wizard has encountered an error. An error was reported for table
"SoOTables" in connection "name_of_the_connection".
The error is:
ORA-00955: name is already used by an existing object
ORA-06512: at line 207
in table SooTables -
Resolution
Drop the Spotlight database user with cascade option (if that user is used for Spotligth only) and re-install the objects by going to File | Oracle User Wizard. please make sure you use sys on first screen as a granting user.
If you experience any problems with Oracle user wizard from file memu, you can always use the manual script for dropping, upgrading or instaling Spotligt user.
The manual script's default location on your PC (to be ran on the monitored server directly) is on your client machine where you have your Spotlight installed under : c:\Program Files\Quest Software\Spotlight\Plug-ins\SoO\OracleScripts
You can copy or ftp that script file to your monitored server and run it there (spool) from SQL Plus (i.e.: @install.sql).