After 15-25 minutes Spotlight on Oracle fails with the following "Access Violation" message.
"An access violation has occurred in the Oracle Client.
You may have attempted to connect to a 10G (release 2) instance while using an Oracle client that is 10G (release 1) or older.
"<Connection Name>" will be disconnected."
This issue can be resolved by modifying the system path variable. Try moving the path for the default Oracle Client to the front of the system path variable (ie move <ORACLE_HOME>\bin to front of string variable)
1. Go to Control Panel | System | Advanced | Environment Variables
2. Under System Variables, select Path and click Edit
3. Try moving the path for the <Oracle Home>\bin to the front of the Path variable (you may want to copy then entire string to notepad and make the modification and then paste back into the path variable with C:\<ORACLE_HOME>\bin; at front of string).
Note: If there are more that one Oracle clients installed, make sure the version of the default Oracle client is the same or later than the version of any Oracle database being diagnosed.
Since Spotlight requires that the version of the Oracle client be the same or later than the version of any Oracle database being diagnosed, make sure the version of the default Oracle client is the same or later than the version of any Oracle database being diagnosed and that this is the first path in the System Variables Path
