oracle中tns名称,Oracle - 我正在使用哪些TNS名称文件？

Codeslave问：“它不应该总是”$ ORACLE_ HOME/network/admin/tnsnames.ora“吗？答案是否定的，不是，请考虑在同一台机器上进行两次tnsping调用：

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>请注意两个不同的参数文件位置，这取决于您正在运行哪个tnsping可执行文件(以及可能在哪里运行)。对于基于tnsnames的oracle网络，使用TNS_ADMIN变量是确保获得一致的tnsnames.ora文件的唯一方法。 (注意：以Windows为中心的答案)