Re: init.ora

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 <jonw_at_fuse.net> 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" <ORACLE-L_at_fatcity.com>
> 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: prasadm_g_at_yahoo.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).

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jon Walthour
> INET: jonw_at_fuse.net

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
  INET: rodney.holman_at_lodgenet.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).