Oracle 9i Default location for init.ora

[ALF]

What is Oracle 9i Default location for “init.ora” ? and what is the default name for it?

Thanks

ALF

[sysdba]

Isn't it same as before?
$ORACLE_HOME/dbs on Unix?
On Windows, it is $ORACLE_HOME\database

[adewri]

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

[sysdba]

default name is:
initSID.ora or spfileSID.ora

[ALF]

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

[sysdba]

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.

[BJE_DBA]

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

[ALF]

Thanks all for the help. Now I know what SPFILE is.

Alf