Re: Listener.ora and TNS_ADMIN

I think TNS_ADMIN is only used on the client side. I don't think it's used to find LISTENER.ORA. I believe the LISTENER.ORA file must reside in the <ORACLE_HOME>\network\admin directory.

Why are you bothering anyhow? Unless you have multiple versions of oracle you should only need one set of LISTENER.ORA, SQLNET.ORA files etc on your server. Everytime you create a new instance on your server, just edit the LISTENER.ORA file and add a new entry for it.

craig walters wrote:

> Hi all,
>
> I've recently had to install several more Oracle 7.3 instances on NT/Alpha.
> Usually, we point the TNS_ADMIN environment variable to point to a
> sub-directory other than the default \ORANT\NETWORK\ADMIN. The
> listener.ora, tnsnames.ora, and sqlnet.ora files are in this new directory.
> With these recent installs, have tnsnames.ora and sqlnet.ora in the new
> directory pointed to by TNS_NAMES works fine, but the listener.ora file is
> seen only in the default \ORANT\NETWORK\ADMIN directory.
>
> I've looked everywhere for why this is happening. It isn't keeping me from
> running the systems, but it is behavior that continues to irritate me. Can
> anyone shed any light why this is happening and where I might look to "fix"
> it?
>
> Many thanks for any help.
>
> Best regards,
> craig
Received on Sat Jul 18 1998 - 20:30:25 CDT