What is Oracle 9i Default location for “init.ora” ? and what is the default name for it?
Isn't it same as before?
$ORACLE_HOME/dbs on Unix?
On Windows, it is $ORACLE_HOME\database
Since this is first post on this Forum, i'll answer it.
Default $ORACLE_BASE/admin or where ever you have mentioned your admin folder while creating the database.
And do read...
"There is a difference between knowing the path and walking the path."
default name is:
initSID.ora or spfileSID.ora
I found only spfile.ora and I couldn't read or change it.
I'm not familiar oracle 9i on Win XPP yet and I need to update the parameter file.
You can create pfile if your database was started up by spfile:
create pfile from spfile;
After you have a pfile, you can edit it and modify as
you wish and startup your database:
Of course, you can create spfile too:
create spfile from pfile;
You can also modify parameter stored in spfile by:
alter system set xxx=yyy scope=spfile;
On window 2K, you can edit most
of parameters directly though it is not suuported by
Oracle because spfile is binary.
spfile default loc is $ORACLE_HOME/dbs/sidspfile.ora
startup pfile='wherever you put it'
create spfile from pfile < puts in default loc >
then next time just do
Thanks all for the help. Now I know what SPFILE is.