This should have been brain-dead simple but something is happening I've never seen and don't understand.
Oracle SE 10.2.0.4 on Windows Serve 2003
I do an ALTER SYSTEM ... SCOPE=SPFILE, but when the database is restarted, values have reverted back.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string E:\ORACLE\PRODUCT\10.2.0\ROY\D
ATABASE\SPFILEROYDEV.ORA
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +SAN/roydev/controlfile/curren
t.261.686792331, +SAN/roydev/c
ontrolfile/current.260.6867923
31
SQL> --
SQL> alter system set control_files='x:\oradata\roydev\controlfile\control01.ctl','y:\oradata\roydev\controlfile\control02.ctl' scope=spfile;
System altered.
SQL> --
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1298192 bytes
Variable Size 167772400 bytes
Database Buffers 440401920 bytes
Redo Buffers 2895872 bytes
Database mounted.
Database opened.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string E:\ORACLE\PRODUCT\10.2.0\ROY\D
ATABASE\SPFILEROYDEV.ORA
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +SAN/roydev/controlfile/curren
t.261.686792331, +SAN/roydev/c
ontrolfile/current.260.6867923
31
SQL> spool off