PFILE and SPFILE

How to Resolve ORA-19687: SPFILE not found in backup set

by Ed Chen
June 12, 2023May 3, 2023

ORA-19687 Tried to restore SPFILE from a backup set by RMAN, but it failed with ORA-19687. RMAN> restore spfile from '/backup/rman/051r6emh_1_1'; ... ORA-19687: SPFILE not… Read More »

How Oracle Restore SPFILE

by Ed Chen
May 30, 2023August 25, 2023

Timings to Restore SPFILE At several occasions listed below, you may need to restore it from a previously backed up SPFILE. SPFILE was accidentally deleted.… Read More »

How Oracle Backup SPFILE

by Ed Chen
May 29, 2023August 25, 2023

Timings to Backup SPFILE In case that we need to restore SPFILE to the original state at a later time, we should backup SPFILE in… Read More »

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

by Ed Chen
December 23, 2022May 12, 2023

ORA-32001 ORA-32001 means that the database cannot write SPFILE at this moment, you should make sure that it has been using by the instance. Let's… 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, 2021May 31, 2023

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, 2019May 31, 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, 2018May 31, 2023

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 »

JavaScript is not enabled. Please enable it and reload the page.