Private TNSNAMES file

Posted on 2009-04-21
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
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    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

    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 142

    Accepted Solution

    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

    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

    good advice.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    Via a live example, show how to take different types of Oracle backups using RMAN.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now