Re: using ifile in the tnsnames.ora file

On 2/8/07, Jacques Kilchoer <Jacques.Kilchoer@xxxxxxxxx> wrote:




Do you use an IFILE parameter in a network configuration file (tnsnames.ora,
sqlnet.ora, other) to consolidate entries  in a central location? I guess
it's an obsolete practice and I should stop.

I've been using IFILE parametes in the tnsnames.ora file for as long as I've
been using Oracle. Recently however, when creating database links, I noticed
that the database link was using an alias that is coming from an "ifile" in
the tnsnames.ora, even though SQL*Plus on the server could use that entry.
I've never had problems using an IFILE in the tnsnames.ora except the one I
recently encountered with database links.

Imagine my surprise when I saw this on Tom Kyte's website:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:489021635775

Quoter: "IFILE is not supported for
tnsnames/listener/sqlnet/protocol.ora files."


Interesting, but I think wrong, certainly the E-Business Suite -
including according to the notes the just released version 12 - uses
ifiles. Now I know that the support arrangements for ebs are a little
different, but I find it hard to believe that particular statement in
the light of the way ebs works.


--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l

Other related posts: