Re: How do I find the init.ora file?

Jan,

I have searched and searched but did not find an answer to your question, at least not a documented way. I will keep looking when I have time but please keep me in mind and let me know if you find an answer.

Cliff

"Christian Wandrei" <Christian.Berlin_at_gmx.de> wrote in message news:3A3A579A.E60A1AA6_at_gmx.de...
> Hi Al,
>
> thank you very much for your answer. But these are only the default
> directories for the init.ora file. It is possible to start Oracle using an
> init.ora file in a different directory. If there are two files - one in
 the
> default directory and another one anywhere else - how do I find out which
> one was actually used when the instance was started.
>
> Best regards Jan Dieckmann
> (sorry for the incorrect email address. I use the pc of my friend
 Christian
> Wandrei)
>
> alistair.thomson_at_sphinxcst.co.uk wrote:
>
> > It depends what version of oracle you're using and platform.
> >
> > On Oracle 7 / 8 it will be in
> >
> > NT: d:\orant\database
> > UNIX: $ORACLE_HOME/dbs
> >
> > with 8i it will be in
> >
> > NT: oracle_home\admin\sid_name\pfile
> > UNIX: $ORACLE_BASE/admin/sid_name/pfile
> >
> > Hope it helps
> >
> > Al
> >
>
Received on Sat Dec 16 2000 - 22:16:19 CST