When using the install.sql script on the local server for the Oracle database I want Spotlight to connect to, which is from \Program Files\Quest Software\Spotlight\Plug-ins\SoO\OracleScripts I get the following error:
DECLARE
*
ERROR at line 1:
ORA-01722: invalid number
ORA-06512: at line 4
The issue is being caused by the fact that our script is expecting the Oracle version to be n.n, but in non English environments we are getting n,n.
Please run the attached modified install.sql script instead of the file under \Program Files\Quest Software\Spotlight\Plug-ins\SoO\OracleScripts. Run it locally as the SYS user on the database server in a SQL*Plus session.
When you are asked for Repository_Owner, please enter the name of the user you want created to be used with Spotlight on Oracle to connect to your database.