[Last Call] Learn how to a build a cloud-first strategyRegister Now


Private TNSNAMES file

Posted on 2009-04-21
Medium Priority
Last Modified: 2012-08-14
what's the name of private tnsname I can save in C:\Documents and Settings\userName\Application Data\Oracle ?

(fyi: our C:\Oracle\8i\network\ADMIN is locked....r/o ) I know we can have a private TNSNAMES.ORA .....
Question by:Scotford
  • 3
  • 2
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24198769
you can put a tnsnames.ora file anywhere.
however, to be taken into account, you need to set the TNS_ADMIN registry setting to point to the folder you put the file into.

Author Comment

ID: 24199105
Yes I know....but our environment is locked down....
I know if we have a file named: TNSNAMES_Private.ORA or? (not sure about name of file) in C:\Documents and Settings\userName\Application Data\Oracle  it will be pciked up by SQLplus, or TOAD.....I'm looking for correcr name of file I tried all kind of combinations:

but no luck....
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 150 total points
ID: 24199183
the file must be named tnsnames.ora.

here is the precedence list of path/locations where oracle "looks":

1. current path (associated with the running client application)
2. Environment variable TNS_ADMIN defined for the session
3. Environment variable TNS_ADMIN defined for the system
4. Windows Registry Key TNS_ADMIN
5. %ORACLE_HOME%\network\admin

so, you just need to put the file in the folder the application runs in, and voila.

Author Comment

ID: 24215407
I put a file named: TNSNAMES_private.ORA in C:\Documents and Settings\userNmae\Application Data\Oracle

and these private TNSNAMES will be added to standard TNSNAMES is ...\Oracle\...\admin\

and will work....

Author Closing Comment

ID: 31573012
good advice.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question