This won't tell you of aditional config files (referenced using ifile= in
you init file) but it will tell you the primary file.
select * from v$parameter where name = 'ifile';
Rodd Holman
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 7/23/01, 6:35:50 AM, Jon Walthour <[EMAIL PROTECTED]> wrote regarding Re:
init.ora:
> Prasad:
> There is no way to tell from inside Oracle exactly what init.ora you used
to
> start the db up with. By default, it uses the one pointed to by the
> symlink/ifile in $ORACLE_HOME/dbs, but if you start up the db with the
> pfile= parameter (as in, startup pfile=some_other_init.ora), then there's
no
> way to know other than knowing what parameters are different between the
two
> init.ora files and querying sys.v_$parameter to check those differences.
> Jon Walthour
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, July 23, 2001 5:20 AM
> > hi dbas
> >
> > is there anyway to see
> >
> > using what init.ora file i start my instance/db
> >
> > bcoz i hv somany init files in the same dir.
> >
> > they have same parameters. i forgot to remember what
> > init file i used to start the db.
> >
> > can it be found from any table/or anyother source?
> >
> > prasad
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Make international calls for as low as $.04/minute with Yahoo! Messenger
> > http://phonecard.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: prasad maganti
> > INET: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jon Walthour
> INET: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
