Re: Oracle Net Configuration File Locations

You may want to look at this MOS Note

Search Order for TNS files - listener.ora, sqlnet.ora, tnsnames.ora ..etc. (Doc ID 464410.1)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/ Github: https://github.com/jkstill

On Wed, Nov 14, 2018 at 11:10 AM Dave <oracle_at_1001111.com> wrote:

> Hello All,
> I am sure others have experienced this issue.
>
> I have a fully patched 12.1.0.2 install running on Windows.
> The database and listener services start everything on boot.
>
> Unfortunately after the last OS patch the TNS_ADMIN variable
> got set pointing at the client side configuration files. There
> is no listener.ora in the client config files.
>
> lsnrctl status shows that the local listener.ora is being used:
>
> Listener Parameter File
> E:\Oracle\product\12.1.0.2\network\admin\listener.ora
>
> However, the sqlnet.ora file is being read from the TNS_ADMIN directory.
>
> We now understand how and why it is working but it caused a bunch of
> difficulties
> for a while. For the future:
>
> Is there an easy way to see the entire configuration file tree in lsnrctl?
> Is there an easy way to see the entire current configuration of the
> listener in lsnrctl?
>
> I know it is probably in ADR somewhere but I am hoping for a simpler way
>
> TIA
> Dave
>
> --
> Dave Morgan
> Senior Consultant, 1001111 Alberta Limited
> dave.morgan_at_1001111.com
> 403 399 2442
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l