Access violation in Oracle Client when connecting to Oracle 9.2.0.8 database. (28189)

I receive the message "an access violation has occurred in the Oracle Client" after having Spotlight running from 10-30 minutes. Solution 24787 has been implemented but the error still occurs.

This is an Access Violation in the client OCI library; it is caused by an Oracle bug for which there are two workarounds available.

WORKAROUND 1:

The solution is to upgrade the client to 9.2.0.8 or later ... available in Oracle patchset 4547809

We have discovered that there are several situations where an Oracle client will have problems communicating with an Oracle server of a later version. Therefore, a future release of Spotlight on Oracle will have inserted into the release notes the following:

"Spotlight also requires that the version of the Oracle client be the same or later than the version of any Oracle database being diagnosed."

WORKAROUND 2:

If you do not want to upgrade the Oracle client, then there is another workaround which applies ONLY to Spotlight on Oracle 4.0.4

Caution: The workaround implies that every query gets closed after execution. This means that cursors are not being reused, which might have a slight impact at the server.

Run spotlight with the attached SQLNet datasource - Steps to install the SQLNet datasource:

1. Rename the existing SQLNet.sdx file found in the SQLNet datasource directory to SQLNet_original.sdx

(eg C:\Program Files\Quest Software\Spotlight\Plug-ins\SQLNet)

2. Copy attached SQLNet.sdx in SQLNet folder,

(e.g C:\Program Files\Quest Software\Spotlight\Plug-ins\SQLNet)

3. Copy Install.ini in console folder,

(e.g. C:\Program Files\Quest Software\Spotlight\Console)

4. Open install.ini and make sure DatasourceSQLNet points to the right location SQLNet.sdx.

This install.ini will cause the spotlight console to reregister the SQLNet datasource and show the right version information in the about box.

5. Run Spotlight and go to about box to make sure the version for SQLNet datasource is 3.2.0.151

6. Run spotlight against 9.2.0.8 database.