Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: listener.ora search order
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
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
-- 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