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.

Leave a Reply

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