Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What initialize file am I using
Thanks Van
That should do it but I thought may be there are some hidden view that newbie like me did not hear of yet.
Mo
> 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 - 14:18:36 CST