Re: 9.2 init.ora file on XP

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Sat, 13 Dec 2003 08:48:50 GMT
Message-ID: <3FDAD2A3.F42FB1D5_at_yahoo.net>


Ping wrote:
>
> 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

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. Received on Sat Dec 13 2003 - 09:48:50 CET

Original text of this message