ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

Question

I have a problem with a SPFILE as shown below.How can I get rid of that problem?Any suggestions?

 SQL> startup
 ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
 ORACLE instance started.

 Total System Global Area 1068937216 bytes
 Fixed Size                  2182592 bytes
 Variable Size             784335424 bytes
 Database Buffers          276824064 bytes
 Redo Buffers                5595136 bytes
 Database mounted.
 Database opened.
 SQL> alter system reset log_archive_start scope=spfile sid='*';
 alter system reset log_archive_start scope=spfile sid='*'
 *
 ERROR at line 1:
 ORA-32010: cannot find entry to delete in SPFILE

Answer 1

Well, you can hack around with an SPFILE easily enough:

SQL> create pfile='/tmp/initSID.ora' from spfile;

Now edit that ordinary text file, then

SQL> create spfile from pfile='/tmp/initSID.ora';

And you can play with the temporary one with

SQL> startup pfile='/tmp/initSID.ora';

Note tho' there is no actual problem with specifying obsolete parameters other than the message; the only issue is if you were relying on them to set some desired behavior, and they were ignored.