469,649 Members | 1,301 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,649 developers. It's quick & easy.

9.2 init.ora file on XP

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
Jul 19 '05 #1
2 3642
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

spfile<SID>.ora
also in the dbs folder

Jul 19 '05 #2
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.
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by FC | last post: by
4 posts views Thread by Anatoly | last post: by
9 posts views Thread by J.Marsch | last post: by
10 posts views Thread by Wylbur via DotNetMonster.com | last post: by
2 posts views Thread by Ping | last post: by
2 posts views Thread by Christof Warlich | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.