Connecting Tech Pros Worldwide Help | Site Map

9.2 init.ora file on XP

Ping
Guest
 
Posts: n/a
#1: Jun 27 '08
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
Guest
 
Posts: n/a
#2: Jun 27 '08

re: 9.2 init.ora file on XP


Ping wrote:
Quote:
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
>
spfile<SID>.ora
also in the dbs folder

Hans Forbrich
Guest
 
Posts: n/a
#3: Jun 27 '08

re: 9.2 init.ora file on XP


Ping wrote:
Quote:
>
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.
Closed Thread


Similar Oracle Database bytes