| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DB startup question - PLEASE READ FOR ANSWER!
--0-1651520708-978982754=:75654
Content-Type: text/plain; charset=us-ascii
Hi Gang,
If you run the command:
SQL> show parameters
as system. In the output you should see a record that looks something like this:
NAME TYPE VALUE ------------------------------------ ------- ------------------------------ ifile file /ptcmetde/pfile/configPTCMETDE.oraThis is the init file the database ACTUALLY read during startup. HTH,
Kevin Kostyszyn <kevin_at_dulcian.com> wrote:
If you are doing it manually, don't you path out the pfile? Kev
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jacques Kilchoer
Sent: Monday, January 08, 2001 1:11 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DB startup question
> > -----Original Message-----
> > From: andrey [SMTP:bronfin_at_visualtop.com]
> >
> > How can i find out which init.ora file was used for DB startup ?
I've read several answers mentioning the dbs directory or other OS directories to check for the init file.
How do you tell which init file was used to start the database when "startup pfile=" is used?
Jacques R. Kilchoër
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen
<P>Hi Gang, <P>If you run the command: <P>SQL> show parameters <P>as system. In the output you should see a record that looks something like this: <P>NAME TYPE VALUE<BR>------------------------------------ ------- ------------------------------ <BR>ifile file /ptcmetde/pfile/configPTCMETDE.ora <P>This is the init file the database ACTUALLY read during startup. <P>HTH, <P>-Rocky <P> <P> <B><I>Kevin Kostyszyn <kevin_at_dulcian.com></I></B> wrote: <BR> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR> <META content="MSHTML 5.50.4207.2601" name=GENERATOR><BR> <DIV><SPAN class=562244618-08012001><FONT face=Arial color=#0000ff size=2>If you are doing it manually, don't you path out the pfile?</FONT></SPAN></DIV><BR> <DIV><SPAN class=562244618-08012001><FONT face=Arial color=#0000ff size=2>Kev</FONT></SPAN></DIV><BR> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"><BR> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Jacques Kilchoer<BR><B>Sent:</B> Monday, January 08, 2001 1:11 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: DB startup question<BR><BR></FONT></DIV><BR> <P><FONT size=2>> > -----Original Message-----</FONT> <BR><FONT size=2>> > From: andrey [SMTP:bronfin_at_visualtop.com]</FONT> <BR><FONT size=2>> > </FONT><BR><FONT size=2>> > How can i find out which init.ora file was used for DB startup ?</FONT> </P><BR> <P><FONT size=2>I've read several answers mentioning the dbs directory or other OS directories to check for the init file.</FONT> </P><BR> <P><FONT size=2>How do you tell which init file was used to start the database when "startup pfile=" is used?</FONT> </P><BR> <P><FONT size=2>Jacques R. Kilchoër</FONT> <BR><FONT size=2>(949) 754-8816</FONT> <BR><FONT size=2>Quest Software, Inc.</FONT> </P><BR> <P><FONT size=2>8001 Irvine Center Drive</FONT> <BR><FONT size=2>Irvine, California 92618</FONT> <BR><FONT size=2>U.S.A.</FONT> <BR><FONT size=2><A target=_blank href="http://www.quest.com/">http://www.quest.com</A></FONT> </P></BLOCKQUOTE></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> -Received on Mon Jan 08 2001 - 13:39:14 CST
 |
 |