Error: ORA-12154 creating DLP integration
Article ID: 413058
Updated On:
Products
Issue/Introduction
The following error message is displayed on the Progress and Finish page of the New Connection Wizard when attempting to integrate Information Centric Analytics (ICA) with a Symantec Data Loss Prevention (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_<hostname>_<schema>". OLE DB provider "OraOLEDB.Oracle" for linked server "RISKFABRIC_DLP_RISKFABRIC_<hostname>_<schema>" returned message "ORA-12154: TNS:could not resolve the connect identifier specified".
Environment
Release : 6.x
Component : Symantec Data Loss Prevention Integration Pack
Cause
The error code 'ORA-12154: TNS:could not resolve the connect identifier specified' is an Oracle database error indicating the EZCONNECT naming method is unavailable. From Oracle document Database Error Messages: ORA-12154:
"A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached."
When adding a DLP data source, ICA creates a linked server connection in Microsoft SQL Server to the server hosting DLP's protect database, and it uses Oracle's EZCONNECT naming method (also referred to as 'Easy Connect') in the linked server connection string. When this naming method is unavailable, SQL Server is unable to reach the Oracle database server to validate the linked server's connection string. This causes the linked server creation to fail.
Resolution
Per the same Oracle document referenced above in the Cause section of this article:
"Verify that "EZCONNECT" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)."
Your Oracle database administrator (DBA) should ensure the EZCONNECT protocol is enabled. The following documentation from Oracle may be of assistance to your DBA:
Additional Information
The following simple test can help you determine whether the EZCONNECT naming method is enabled on your Oracle database server. If you have installed the Oracle Database Client's SQL*Plus component on the server hosting Microsoft SQL Server and the RiskFabric relational database, execute the following command in SQL*Plus on that server, replacing the variables with the server details and credentials of the DLP database user you specified in ICA's DLP integration configuration wizard:
sqlplus <account>/<password>@//<hostname>:<port>/<schema>
Feedback
