Monthly Archives: January 2015

oracle 11g – Location of SPFILE or PFILE

Default location of spfile or pfile is $ORACLE_HOME/dbs, however if you are not sure, then run the below command using sqlplus:

SQL> show parameter spfile;

Name                       Type                                           Value
————–               ——————                    —————————–
spfile                         string                                /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora

With ASM, the spfile is often located into an ASM disk group.

Leave a comment

Filed under Oracle