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

It can be caused by including (connect_date) clause in (address_list) clause.

tnsping works find but sqlplus gives error: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA.

remove address_list clause or put connect_data out of address_list.