"Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"

[Dhanak4]

Hi All,

Facing the below error while connecting to the Oracle database even we have given the proper TNS entries in tnsnames.ora file. Can some one help us on this issue. 

"Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"

[lbendlin]

As the error message says - your connection entry in TNSNAMES.ORA is malformed. Add the SERVICE_NAME attribute.