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.