A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

ORA-32001: How to identify if the database was started with spfile or pfile?

1 min read

There are couple of ways of finding if the database was started with spfile or pfile.

First we can check the value of parameter spfile, if it returns blank then database was started by pfile.

SQL> show parameter spfile;

NAME TYPE VALUE
—— —— ————————————————
spfile string +GRID_DG/ORCL/spfileorcl.ora

NOTE: It shows database was started by spfile

Second way to find would be setting the parameter with scope=spfile.

If database was started with spfile one will be able to set the value if it’s started with pfile you will see the “ORA-32001: write to spfile requested but no SPFILE specified at startup”.

Note: You can set the new value to be the same as current value of the parameter

SQL> ALTER SYSTEM set open_cursors=300 scope=spfile;
ALTER SYSTEM set open_cursors=300 scope=spfile;
*
ERROR at line 1:
ORA-32001: write to spfile requested but no SPFILE specified at startup