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

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

In article <3A3A41D5.DA60E510_at_gmx.de>,
  Christian Wandrei <Christian.Berlin_at_gmx.de> wrote:
> When I start an Oracle instance I can use the pfile parameter to tell
> Oracle where to find the init.ora file. What I need is the reverse:
 The
> Oracle instance is running and I like to find out what was the
 init.ora
> File which was executed in the startup phase. I did not find anything
 in
> the data dictionary.
>
> Thanks,
>
> Thanks,
> Jan Dieckmann
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 15 2000 - 11:12:58 CST