PFILE and SPFILE

The Default Location of SPFILE and PFILE for Linux and Windows

Posted on
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 tyops in the above path. The default location of […]
DDL

The Default Values in “ALTER SYSTEM SET” Statement

Posted on
Without declaring SCOPEIf you do not specify this clause, then:If a server parameter file was used to start up the database, then BOTH is the default.If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify.Started bySCOPEspfileBOTHpfileMEMORYWithout declaring SIDIf you do […]
PFILE and SPFILE

When the SPFILE is Missing

Posted on
When you met the following situation, you are about to restore the spfile for your database.SQL> startup open;ORA-01078: failure in processing system parametersORA-01565: error in identifying file ‘+DATA/compdb/spfileprimdb.ora’ORA-17503: ksfdopn:2 Failed to open file +DATA/compdb/spfileprimdb.oraORA-15056: additional error messageORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/compdb/spfileprimdb.oraORA-17503: ksfdopn:2 Failed to open file +DATA/compdb/spfileprimdb.oraORA-15173: entry ‘spfileprimdb.ora’ does not exist in […]
PFILE and SPFILE

How to Resolve SPFILE Does Not Work

Posted on
You might notice that the newly created SPFILE for a RAC database was not taking effective after restarts. I think you might create the SPFILE in the wrong places.Oracle 11g RAC stores all the shared files in ASM, including control files, spfile, data files. Thus, it starts all the instances with the shared SPFILE. If […]