On NT the default is $ORACLE_HOME/database
--
Terry Dykstra
Canadian Forest Oil Ltd.
"andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in message
news:988967500.3160.0.nnrp-01.c30bdde2_at_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" <matthias_at_reference.be> wrote in message
> news:3af13196$0$43047$456d72a3_at_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 ?
> >
> >
>
>
Received on Fri May 04 2001 - 09:58:03 CDT
