Message-Id: <10735.126054@fatcity.com> From: "Kevin Kostyszyn" Date: Mon, 8 Jan 2001 15:22:54 -0500 Subject: RE: DB startup question - PLEASE READ FOR ANSWER! 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@fatcity.com [mailto:root@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@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 RE: DB startup question - PLEASE READ FOR = ANSWER!
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?
Kev
-----Original Message-----
From: root@fatcity.com=20 [mailto:root@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!

>-----Original Message-----
>From: Rocky Welch [mailto:rockyw_99@yahoo.com]=20
>Sent: lundi, 8. janvier 2001 11:41 =
>
>If you run the command:=20
>SQL> show parameters
>as system. In the output you should see a record that = looks=20 something like this:
>NAME         &n= bsp;           &nb= sp;   =20 TYPE    VALUE
>------------------------------------ -------=20 ------------------------------
>ifile      =20 = p;            = ;            = =20 file    /ptcmetde/pfile/configPTCMETDE.ora =
>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.
http://www.quest.com=20