Re: multiple oracle_home question ?

Answer to this quiz question:
the tnsnames.ora on the pc.
The tnsnames.ora on the server is not used. This file is only used when connect from on a telnet session or any direct login on the server.
The usual solution here is make sure you have only one set (sqlnet.ora, listener.ora, tnsnames.ora) on the server in a non-version dependent directory. This is the /var/opt/oracle directory on Solaris and /etc on all other Unix-variants. Point your TNS_ADMIN environment variable to the /etc or /var/opt/oracle directory and you should be OK. If your Oracle 8 instance(s) is/are not in the listener.ora on the server, that's the reason you can not connect.

Hth,

Sybrand Bakker, Oracle DBA

tedchyn_at_yahoo.com wrote in message <7ibkuc$v42$1_at_nnrp1.deja.com>...
>Sir:
>
>I have oracle_home for 7 and 8(unix) and lisnter is running from
>oracle7_home. there are two tnsnames.ora for 7 and 8. when connecting
>via client side, I thought oracle7_home/network/tnsnames.ora is the one
>get used. I am able to connect to instance specified in
>oracle8_home/network/tnsnames.ora ?
>
>Which tnsnames.ora is used when connecting from pc client ?
>
>Thanks in advance( respond to tedchyn_at_yahoo.com)
>
>Ted Chyn
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Mon May 24 1999 - 09:20:25 CDT