tnsping orcl <enter> . Re: ORA-12154: TNS:could not resolve the connect identifier specified

 

AndrewSayer May 31, 2016 10:01 AM (in response to 3206620)

You should not be looking for the "TSNAMES,ora file" but the "tnsnames.ora file"

Your use of formatting does not make it clear what you have copied and pasted from your window, or from a source on the internet. 

 

You can use the windows search bar to find the file or It should be in %ORACLE_HOME%\network\admin

You can use the tnsping utility to tell you where this directory is :

Open up cmd

type tnsping orcl <enter>

 

Screen will output:

Used parameter files:

C:\...\network\admin\sqlnet.ora

The same directory will contain the tnsnames.ora file.