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

=================

Issue

=================

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance is coming after recreating SPFILE.

=================

How to recreate

=================

SQL> CREATE PFILE='/software/oracle/admin/igt/pfile/pfileigt.ora_20210806' FROM SPFILE;
File created.
SQL> CREATE SPFILE='/software/oracle/admin/igt/pfile/sfileigt.ora_20210806' FROM MEMORY;
File created.
--------------

sho parameter spfile

/software/oracle/admin/igt/pfile/spfileigt.ora

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

To find out which parameters are deprecated, open the alert.log

  
WARNING: The user_dump_dest init.ora parameter has been deprecated.
WARNING: Please remove the user_dump_dest parameter from the init.ora file.
WARNING: The background_dump_dest init.ora parameter has been deprecated.
WARNING: Please remove the background_dump_dest parameter from the init.ora file.

Deprecated system parameters are:
  background_dump_dest
  user_dump_dest

=================

How to Fix

=================

CREATE PFILE='/software/oracle/admin/igt/pfile/pfile_fix_20210806.ora' from SPFILE;

!vi /software/oracle/admin/igt/pfile/pfile_fix_20210806.ora
Remove background_dump_dest + user_dump_dest from /software/oracle/admin/igt/pfile/pfile_fix_20210806.ora

SQL> SHUTDOWN IMMEDIATE;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup pfile = '/software/oracle/admin/igt/pfile/pfile_fix_20210806.ora';

ORACLE instance started.

Total System Global Area 4175568896 bytes

Fixed Size                  2259840 bytes

Variable Size            2214593664 bytes

Database Buffers         1946157056 bytes

Redo Buffers               12558336 bytes

Database mounted.

Database opened.

SQL> CREATE SPFILE FROM  PFILE='/software/oracle/admin/igt/pfile/pfile_fix_20210806.ora';
File created.

SQL> SHUTDOWN IMMEDIATE;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> STARTUP;

ORACLE instance started.

Total System Global Area 4175568896 bytes

Fixed Size                  2259840 bytes

Variable Size            2214593664 bytes

Database Buffers         1946157056 bytes

Redo Buffers               12558336 bytes

Database mounted.

Database opened.

SQL>