RE: listener.ora search order

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Mon, 23 Feb 2004 09:19:45 +1100
Message-ID: <DF33C5D0C428FE4DBC8410FC2793EE7F0141B9DD@calbbsv025.cal.riotinto.org>

Hi,
The listener on Windows with 81745 will certainly read from the = tns_admin env variable location.
That is the only location we have the listener.ora file.

The listener runs as a service though.
By any chance, have you set tns_admin env variable and not rebooted the = server since?
If so, the listener (like all services) would not be picking up the new = environment variable (as per recent info provided by Jared & others). One way around this would be to add a tns_admin string variable to the = relevant homes of your registry's Oracle branch.

If this is a machine that can be rebooted, reboot it and see where the = listener reads from them.

HTH,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au =20
NOTICE: This e-mail and any attachments are private and confidential and = may contain legally privileged information. If you are not an = authorised recipient, the copying or distribution of this e-mail and any = attachments is prohibited and you must not read, print or act in = reliance on this e-mail or attachments. This notice should not be = removed.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared Still Sent: Monday, 23 February 2004 4:59 AM

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=20 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=20 $ORACLE_HOME/network/admin/tnsnames.ora.

There's something similar in Win32, but I forget=20 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,=20 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,

>=20

> This is not a critical issue, but important for my understanding.

>=20

> 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

>=20

> 1.When I run 'lsnrctl start' command, it reads the
> d:\ora8i\network\admin\listener.ora file.

>=20

> 2.If I remove this file and run 'lsnrtctl start', it reads the
> 'd:\ora9i\network\admin\listerner.ora' file.

>=20

> 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.

>=20

> 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?

>=20

> Any ideas/suggestion please?

>=20

> Thanks and regards,
> Charu.

>=20

> PS: Can we not specify the path of listener.ora explicitly while
> running lsnrctl?

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
-----------------------------------------------------------------

Received on Sun Feb 22 2004 - 16:22:52 CST