Removing obsolete parameters from spfile

April 14, 2013

11g, database, parameter, upgrade

This is a common error message after upgrade of the database:

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

In 11g (last tested with even if your start up the database from an old type pfile without any obsolete parameters and then create an spfile from memory like this:

create spfile from memory;  

Oracle will insert two obsolete parameters into the spfile. This query will list obsolete parameters in your spfile:

from v$parameter p, v$spparameter s  
and p.isdeprecated='TRUE'  
and s.isspecified='TRUE';  

NAME                  VALUE  
\--------------------- ----------------------------------------------  
background_dump_dest  /u01/app/oracle/diag/rdbms/hfmtst/HFMTST/trace  
user_dump_dest        /u01/app/oracle/diag/rdbms/hfmtst/HFMTST/trace  

```They can be cleared with:  

alter system reset background_dump_dest;
alter system reset user_dump_dest;