DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TNS_ADMIn

  1. 02-08-2002, 01:01 PM #1
    rpardip
    rpardip is offline Member
    Join Date
    Sep 2000
    Posts
    155

    If TNS_ADMIN does not exist in the environment, what is the order in which Oracle looks for TNSNAMES.ora file?

    I have 3 versions (7.3.4, 8.1.6, 8.1.7)of Oracle on SunSolaris8 server. If I set ORACLE_HOME and PATH env. variables to 8.1.7 version and not set TNS_ADMIN, what is the order in which Oracle looks for TNSNAMES.ora file?

    Any ideas???
    Reply With Quote Reply With Quote
  2. 02-08-2002, 01:11 PM #2
    Shestakov
    Shestakov is offline Senior Advisor
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    in my experiance Oracle try to find tnsnames.ora in order:

    - current directory
    - PATH directories
    - $ORACLE_HOME/network/admin.
    Reply With Quote Reply With Quote
  3. 02-08-2002, 01:41 PM #3
    rpardip
    rpardip is offline Member
    Join Date
    Sep 2000
    Posts
    155
    Well...in my case, it not looking in $ORACLE_HOME/network/admin.

    If I use TNS_ADMIN, then it is using the file from $ORACLE_HOME/network/admin. Is this due to multiple versions of Oracle under different Oracle homes?

    I am setting the appropriate ORACLE_HOME, ORACLE_SID
    and it should pick up the right tnsnames.ora file even though TNS_ADMIN is not set???
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width