Hi All,
Now the system is in started and database is in open status.
When I tried to execute the following command to set undo_retention parameter
SQL> alter system set undo_retention=64543 scope=both;
alter system set undo_retention=64543 scope=both
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
am getting above error.
I have checked system which is running using PFILE
SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
FROM sys.v_$parameter WHERE name = 'spfile'; 2
Init File Type
--------------------------------
PFILE
but both SPFILE and PFILE path are showing me empty string.
SQL> show parameter spfile
NAME TYPE VALUE
---------------- ------------ ------------------
spfile string
SQL> show parameter pfile
NAME TYPE VALUE
-------- ------------ ------------------
spfile string
how to I change undo_retention value parmeter..? Kindly guide to resolve the above error..
Thanks & Regards
Sami