ORA-32004: obsolete or deprecated parameters specified
Find the obsolete or deprecated parameters flagged by ORA-32004 and remove them through a PFILE round trip.
ORA-32004 is reported when the instance starts with a parameter file that contains obsolete or deprecated parameters. The alert log names the parameters concerned.
Find the parameters
List the deprecated parameters in use, and the obsolete ones that are set:
SELECT name FROM v$parameter WHERE isdeprecated = 'TRUE';
SELECT name FROM v$obsolete_parameter WHERE isspecified = 'TRUE';
Search the alert log for the message. For example, open alert_<SID>.log in an editor and search for Deprecated.
Remove the parameter
-
Create a PFILE from the SPFILE:
CREATE PFILE FROM SPFILE; -
Remove the deprecated parameter from the PFILE. In the case behind this article, the parameter was
parallel_automatic_tuning. -
Start the instance with the edited PFILE:
STARTUP PFILE='/path/to/oracle/home/dbs/initSID.ora'; -
Recreate the SPFILE from the PFILE:
CREATE SPFILE FROM PFILE; -
Restart the instance:
SHUTDOWN IMMEDIATE; STARTUP;
Notes
- Check the query results before removing anything: a parameter flagged as deprecated can still be the one your application or your configuration relies on.