What is Oracle 9i Default location for “init.ora” ? and what is the default name for it? Thanks ALF
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... http://www.dbasupport.com/forums/sho...threadid=36219 HTH
Amar "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. ALF
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: startup pfile=... 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 startup
Thanks all for the help. Now I know what SPFILE is. Alf
Forum Rules