Client not using tnsnames.ora?

2002-10-04 Thread Scott Stefick
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

RE: Client not using tnsnames.ora?

2002-10-04 Thread Jacques Kilchoer
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

Re: Client not using tnsnames.ora?

2002-10-04 Thread Joe Testa
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

Re: Client not using tnsnames.ora?

2002-10-04 Thread Stephen Andert
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