Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB startup question
--0-1348282449-978965489=:25668
Content-Type: text/plain; charset=us-ascii
Hi Andrey,
In sqlplus use the show parameters command and look for th ifile parameter.
HTH, -Rocky
andrey <bronfin_at_visualtop.com> wrote:
Dear DBAs !
How can i find out which init.ora file was used for DB startup ?
Thanks a lot in advance .
Andrey .
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen
<P> Hi Andrey,</P>
<P>In sqlplus use the show parameters command and look for th ifile parameter.</P>
<P>HTH,</P>
<P>-Rocky<BR></P>
<P> <B><I>andrey <bronfin_at_visualtop.com></I></B> wrote: <BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>
<META content="MSHTML 5.00.2920.0" name=GENERATOR><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001>Dear DBAs !</SPAN></FONT></DIV><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001></SPAN></FONT> </DIV><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001>How can i find out which init.ora file was used for DB startup ?</SPAN></FONT></DIV><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001></SPAN></FONT> </DIV><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001>Thanks a lot in advance .</SPAN></FONT></DIV><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001></SPAN></FONT> </DIV><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001>Andrey .</SPAN></FONT></DIV><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001></SPAN></FONT> </DIV><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001></SPAN></FONT> </DIV></BLOCKQUOTE><BR><BR>Rocky Welch<br>Senior Consultant - Internet Services Group<br>Arthur Andersen<p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://photos.yahoo.com/">Yahoo! Photos</a> -
Share your holiday photos online!
Received on Mon Jan 08 2001 - 08:51:29 CST
![]() |
![]() |