How can I lookup the tns name of my oracle database?

Question

I want to connect to Oracle via sqlplus but my schema name is not working. error of:

TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Answer 1

open the tnsnames.ora file found in a path similar to:

C:\Program Files (x86)\Centricity EMR 9.8\Oracle\network\ADMIN

 

Find the database you want to connect to and the SERVICE_NAME = the_name_you_are_looking_for

in a command line enter:

sqlplus username/password@SERVICE_NAME

ie

sqlplus ml/ml@emr