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

Question 1

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

Question 2

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

michael-h-5027 · Answer 1 · 2014-08-25T16:25:46+0000

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

Categories

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

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.