ICA processing failure to create OLE DB provider instance

Products

• Information Centric Analytics

Issue/Introduction

After removing an older version of the Oracle client from the SQL Server hosting the Information Centric Analytics (ICA) RiskFabric database, the following error is logged while staging data from the Symantec DLP database during the Run Staging Procedures step of the RiskFabric Processing job:

Error Msg: Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "RISKFABRIC_DLP_RISKFABRIC_<hostname>".Line  Number: 1

The resolution for this error message provided in KB article 189879 does not resolve this error.

Environment

Release : 6.5.4

Component : Oracle Database Client

Cause

The Oracle home specified in the PATH system environment variable is not the home of the currently installed Oracle client.

Resolution

Modify the system PATH environment variable to point to the Oracle home path of the currently installed Oracle database client software by following this procedure:

1. On the SQL Server, right-click the Windows Start icon and select System
2. In the System window under Control Panel Home, select Advanced system settings
3. In the Environment Variables window under System variables, select the Path variable and click the Edit... button
4. In the Edit environment variable window, select any invalid Oracle home path(s) and click the Delete button
5. If the current Oracle home path is not specified, add it by clicking the New button
6. Click the OK button to close the Edit environment variable window
7. Click the OK button to close the Environment Variables window
8. Click the OK button to close the System Properties window
9. Restart Windows on SQL Server for the changes to the environment variables to take effect