RE: DB startup question

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Mon, 8 Jan 2001 14:49:28 -0500
Message-Id: <10735.126039@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0021_01C07982.336D14B0 Content-Type: text/plain;

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

RE: DB startup questionOk, now I get it. Well I would assume you could get it from "show parameters" or depending on the size of the shop and how many people have the rights to start the database.......now this is going to sound really stupid and I don't want it to come out the wrong way......write it down somewhere.. The only reason I guess that I could say this is because I work in such a small shop, so I could literally just leave a note on the monitor or in some designated area telling the other DBA's which init file I used. But, yeah, I guess the more technical way would be to use the show parameters.
Have a good one
Kev
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jacques Kilchoer
  Sent: Monday, January 08, 2001 2:34 PM   To: Multiple recipients of list ORACLE-L   Subject: RE: DB startup question

My question:
>How do you tell which init file was used to start the database when "startup pfile=" is used?

Kevin's reply:

  >-----Original Message-----
  >From: Kevin Kostyszyn [mailto:kevin_at_dulcian.com]
  >Sent: lundi, 8. janvier 2001 11:04
  >
  >If you are doing it manually, don't you path out the pfile?

Sure, but suppose I call in sick due to weltschmerz or ennui the next day, and my colleague wants to know which pfile I used to startup the database the day before? e.g. we have different pfiles we employ depending on the type of tasks for which the database will be used. The only method I know is to view the parameters and compare them to the various pfiles (assuming none of the parameters have been changed since the database was restarted).

------=_NextPart_000_0021_01C07982.336D14B0 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</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>Ok,=20
now I get it.  Well I would assume you could get it from "show = parameters"=20
or depending on the size of the shop and how many people have the rights = to=20
start the database.......now this is going to sound really stupid and I = don't=20
want it to come out the wrong way......write it down=20 somewhere..    The only reason I guess that I could say = this is=20
because I work in such a small shop, so I could literally just leave a = note on=20
the monitor or in some designated area telling the other DBA's which = init file I=20
used.  But, yeah, I guess the more technical way would be to use = the show=20
parameters.  </DIV>
<DIV>Have a=20
good one</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 2:34 PM To: Multiple recipients of = list=20
 ORACLE-L Subject: RE: DB startup = question </DIV>
 My question: >How do = you tell which=20
 init file was used to start the database when "startup pfile=3D" is = used?=20
 
 Kevin's reply: >-----Original=20
 Message----- >From: Kevin Kostyszyn [<A=20 href=3D"mailto:kevin_at_dulcian.com">mailto:kevin_at_dulcian.com</A>] =
 <FONT=20

 size=3D2>>Sent: lundi, 8. janvier 2001 11:04 <FONT=20 size=3D2>> >If you are doing it = manually, don't=20
 you path out the pfile? Sure, but suppose I call in sick due to weltschmerz = or ennui=20
 the next day, and my colleague wants to know which pfile I used to = startup the=20
 database the day before? e.g. we have different pfiles we employ  =

  depending on the type of tasks for which the database will be used. = The only=20
  method I know is to view the parameters and compare them to the = various pfiles=20
  (assuming none of the parameters have been changed since the database = Received on Mon Jan 08 2001 - 13:49:28 CST