9.2 init.ora file on XP

[Ping]

Where can i find the initialization file to change some parameters? This file
used to be init<sid>.ora in previous versions of oracle.

Oracle 9.2 on xp is in question.

Thanks in advance

Ping

[Ana C. Dent]

Re: 9.2 init.ora file on XP

Ping wrote:
[color=blue]
> Where can i find the initialization file to change some parameters? This file
> used to be init<sid>.ora in previous versions of oracle.
>
> Oracle 9.2 on xp is in question.
>
> Thanks in advance
>[/color]
spfile<SID>.ora
also in the dbs folder

[Hans Forbrich]

Re: 9.2 init.ora file on XP

Ping wrote:[color=blue]
>
> Where can i find the initialization file to change some parameters? This file
> used to be init<sid>.ora in previous versions of oracle.
>
> Oracle 9.2 on xp is in question.
>
> Thanks in advance
>
> Ping[/color]

It may be time to hit the manuals to catch up on the recent changes.
The init.ora file (which is officially known as the pfile) is being
superceeded by the spfile!

Direct answer to your question - if you set up the database to use the
init.ora it will be found in the usual place. Default config now is to
use the spfile.

Major hint - do not edit the spfile! Likelyhood of making the file
unsuable (and therefore the database unavailable) is very high if you
edit the file directly.