PFILE and SPFILE

How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use

by Ed Chen
December 23, 2022November 17, 2022

ORA-32001 ORA-32001 means that it cannot write the server parameter file at this moment, you should make sure SPFILE is being used by the instance.… Read More »

How to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE

by Ed Chen
February 28, 2022August 10, 2022

ORA-32016 Tried to change DB_NAME in SPFILE when the instance is running, but it failed with ORA-32016. Let's see current value of DB_NAME. SQL> show… Read More »

How to Resolve ORA-32002: cannot create SPFILE already being used by the instance

by Ed Chen
August 16, 2021October 23, 2021

ORA-32002 Tried to restore the server parameter (SPFILE) to the default location from a parameter file (PFILE), but it failed with ORA-32002 like this. SQL>… Read More »

How to Resolve ORA-01565: error in identifying file

by Ed Chen
January 9, 2021December 9, 2022

In this post, I'll describe two error patterns for ORA-01565. Missing SPFILE Multitenant DB A. ORA-01565 for Missing SPFILE To create a plain-text parameter file,… Read More »

How to Change SPFILE Location in Oracle

by Ed Chen
February 23, 2019February 25, 2023
2 Comments

ALTER SYSTEM SET SPFILE Before reading, you have to know that there's no ALTER SYSTEM SET SPFILE statement in Oracle, because we can never write… Read More »

Where is Oracle SPFILE Location

by Ed Chen
March 29, 2018December 11, 2022

Here is a quick glance at the default locations of SPFILE and PFILE in different platforms. For instance, Linux and Windows. Linux/Unix SPFILE <ORACLE_HOME>/dbs/spfile<ORACLE_SID>.ora PFILE… Read More »

How to Point to SPFILE in PFILE to Trick Scripts

by Ed Chen
March 24, 2018August 12, 2021

In my case, I plan to use SPFILE to startup the database instance which used to use a known PFILE to open. But the problem… Read More »

SPFILE or PFILE?

by Ed Chen
September 9, 2017October 6, 2021

If we need to change some values of parameters persistently, what should we start? First of all, we have to know whether the database started… Read More »

Where is Oracle PFILE Location

by Ed Chen
September 9, 2017December 11, 2022

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… Read More »

Show Parameter Spfile

by Ed Chen
September 6, 2017November 14, 2021

Show Parameter Spfile Whenever you want to know the location of Server Parameter File (SPFILE), I think the first thing you want to do is… Read More »