Obsolete or deprecated parameters (ORA-32004)

Today i need to update my lab here at home to Oracle 11.2.0.4 version. While i was doing it, i notice that one of my instance started fine but showed an ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance.The error is clear, some of my parameters are obsolete for my particular Oracle version.

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

Total System Global Area  242208768 bytes
Fixed Size		    2227176 bytes
Variable Size		  184550424 bytes
Database Buffers	   50331648 bytes
Redo Buffers		    5099520 bytes
Database mounted.

To easily find out what kind of parameters are obsolete, just generate a pfile from memory and use bash to identified it:

SQL> create pfile='/home/oracle/pfileFENIX.ora' from memory;
File created.
[oracle@phoenix ~]$ grep -i deprecate pfileFENIX.ora
background_dump_dest='/u01/app/oracle/diag/rdbms/fenix/fenix/trace' #Deprecate parameter
user_dump_dest='/u01/app/oracle/diag/rdbms/fenix/fenix/trace' #Deprecate parameter

Adjust your pfile, startup your instance with it, generate a spfile and startup your instance again.

PS: This is more a mental note for me than a real post 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s