Oracle10g启动的时候检查spfile文件，在没有spfile的情况下，检查pfile文件，在不同的操作系统环境下，pfile的存放位置是不一样的。

Legacy init.ora Parameter Files

Now that you know what these legacy database parameter files are and where to get more

details about the valid parameters that you can set, the last thing you need to know is where to

find them on disk. The naming convention for this file by default is

init$ORACLE_SID.ora (Unix environment variable)

init%ORACLE_SID%.ora (Windows environment variable)

and by default it will be found in

$ORACLE_HOME/dbs (Unix)

%ORACLE_HOME%DATABASE (Windows)

It should be noted that the parameter file does not have to be in any particular location.

When starting an instance, you may use the pfile=filename option to the startup command.

This is most useful when you would like to try out different init.ora parameters on your database

to see the effects of having different settings.

SQL>startup pfile=pfilename.ora;

Server Parameter Files (SPFILEs)

The naming convention for this file by default is

spfile$ORACLE_SID.ora (Unix environment variable)

spfile%ORACLE_SID%.ora (Windows environment variable)

[@more@]

ITPub博客

Unix环境和Windows环境下Oracle参数文件位置：