ORA-32001: write to SPFILE requested but no SPFILE specified at startup - From once instance only

Hello everyone

We have a 2 node RAC database running 10g R2 that we inherited

Today while trying to add new UNDO tablespaces to both instance we ran into an issue

After we created the 2 new UNDO tablespsace for the 2 instances when we tried to set the new UNDO tablespace

from node-1, we got this error

SQL> ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS1_NEW SCOPE=BOTH SID='prod1';

ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS1_NEW SCOPE=BOTH SID='prod1'

*

ERROR at line 1:

ORA-32001: write to SPFILE requested but no SPFILE specified at startup

We then logged onto node-2 and were able to successfully execute the above for both the UNDO tablespaces (one for each instance)