Error: "ORA-12154: TNS:could not resolve the connect identifier specified" in DLP

Products

• Data Loss Prevention
• Data Loss Prevention Enforce

Issue/Introduction

Error "ORA-12154: TNS:could not resolve the connect identifier specified." when installing or upgrading Symantec Data Loss Prevention (DLP) 15.x.

 

Resolution

Check to ensure tnsping databasename works.

Cmd -> tnsping protect

Example output:

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = ##.##.#.#)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = protect)))

If tnsping can not connect review your tnsnames.ora and ensure host and service name match.

If tnsping works check the sqlnet.ora located by default:

%Oracle_home%\product\12.2.0.1\db_1\network\admin\sqlnet.ora

Verify the oracleHost oraclePort oracleServiceName do not contain any carriage returns.

 

Ensure that it contains:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

If it only contains TNSNAMES your install may fail.