When connecting with Spotlight on Oracle Xpert [SoOXpert5.0.1.1022], the following error is displayed:
An error has occurred in table getORAversion in connection ConnectionName:
Not logged on in table getORAversion.
The connection will be disconnected
multiple Oracle homes
Verify the ORACLE HOME system variable is set correctly:
1. Open Windows command prompt
2. Enter path command
3. Verify the path for the default Oracle Home is the first item in the list
4. If necessary, update the Oracle Home in System variables on the client PC with the correct path
