After creating a new Oracle connection in Spotlight, the following error is displayed upon connecting:
soo5049: The following error occurred in Spotlight connection during connection:
Range check error
The connection will be disconnected
The Oracle User Wizard has not been run against the connecting Oracle user.
Run the Oracle User Wizard to setup the Spotlight User - File | Oracle User Wizard.
Please refer to the Spotlight on Oracle Getting Started Guide - Creating a new Spotlight user section; or the online Help from the Spotlight console (Help | Contents) - Spotlight | Spotlight on Oracle | Starting Spotlight on Oracle | Setting up users.