Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I installed the oracle client only but was told to update my tnsnames.ora file with the info my dba sent me. But I don't have a tnsnames.ora file.

On another machine with a full oracle admin install it is at:

  • C:\Oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora

So do I need the tnsnames.ora file?

How do I let oracle know where it is?


share|improve this question

4 Answers 4

I have Oracle Client installed on my machine. Last week my DBA updated my "tnsnames.ora" file because of server change. The file is in:

  • C:\oracle\ora81\network\ADMIN

I guess you should consult your DBA if copying the file to that directory doesn't work.

share|improve this answer
that worked for me. Excellent. Thanks. –  djangofan Jan 3 '13 at 0:26

When you say oracle client only, are you using the Oracle Instant Client? If so you should set the TNS_ADMIN environment variable to point to where ever you store your tnsnames.ora file

share|improve this answer

If the .\network\admin folder exists on your machine, simply copy the tnsnames.ora in this directory.

share|improve this answer

Its in %ORACLE_HOME%\network\admin folder where %ORACLE_HOME% is the parth to which the client is installed, and an entry is done to the PATH variable. If the file does not exist, create one, using the file on the other machine as a template

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.