I know I'm getting old.

I used to know how to determine Oracle's search path to the
listener.ora file but I've forgotten.

The other day, while working with a client, I discovered (through
LSNRCTL) that the parameter file being used was /etc/listener.ora and
we had been looking at $ORACLE_HOME/network/admin/listener.ora. My
suggested solution was to redirect the listener to read the one in the
Oracle path, but I couldn't remember how. Doh!

On Wed, 2 Jul 2003 14:24:32 GMT, Brian Peasland
<oracle_dba@remove_spam.peasland.com> wrote:

>Oracle will use the directory specified in your TNS_ADMIN environment
>variable first. After that, it will look in $ORACLE_HOME/network/admin.
>
>HTH,
>Brian


don't think so

1 the current directory
2 the TNS_ADMIN directory
3 the /var/opt/oracle directory (Solaris) or /etc (all other Unixes)
4 $ORACLE_HOME/network/admin

It will definitely look in /etc *before* $ORACLE_HOME/network/admin.
Why do you think the OP ran into trouble?


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

>
>1 the current directory
>2 the TNS_ADMIN directory
>3 the /var/opt/oracle directory (Solaris) or /etc (all other Unixes)
>4 $ORACLE_HOME/network/admin

I agree with Brian, the TNS_ADMIN environment has priority. On Windows
the environment variable will take priority over a registry TNS_ADMIN
entry. I think only SQL*PLus will use tnsname.ora in the current
directory.

Daniel.