Home » Infrastructure » Windows » Change the default location to search for init files?
Change the default location to search for init files? [message #177473] Wed, 14 June 2006 21:40 Go to next message
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.
Re: Change the default location to search for init files? [message #177498 is a reply to message #177473] Thu, 15 June 2006 01:15 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
I think that for you will be usefull - you can start database in that manner:
SQL>startup full_path_to_pfile

this command can start database with any pfile situated in any part of filesystem(where you can access of course).
Re: Change the default location to search for init files? [message #177589 is a reply to message #177473] Thu, 15 June 2006 11:37 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Thanks aciolac for the reply, and you are absolutely correct.

But I'm looking for more of a default location, one without having to specify a specific file name.
Previous Topic: installation of oracle
Next Topic: Oracle10g + windows 2003 server problem
Goto Forum:
  


Current Time: Sun Oct 24 00:45:28 CDT 2021