| Change the default location to search for init files? [message #177473] |
Wed, 14 June 2006 21:40  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
On windows, the default directory for oracle to look for a pfile or an spfile is oracle_home\database. If you have just one of those files, it will use it, even if you just type startup to bring up the db. If you have both in that directory, the spfile will be used.
Is there a way to change this default directory?
I've tried with oradim, there is a pfile and an spfile option. But the pfile option is for a specific file, not a location to search, and the spfile doesn't even have that option. The -pfile does create a registry entry, but this doesn't seem helpful.
There is always the ifile approach, but again this points to a specific file. It also doesn't seem to let you point to an spfile, only a pfile.
So...any way to change the default folder, to say, oracle_base\admin\sid\pfile? Some of the docs seem to indicate that this is in fact the default, whereas others imply it is the database directory. But trial and error shows it to be the database directory. Some of the other related docs seem to be wrong also, but that is slightly unrelted.
All of this is for windows 32 bit on XP SP2, version 10.1.0.2.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
