| 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!
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C079B0.37FB63D0
Content-Type: text/plain;
charset="windows-1252"
Content-Transfer-Encoding: quoted-printable
Only if you use ifile command in your init.ora file.
Otherwise ifile has no value.
=20
Alex Hillman
-----Original Message-----
From: Rocky Welch [mailto:rockyw_99_at_yahoo.com]
Sent: Monday, January 08, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DB startup question - PLEASE READ FOR ANSWER!
Hi Gang,=20
If you run the command:=20
SQL> show parameters=20
as system. In the output you should see a record that looks something =
like
this:=20
NAME TYPE VALUE ------------------------------------ ------- = ------------------------------=20 ifile p; file/ptcmetde/pfile/configPTCMETDE.ora=20
This is the init file the database ACTUALLY read during startup.=20
HTH,=20 -Rocky=20
Kevin Kostyszyn <kevin_at_dulcian.com> wrote:=20
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-----=20 > > From: andrey [SMTP:bronfin_at_viisualtop.com]=20 > > =20 > > How can i find out which init.ora file was used for DB startup ?=20
I've read several answers mentioning the dbs directory or other OS directories to check for the init file.=20
How do you tell which init file was used to start the database when =
"startup
pfile=3D" is used?=20
Jacques R. Kilcho=EBr=20
(949) 754-8816=20
Quest Software, Inc.=20
8001 Irvine Center Drive=20
Irvine, California 92618=20
U.S.A.=20
http://www.quest.com <http://www.quest.com/> =20
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen=20
_____ =20
Do You Yahoo!?
Yahoo! Photos <http://photos.yahoo.com/> - Share your holiday photos
online!
------_=_NextPart_001_01C079B0.37FB63D0
Content-Type: text/html;
charset="windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D742501620-08012001>Only=20
if you use ifile command in your init.ora file.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D742501620-08012001>Otherwise ifile has no =
value.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D742501620-08012001></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D742501620-08012001>Alex=20
Hillman</SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Rocky Welch=20
[mailto:rockyw_99_at_yahoo.com]<BR><B>Sent:</B> Monday, January 08, 2001 =
2:41=20
PM<BR><B>To:</B> Multiple recipients of list =
ORACLE-L<BR><B>Subject:</B> RE:=20
DB startup question - PLEASE READ FOR ANSWER!<BR><BR></DIV></FONT>
<P>Hi Gang,=20 <P>If you run the command:=20 <P>SQL> show parameters=20 <P>as system. In the output you should see a record that looks =something like=20
TYPE VALUE<BR>------------------------------------ =-------=20
------------------------------=20
<P>This is the init file the database ACTUALLY read during startup.=20 <P>HTH,=20 <P>-Rocky=20 <P>=20 <P> <B><I>Kevin Kostyszyn <kevin_at_dulcian.com></I></B> =wrote: <BR>
<META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR><BR> <DIV><SPAN class=3D562244618-08012001><FONT color=3D#0000ff = face=3DArial size=3D2>If=20
you are doing it manually, don't you path out the=20
pfile?</FONT></SPAN></DIV><BR>
<DIV><SPAN class=3D562244618-08012001><FONT color=3D#0000ff =
face=3DArial=20
size=3D2>Kev</FONT></SPAN></DIV><BR> <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"><BR> <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> = root_at_fatcity.com=20
[mailto:root_at_fatcity.com]<B>On Behalf Of </B>Jacques=20
Kilchoer<BR><<B>Sent:</B> Monday, January 08, 2001 1:11=20
PM<BR><B>To:</B> Multiple recipients of list =
ORACLE-L<BR><B>Subject:</B>=20
RE: DB startup question<BR><BR></FONT></DIV><BR>
<P><FONT size=3D2>> > -----Original Message-----</FONT> =
<BR><FONT=20
size=3D2>> > From: =
andrey=20
[SMTP:bronfin_at_viisualtop.com]</FONT> <BR><FONT size=3D2>> =
> =20
</FONT><BR><FONT size=3D2>> > How can i find out which =
init.ora file=20
was used for DB startup ?</FONT> </P><BR>
<P><FONT size=3D2>I've read several answers mentioning the dbs =
directory or=20
other OS directories to check for the init file.</FONT> </P><BR>
<P><FONT size=3D2>How do you tell which init file was used to =
start the=20
database when "startup pfile=3D" is used?</FONT> </P><BR>
<P><FONT size=3D2>Jacques R. Kilcho=EBr</FONT> <BR><FONT =
size=3D2>(949)=20
754-8816</FONT> <BR><FONT size=3D2>Quest Software, Inc.</FONT> =
</P><BR>
<P><FONT size=3D2>8001 Irvine Center Drive</FONT> <BR><FONT =
size=3D2>Irvine,=20
California 92618</FONT> <BR><FONT size=3D2>U.S.A.</FONT> =
<BR><FONT size=3D2><A=20
href=3D"http://www.quest.com/" =
target=3D_blank>http://www.quest.com</A></FONT>=20
</P></BLOCKQUOTE></BLOCKQUOTE><BR><BR>Rocky Welch<BR>Senior =
Consultant -=20
 |
 |