| 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: listener.ora search order
Without actually reading the manual and doing any
research ( it is Sunday morning, and I don't feel
like doing any ) I would say this is to be expected.
tnsnames.ora is used to resolve instance locations on a network. It doesn't really matter which version of client you are using, you want it to follow a certain search order.
On *nix it looks in $HOME/.tnsnames.ora, and then in $TNS_ADMIN/tnsnames.ora, and then in $ORACLE_HOME/network/admin/tnsnames.ora.
There's something similar in Win32, but I forget the location details for the $HOME equiv.
Listener on the other hand should run the listener.ora from the current Oracle home. You could conceivably have several different versions of listener running, each from a different Oracle home.
tnsnames.ora is used to lookup names, listener.ora is used to control the daemon that creates connections to the database. Quite a difference between the two.
I'll leave it to you to verify if this is correct from the fine manual.
Jared
On Sat, 2004-02-21 at 02:46, Charu Joshi wrote:
> Hi,
>
> This is not a critical issue, but important for my understanding.
>
> OS: NT4
> Multiple Homes: ora_8i_home (d:\ora8i), ora_9i_home(d:\ora9i), and
> 2 others..
> Selected Home: ora_8i_home
> TNS_ADMIN environment variable: d:\ora9i\network\admin
>
> 1.When I run 'lsnrctl start' command, it reads the
> d:\ora8i\network\admin\listener.ora file.
>
> 2.If I remove this file and run 'lsnrtctl start', it reads the
> 'd:\ora9i\network\admin\listerner.ora' file.
>
> In both the above cases, the TNSNames.ora files is read from the
> %TNS_ADMIN% location, but evidently not listerner.ora. Why? It
> seems that lsnrctl is searching in each Oracle Home for
> listerner.ora (as per registry order) and uses the first one that
> it finds.
>
> There used to be a 7.3.4 client installation on my machine, which
> I removed as per metalink note 73963.1, so that there is no
> DEFAULT_HOME at present. After this, I found that another home
> DEFAULT_HOME1 was automatically added to registry with the same
> path as that of the earlier DEFAULT_HOME. Could this have
> something to do with the anamoly?
>
> Any ideas/suggestion please?
>
> Thanks and regards,
> Charu.
>
> PS: Can we not specify the path of listener.ora explicitly while
> running lsnrctl?
>
> *********************************************************
> Disclaimer
>
> This message (including any attachments) contains
> confidential information intended for a specific
> individual and purpose, and is protected by law.
> If you are not the intended recipient, you should
> delete this message and are hereby notified that
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it,
> is strictly prohibited.
>
> *********************************************************
> Visit us at http://www.mahindrabt.com
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Sun Feb 22 2004 - 11:51:16 CST
 |
 |