The E Business Suite as far as I can recall at least with 11i has always used the ifile parameter. There is a tool called autoconfig which allows you to manage your 11i installation. Running this tool would typically wipe out any entires one has entered into these files, the ifile allows you to make your changes persistent, through autoconfig runs.
----- Original Message ----
From: Jacques Kilchoer <Jacques.Kilchoer@quest.com>
To: oracle-l <oracle-l@freelists.org>
Sent: Saturday, 10 February, 2007 1:07:34 AM
Subject: RE: using ifile in the tnsnames.ora file
Stefan - thank you for
the information; I'll try your suggestion about bouncing the database to see if
that gets the database links to work when the tnsnames.ora contains an
ifile.
Niall - did you just
suggest that Tom Kyte was *gasp* wrong?!? Perhaps the E-business suite is using
an unsupported feature of Oracle - "we'll use it ourselves because we know the
gotchas but we won't let you, the customer, play around with it on your own."
Does the E-business documentation actually tell the customer to set up a common
network configuration file using ifile? Or do they install one on your machine
but leave it unmentioned in the documentation?
Thomas Mercadante - I
agree with you that it's a pain to have to go digging through several files when
you find a configuration file with an "ifile" parameter. But, for example, what
if you have several oracle homes on the same machine, and want to make sure that
all SQL*Net or listener log and trace files end up in the same directory? What I
do is put the DIRECTORY parameter in a common file (pulled in through an ifile)
and give each log / trace file a name that is version specific in the individual
sqlnet.ora file for each version. Or for example the specification of the names
server can be in the common sqlnet.ora file. That seems to me "simple and clear"
- some changes only need to be made in one location.
As far as tnsnames.ora
goes, setting up a names server or an LDAP server is probably best practice - I
do that here. But in the old days before names servers the ifile = in your
tnsnames.ora file was the way to go. Old habits die
hard.
___________________________________________________________
What kind of emailer are you? Find out today - get a free analysis of your email personality. Take the quiz at the Yahoo! Mail Championship.
http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 10 2007 - 03:34:40 CST
