Skip to content

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

  • Oracle

ORA-32004

Saw error ORA-32004 when I startup a database.

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

ORA-32004 means that some parameters you set explicitly have been deprecated, Oracle ignored them and proceed the startup.

To identify what parameters caused the problem, we should inspect the alert log. In the alert log, we saw something unusual.

...
Deprecated system parameters with specified values:
  log_archive_start
End of deprecated system parameter listing
...

LOG_ARCHIVE_START

Let's see the current value of LOG_ARCHIVE_START.

SQL> show parameter log_archive_start

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     TRUE

As you can see, the deprecated parameter LOG_ARCHIVE_START has been used and its value is TRUE.

Solution

To remove such warning, we should clear the parameter from SPFILE by resetting it.

SQL> alter system reset log_archive_start sid='*' scope=spfile;

System altered.

Please note that, the parameter can be modified only within the scope of SPFILE;

Next, we restart the database to test the result.

SQL> shutdown immediate;
SQL> startup

No more warning at this startup.

Let's check the parameter again.

SQL> show parameter log_archive_start

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     FALSE

Meanwhile, the archivelog mode keeps enabled.

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /path/to/archive
Oldest online log sequence     107
Next log sequence to archive   109
Current log sequence           109

We solved the problem.

Leave a Reply

Your email address will not be published. Required fields are marked *