search cancel

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


Article ID: 189879


Updated On:


Information Centric Analytics Data Loss Prevention Core Package


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>".


Release: 6.5.x

Component: Symantec DLP Integration Pack


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


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)