PFILE and SPFILE

The Default Location of SPFILE and PFILE for Linux and Windows

Here is a quick glance at the default locations of SPFILE and PFILE in different platforms. For instance, Linux and Windows.

For Linux/Unix

SPFILE

<ORACLE_HOME>/dbs/spfile<ORACLE_SID>.ora

PFILE

<ORACLE_HOME>/dbs/init<ORACLE_SID>.ora

For Windows

Please note that, for Windows, directory name and filename are case-insensitive.

SPFILE

<ORACLE_HOME>\database\spfile<ORACLE_SID>.ora

PFILE

<ORACLE_BASE>\admin\<ORACLE_SID>\pfile\init.ora.<n>

There’s no typos in the above path. The default location of PFILE on Windows truly depends on ORACLE_BASE. As you can see, they’re somewhat different on path between SPFILE and PFILE on Windows.

For ASM

It may be different from version to version.

<DISK_GROUP>/<DB_NAME>/PARAMETERFILE/spfile.<m>.<n> <DISK_GROUP>/<DB_NAME>/spfile<DB_UNIQUE_NAME>.ora;

More Considerations

In some situations, DBA use a PFILE with non-conventional path to startup the database. You need more skills to find the location of PFILE.

Normally, parameter files should stay where they are, but the location of SPFILE can be changed somehow, as long as you know how to do it.

Leave a Reply

Your email address will not be published. Required fields are marked *