Initially Spotlight on Oracle 2.0c1 was installed and we were encountering an "Invalid variant type conversion" error. Since Spotlight on Oracle 2.0c1 is an unsupported version of Spotlight (version out dated), we upgraded to the latest version Spotlight 4.0.2; however, upon launching Spotlight we encountered the error:
"SoO5072 There was an error reading the tnsnames.ora file. Either Oracle is not installed, or the tnsnames.ora file is corrupt".
Path variable was not set to the correct path of the correct Oracle_Home. As a result, Spotlight could not find the tnsnames.ora file.
1. Open the registry editor (Start | Run | regedit) and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE to find the default Oracle_Home.
2. Open a Windows command prompt and issue the following command to view System Path variable:
path
3. Verify that the correct Oracle_Home is set in the path variable.
4. If the path must be modified follow the steps below:
a. Select Start | Settings | Control Panel | System | Advanced tab.
b. Click Environment Variables.
c. Scroll to PATH variable and verify that the variable string contains the correct path to the correct Oracle_Home (refer to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE).
