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

 
AndrewSayer Titan

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% etworkadmin

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:... etworkadminsqlnet.ora

The same directory will contain the tnsnames.ora file.

原文地址:https://www.cnblogs.com/shuihaya/p/12957109.html