TNS:no listener error when integrating Symantec DLP

Products

• Information Centric Analytics

Issue/Introduction

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

Environment

Release : 6.x

Component : Symantec DLP Integration Pack

Cause

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>

Resolution

Refer to Oracle's documentation for configuring the Net Listener (listener.ora):

https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/configuring-and-administering-oracle-net-listener.html