Cannot create an instance of OLE DB provider when integrating Symantec DLP

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

When adding or configuring a Symantec Data Loss Prevention data source, the process fails and returns the following error:

The connection to the Symantec Data Loss Prevention database failed.

Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "RISKFABRIC_DLP_RISKFABRIC_<host>_<schema>".

Environment

Release: 6.5.x

Component: Symantec DLP Integration Pack

Cause

The option Allow inprocess is not enabled for the OraOLEDB.Oracle provider in SQL Server.

Resolution

To enable the Allow inprocess option for the Oracle provider, follow this procedure:

1. Using SQL Server Management Studio (SSMS), connect to the Database Engine hosting the RiskFabric database
2. In Object Explorer, navigate to Server Objects > Linked Servers > Providers
3. Right-click the OraOLEDB.Oracle provider and select Properties
4. In the Provider Options window on the General page, check the Enable box for the Allow inprocess option
5. Click the OK button to close the Provider Options window
6. In Object Explorer, right-click the SQL Server host and select Restart to restart the SQL Server service (sqlservr.exe)