RE: DB startup question

And if I used "startup open pfile = /tmp/andrey/init.ora" for booting the DB ?
How do i discover it ?
Thanks a lot in advance !

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Armstead, Michael A
Sent: Mon, January 08, 2001 5:11 PM
To: Multiple recipients of list ORACLE-L Subject: RE: DB startup question

Look in your $ORACLE_HOME/dbs (or $ORACLE_HOME\dbs in NT) directory for the initSID.ora file where SID is the sid of the database you are connected to. That file should be the one you want.

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo SmithKline

> -----Original Message-----
> From: andrey [SMTP:bronfin_at_visualtop.com]
> Sent: Monday, January 08, 2001 9:01 AM
> To: Multiple recipients of list ORACLE-L
> Subject: DB startup question
>
> Dear DBAs !
>
> How can i find out which init.ora file was used for DB startup ?
>
> Thanks a lot in advance .
>
> Andrey .
>
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Armstead, Michael A
  INET: maa25681_at_GlaxoWellcome.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).