From: "Daniel A. Morgan" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: Howto check which init.ora file the instance is using ? Date: Fri, 04 May 2001 23:59:06 -0700 Organization: EXE Message-ID: <3AF3A4BA.134843E3@exesolutions.com> X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 References: <3af13196$0$43047$456d72a3@news.skynet.be> <988967500.3160.0.nnrp-01.c30bdde2@news.demon.co.uk> <%rzI6.17256$mg5.1753689@news1.telusplanet.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Cache-Post-Path: yabetcha.drizzle.com!unknown@win07.drizzle.com X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/) X-Complaints-To: newsabuse@supernews.com Lines: 44 Terry Dykstra wrote: > On NT the default is $ORACLE_HOME/database > > -- > Terry Dykstra > Canadian Forest Oil Ltd. > "andrew_webby at hotmail" wrote in message > news:988967500.3160.0.nnrp-01.c30bdde2@news.demon.co.uk... > > I think once the database is up, it closes any file handles to the init.ora. > > So no would be my guess. > > > > I 'validated' this theory by trying a 'fuser' on the init.ora. Of course, > > that doesn't mean it's held in a system view, but given files can reference > > others, I somehow doubt it... > > > > The default is in $ORACLE_HOME/dbs of course - unless you did a 'startup > > pfile=...'. > > > > "Matthias Hoys" wrote in message > > news:3af13196$0$43047$456d72a3@news.skynet.be... > > > How can I see which initialization.ora file a currently running instance is > > > using ? > > > Is there a system view to check this ? > > > > > > > > > > True: But that does not answer the poster's question. The database could have been started with any copy anywhere. In the Windows registry there is an key named ORA_oracle_PFILE that in the case of one of my NT Servers points to e:\oracle\ora81\admin\oracle\pfile\init.ora which is the location actually used when the database was created. If anyone has a "good" answer to this question please post it as this is one item that I have also wondered about for quite awhile. Daniel A. Morgan