Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Client not using tnsnames.ora?

RE: Client not using tnsnames.ora?

From: Jacques Kilchoer <>
Date: Fri, 04 Oct 2002 15:13:18 -0800
Message-ID: <>

Do you have several Oracle Homes on the client? If so you need to modify the tnsnames.ora in each
%ORACLE_HOME%/network/admin directory.
Do you have any tnsnames.ora files outside the %ORACLE_HOME%/network/admin directory?
If I remember right, the search order is: a) use tnsnames.ora in the current directory of the executable b) use tnsnames.ora in the directory specified by the TNS_ADMIN environment variable
c) use tnsnames.ora in %ORACLE_HOME%/network/admin

Is the alias specified more than once in the tnsnames.ora? Each alias should only be defined once. (search for FTST.HARPER.CC.IL.US in the tnsnames.ora file).
Does the tnsnames.ora file contain an "ifile=" parameter including entries from another file?

> -----Original Message-----
> From: Scott Stefick []
> DB=
> DB Server OS=HPUX 11i
> Client: Windows NT 4.0
> I have 3 Oracle instances that were installed on one machine
> "prod". They
> are FPRD, FTRN and FTST. I moved FTST to a different machine
> "dev". I
> changed the tnsnames.ora files on the clients and the servers, and I
> changed the listener.ora on the servers.
> Now I cannot connect to the FTST instance on the "dev"
> machine from the
> clients. The TNS_ADMIN env variable is not set either. I
> tried to set it
> on one of the clients and it broke all of the other
> instances. When I do a
> TNSPING from the clients, it still shows that the client is trying to
> connect to the "prod" machine even though the tnsnames.ora
> file on the
> client is pointing to "dev". I don't know where the client
> is getting that
> the FTST database is still located on "prod". I checked the
> sqlnet.ora
> file on the clients and servers and they all have
> "names.directory_path=(TNSNAMES)"
> The twist to all of this is that if I try to connect using
> sqlplus from
> "prod" to "dev" and vice versa, I can connect all day long
> with no problems
> at all. So that leads me to believe the issue lies on the
> Client side.
> Example:
> C:\ tnsping
> Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=prod)(PORT=1521))
> and it should read:
> C:\ tnsping
> Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=dev)(PORT=1521))
> Because the tnsnames.ora file reads:
> (ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1521))
> )
> (SERVICE_NAME = ftst)
> )
> )

Please see the official ORACLE-L FAQ:
Author: Jacques Kilchoer

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Oct 04 2002 - 18:13:18 CDT

Original text of this message