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
Title: RE: Client not using tnsnames.ora?
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
Dont forget the .tnsnames.ora (private tnsnames.ora).
joe
Jacques Kilchoer wrote:
RE: Client not using tnsnames.ora?
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
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