That's not good enough. The ifile is not the same as the pfile. It would
only work if the only line in the pfile would be:
ifile=.....
--
Terry Dykstra
Canadian Forest Oil Ltd.
"fumi" <fumi_at_tpts5.seed.net.tw> wrote in message
news:9d932q$2ed$3_at_news.seed.net.tw...
>
> "Ketan Shah" <shahkn_at_home.com> ¼¶¼g©ó¶l¥ó
> news:pQ3J6.50476$B22.12668504_at_news1.rdc2.pa.home.com...
> > in svrmgr do show parameter all. It should show an entry for PFILE and
this
> > is the one which is being used. Also check v$parameter table.
> >
> > "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 ?
>
>
> The "show parameter all" doesn't show it. Use "show parameter ifile"
instead.
> It can be found in v$parameter:
>
> select value from v$parameter where name='ifile';
>
> It's funny that, it shows null in my Oracle8.1.6 EE on Windows 2k,
> if the database autostart at Windows startup.
> If I restartup using svrmgrl, it shows a value.
>
>
>
>
>
>
Received on Tue May 08 2001 - 12:22:04 CDT
