Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Howto check which init.ora file the instance is using ?
"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 - 10:07:49 CDT