Re: What initialize file am I using

If the two init.ora files have any differences you're all set. Go into SQL*Plus and issue a show parameters command. Then match the results to your init ora files to see which one was used when the database was started.

Van

"Mo" <ranamo_at_mailbox.bellatlantic.net> wrote in message news:3A86C67D.AD6CF197_at_mailbox.bellatlantic.net...
> Hi Daniel
>
> Here's the situation, you have 2 init files in the same directory with
> different names,
> which one Oracle uses when NT started??
>
> is searching the registry would be the only way to know?? and how would I
> know if some
> file did not override the registry setting??
>
> The only way to be for sure, so far, is shutting down the database and
> starting it with a specific
> init file.
>
> So, my question is there any view or something from inside Oracle where
 you
> can query and get
> the init file that one specific instance is using.
>
> Thanks
> Mo
>
> > Mo,
> >
> > The init file being used should be in $ORACLE_HOME/dbs if you're on
 unix,
> > identified by init{SID}.ora.
> > If you're on a windows platform, do a find on 'init*.ora'.
> >
> > "Mo" <ranamo_at_mailbox.bellatlantic.net> wrote in message
> > news:3A86B368.7C6FA659_at_mailbox.bellatlantic.net...
> > > How I can know what initialize file the specific instanse is using????
> > >
> > > Thanks
> > > Mo
> > >
>
Received on Sun Feb 11 2001 - 11:22:42 CST