The following error is displayed in the New Connection Wizard when attempting to connect Information Centric Analytics (ICA) to a Symantec DLP data source:
The connection to the Symantec Data Loss Prevention database failed.
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "RISKFABRIC_DLP_RISKFABRIC_<host>_<service_name>". OLE DB provider "OraOLEDB.Oracle" for linked server "RISKFABRIC_DLP_RISKFABRIC_<host>_<service_name>" returned message "ORA-12541: TNS:no listener".
Release : 6.x
Component : Symantec DLP Integration Pack
This error occurs when the TNS listener on the Oracle database server is not configured to accept external connections.
The following SQL*Plus EZCONNECT command can be run from a command prompt on the SQL Server host to test whether the Oracle database is accepting external connections:
sqlplus <user>@<host>:<port>/<service_name>
Refer to Oracle's documentation for configuring the Net Listener (listener.ora):