Oracle Training from Don Burleson The best on site ' ' are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop! Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise.

This page discusses running multiple releases of Oracle client software on your PC and why you may find yourself with several tnsnames.ora files. If we allowed simultaneous editing of multiple files within a. TOAD's TNS Names editor has two sides so that two tnsnames.ora files can be. Toad for Oracle.

All legitimate Oracle experts publish their. Oracle technology is changing and we strive to update our BC Oracle support information. Download Free Candy Wrapper Template Hershey Nuggets Bulk. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. Burleson Consulting The Oracle of Database Support Copyright © 1996 - 2017 All rights reserved by Burleson Oracle ® is the registered trademark of Oracle Corporation. Remote Emergency Support provided.

Oracle provides a utility called tnsping: R: >tnsping someconnection TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 27-AUG-20 08 10:38:07 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: C: Oracle92 network ADMIN sqlnet.ora C: Oracle92 network ADMIN tnsnames.ora TNS-03505: Failed to resolve name R: >R: >tnsping entpr01 TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 27-AUG-20 08 10:39:22 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: C: Oracle92 network ADMIN sqlnet.ora C: Oracle92 network ADMIN tnsnames.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = **) (PROTOCOL = TCP) (Host = ****) (Port = 1521))) (CONNECT_DATA = (SID = ENTPR0 1))) OK (40 msec) R: >This should show what file you're using.

The utility sits in the Oracle bin directory. Codeslave asks 'Shouldn't it always be '$ORACLE_ HOME/network/admin/tnsnames.ora'? The answer is no, it isn't. Consider these two invocations of tnsping on the same machine: C: Documents and Settings me>D: Oracle 10.2.0_DB BIN tnsping orcl TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 09-OCT-2 008 14:30:12 Copyright (c) 1997, 2007, Oracle. All rights reserved. Used parameter files: D: Oracle 10.2.0_DB network admin sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL))) OK (40 msec) C: Documents and Settings me>tnsping orcl TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 09-OCT-2 008 14:30:21 Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files: D: oracle 10.2.0_Client network admin sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = XXXX)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL))) OK (20 msec) C: Documents and Settings me>Note the two different parameter file locations, that are dependent on which tnsping executable you're running (and perhaps where it's being run from). For tnsnames-based oracle networking, using the TNS_ADMIN variable is the only way to ensure you're getting a consistent tnsnames.ora file.

(NOTE: Windows-centric answer). By default, tnsnames.ora is located in the $ORACLE_HOME/network/admin directory on UNIX operating systems and in the ORACLE_HOME network admin directory on Windows operating systems. Tnsnames.ora can also be stored the following locations: The directory specified by the TNS_ADMIN environment variable (or registry value) On UNIX operating systems, the global configuration directory. For example, on the Solaris Operating System, this directory is /var/opt/oracle If you have multiple ORACLE_HOMES, be aware of which one you are using, as the location of the tnsnames.ora file can vary from one ORACLE_HOME to the next. For the person who mentioned the TWO_TASK environment variable, that is used to set a default database service name to connect to (which could be a database on another server).

The service name you set TWO_TASK to is then looked up in the tnsnames. Bahramji Flying Carpet. ora file when you connect.