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

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 Fri Dec 15 2000 - 11:40:43 CST