RE: DB startup question - PLEASE READ FOR ANSWER!

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Mon, 8 Jan 2001 14:06:51 -0600
Message-Id: <10735.126040@fatcity.com>

Hi,
 That is if you have 'ifile' specified in the initSID.ora file to start with.=20
  If not, the value in the following query would be null.=20 =20
- Kirti

> -----Original Message-----
> From:	Rocky Welch [SMTP:rockyw_99_at_yahoo.com]
> Sent:	Monday, January 08, 2001 1:41 PM
> To:	Multiple recipients of list ORACLE-L
> Subject:	RE: DB startup question - PLEASE READ FOR ANSWER!

>=20

> Hi Gang,=20

>=20

> If you run the command:=20

>=20

> SQL> show parameters=20

>=20

> as system. In the output you should see a record that looks something = like

> this:=20


>=20

> NAME                          TYPE    VALUE
> ------------------------------------ -------
> ------------------------------=20
> ifile      &nbspp;                         file
> /ptcmetde/pfile/configPTCMETDE.ora=20

>=20

> This is the init file the database ACTUALLY read during startup.=20

>=20

> HTH,=20

>=20

> -Rocky=20

>=20

>  =20

>=20

>   Kevin Kostyszyn <kevin_at_dulcian.com> wrote:=20

>=20
>=20
>=20
>=20

> 	If you are doing it manually, don't you path out the pfile?


>=20

> 	Kev

>=20
>=20
>=20

> 		-----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
> 	=09
> 	=09

>=20
>=20

> 		> > -----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

>=20
>=20

> 		I've read several answers mentioning the dbs directory or
> other OS directories to check for the init file.=20

>=20
>=20

> 		How do you tell which init file was used to start the
> database when "startup pfile=3D" is used?=20

>=20
>=20

> 		Jacques R. Kilcho=EBr=20
> 		(949) 754-8816=20
> 		Quest Software, Inc.=20

>=20
>=20

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

>=20
>=20
>=20

> Rocky Welch
> Senior Consultant - Internet Services Group
> Arthur Andersen

>=20
>=20
>=20

>   _____ =20

>=20

> Do You Yahoo!? Received on Mon Jan 08 2001 - 14:06:51 CST