RE: DB startup question - PLEASE READ FOR ANSWER!

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Mon, 8 Jan 2001 15:22:54 -0500
Message-Id: <10735.126054@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_002B_01C07986.DF244A90 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

RE: DB startup question - PLEASE READ FOR ANSWER!I tried this, but what to I query v$parameter for. If I try to get the value of ifile it gives me nothing, am I missing something here?
Kev
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jacques Kilchoer
  Sent: Monday, January 08, 2001 3:14 PM   To: Multiple recipients of list ORACLE-L   Subject: RE: DB startup question - PLEASE READ FOR ANSWER!

>-----Original Message-----
>From: Rocky Welch [mailto:rockyw_99_at_yahoo.com]
>Sent: lundi, 8. janvier 2001 11:41
>
>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       p;                         file

/ptcmetde/pfile/configPTCMETDE.ora
>This is the init file the database ACTUALLY read during startup.

Actually, that shows you the value of the "ifile=" parameter included in your pfile (if you have such a parameter set), not the init file itself. Of course if it's important to know the name of the init file after the database has been started, then one could put all the values in the ifile, have the pfile include only the "ifile=" parameter, and then query v$parameter to see the ifile.

  Jacques R. Kilchoër
  (949) 754-8816
  Quest Software, Inc.

  8001 Irvine Center Drive
  Irvine, California 92618
  U.S.A.
  http://www.quest.com

------=_NextPart_000_002B_01C07986.DF244A90 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>RE: DB startup question - PLEASE READ FOR = ANSWER!</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1">

<META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D312242220-08012001><FONT face=3DArial color=3D#0000ff =

size=3D2>I=20
tried this, but what to I query v$parameter for.  If I try to get = the value=20
of ifile it gives me nothing, am I missing something = here?</DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2>Kev</DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft>-----Original Message----- From: root_at_fatcity.com=20 [mailto:root_at_fatcity.com]On Behalf Of Jacques = Kilchoer Sent:=20
 Monday, January 08, 2001 3:14 PM To: Multiple recipients of = list=20
 ORACLE-L Subject: RE: DB startup question - PLEASE READ FOR=20 ANSWER! </DIV>
 >-----Original Message----- <FONT=20 size=3D2>>From: Rocky Welch [<A=20
 =
href=3D"mailto:rockyw_99_at_yahoo.com">mailto:rockyw_99_at_yahoo.com</A>]</FONT= >=20
 >Sent: lundi, 8. janvier 2001 11:41 = <FONT=20
 size=3D2>> >If you run the command:=20 >SQL> show parameters <FONT =

size=3D2>>as system. In the output you should see a record that = looks=20
 something like this: <FONT=20 =
size=3D2>>NAME         &n= bsp;           &nb= sp;   =20
 TYPE    VALUE <FONT=20

  size=3D2>&gt;------------------------------------ -------=20
  ------------------------------ </FONT><BR><FONT=20

size=3D2>>ifile      =20 =
p;           &nbsp= ;            = =20
 file    /ptcmetde/pfile/configPTCMETDE.ora = <FONT=20
 size=3D2>>This is the init file the database ACTUALLY read during = startup.=20
 
 Actually, that shows you the value of the "ifile=3D" = parameter=20
 included in your pfile (if you have such a parameter set), not the = init file=20
 itself. Of course if it's important to know the name of the init file = after=20
 the database has been started, then one could put all the values in = the ifile,=20
 have the pfile include only the "ifile=3D" parameter, and then query = v$parameter=20
 to see the ifile.
 Jacques R. Kilcho=EBr (949) 754-8816=20
 Quest Software, Inc. 8001 Irvine Center Drive Irvine,=20
 California 92618 U.S.A. <A=20
 target=3D_blank =
href=3D"http://www.quest.com">http://www.quest.com</A>=20 Received on Mon Jan 08 2001 - 14:22:54 CST