Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Howto check which init.ora file the instance is using ?

Re: Howto check which init.ora file the instance is using ?

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: Tue, 8 May 2001 23:07:49 +0800
Message-ID: <9d932q$2ed$3@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 - 10:07:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US