Message-Id: <10735.125972@fatcity.com>
From: Rocky Welch <rockyw_99@yahoo.com>
Date: Mon, 8 Jan 2001 06:51:29 -0800 (PST)
Subject: 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@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


---------------------------------
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
--0-1348282449-978965489=:25668
Content-Type: text/html; charset=us-ascii

<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>&nbsp; <B><I>andrey &lt;bronfin@visualtop.com&gt;</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&nbsp;DBAs !</SPAN></FONT></DIV><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001></SPAN></FONT>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</DIV><BR>
<DIV><FONT face=Arial size=2><SPAN class=771190314-08012001></SPAN></FONT>&nbsp;</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!