PFILE and SPFILE

How to Change SPFILE Location

Posted on
Change SPFILE Location Generally, we don’t change SPFILE location, because it should be found in the default location, $ORACLE_HOME/dbs/spfile$ORACLE_SID.ora any time to startup the instance without any explicit indication. SQL> startup Which means, the database will find an appropriate SPFILE or PFILE in the default location to startup the instance. Of course, anything is possible […]
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 typos in the above path. The default location of […]
PFILE and SPFILE

Where is the Location of PFILE?

Posted on
If we were trying to change parameters in an unfamiliar database that was handed over from other DBA, we have to figure it out whether the database started with SPFILE or PFILE. Moreover, if PFILE is used, you have to know the location of PFILE. Of course, we can ask the former DBA for the […]
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

Why SPFILE Does Not Work in RAC

Posted on
Shared SPFILE You might have noticed that the newly created SPFILE for a RAC database was not taking effective after restarts. And 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 […]