ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Receiving "ORA-12154: TNS:could not resolve the connect identifier specified" while trying to login to Enforce Server database

book

Article ID: 160000

calendar_today

Updated On:

Products

Data Loss Prevention Enforce Data Loss Prevention

Issue/Introduction

You get the Error:- "ORA-12154: TNS:could not resolve the connect identifier specified" while trying to login to Enforce Server database database (e.g., the "protect" database for DLP).

 

 

Cause

This error may occur with the use of special characters in the password.

Resolution

An Oracle password has the following rules:

o Passwords must be from 1 to 30 characters long. 
o Passwords cannot contain quotation marks. 
o Passwords are not case sensitive. 
o A Password must begin with an alphabetic character. 
o Passwords can contain only alphanumeric characters and the
  underscore (_), dollar sign ($), and pound sign (#). Oracle 
  strongly discourages you from using $ and #.. 
o A Password cannot be an Oracle reserved word (eg: SELECT). 
o Passwords cannot have other "special" characters.

 

Note: if the @ symbol is used in the password, the use of double quotes "password" may resolve the issue and allow the login to be successful.