Error "ORA-12154: TNS:could not resolve the connect identifier specified." when installing or upgrading Symantec Data Loss Prevention (DLP) 15.x.
Check to ensure tnsping databasename works.
Cmd -> tnsping protect
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.2.101)(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:
Verify the oracleHost oraclePort oracleServiceName do not contain any carriage returns.
Ensure that it contains:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
If it only contains TNSNAMES your install may fail.