By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,196 Members | 973 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,196 IT Pros & Developers. It's quick & easy.

9.2 init.ora file on XP

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.