| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Client not using tnsnames.ora?
Scott,
Where on the client machine is the tnsnames.ora file? Probably is in the $ORACLE_HOME\NETWORK\ADMIN directory or maybe a network drive. Your home is probably c:\ora817 or maybe If you only changed the tnsnames.ora on the server side (i.e. prod), you will also need to update the tnanames.ora file on the client.
Good luck. (I'm sure you'll get it)
Stephen
>>> sstefick_at_harper.cc.il.us 10/04/02 03:33PM >>>
Hello all,
DB=8.1.7.4.0
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 ftst.harper.cc.il.us
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=prod)(PORT=1521))
and it should read:
C:\ tnsping ftst.harper.cc.il.us
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=dev)(PORT=1521))
Because the tnsnames.ora file reads:
FTST.HARPER.CC.IL.US =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ftst)
)
Please help a newbie!!!
Thanks so much in advance!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: sstefick_at_harper.cc.il.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: StephenAndert_at_firsthealth.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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 - 19:18:30 CDT
 |
 |