2020. 2. 18. 23:58ㆍ카테고리 없음
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 = (ADDRESSLIST = (ADDRESS = (COMMUNITY =.) (PROTOCOL = TCP) (Host =.) (Port = 1521))) (CONNECTDATA = (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 meD: Oracle 10.2.0DB 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.0DB network admin sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx )(PORT = 1521)) (CONNECTDATA = (SERVER = DEDICATED) (SERVICENAME = ORCL))) OK (40 msec) C: Documents and Settings metnsping 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.0Client network admin sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESSLIST = (ADDRESS = (PROTOCOL = TCP) (HOST = XXXX)(PORT = 1521))) (CONNECTDATA = (SERVICENAME = 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 TNSADMIN variable is the only way to ensure you're getting a consistent tnsnames.ora file.
Configure Tnsnames Ora In Client
(NOTE: Windows-centric answer). By default, tnsnames.ora is located in the $ORACLEHOME/network/admin directory on UNIX operating systems and in the ORACLEHOME network admin directory on Windows operating systems. Tnsnames.ora can also be stored the following locations: The directory specified by the TNSADMIN environment variable (or registry value) On UNIX operating systems, the global configuration directory.
Multiple Tnsnames Ora Files
For example, on the Solaris Operating System, this directory is /var/opt/oracle If you have multiple ORACLEHOMES, be aware of which one you are using, as the location of the tnsnames.ora file can vary from one ORACLEHOME to the next. For the person who mentioned the TWOTASK 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 TWOTASK to is then looked up in the tnsnames.ora file when you connect.