set spfile parameter
729153Jan 19 2010 — edited Jan 20 2010Hi all,
I have backup copies of spfile and init<SID>.ora file from where i can start database but i cannot set value of spfile so that databse can be started without specifying spfile/pfile.
SQL> show parameter ifile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
ifile file
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> alter system set spfile='C:\oracle\product\10.2.0\db_1\database\SPFILEDB1
alter system set spfile='C:\oracle\product\10.2.0\db_1\database\SPFILEDB1.ORA'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
How i can set the value of spfile parameter value.
Regards,