ORA-32004: obsolete and/or deprecated parameter(s) specified is always there and problem cannot be f
I have a deprecated parameter parellel_automatic_tuning=TRUE which is deprecated, then I changed it back to FALSE which is default but when I select it from v$parameter view, it is not showing it is a default value, so when I start the DB instance, ORA-32004 error is always there. How to fix thie problem? Is there a table I can update? I cannot update v$parameter for sure. My DB is Oracle EE 10.2.0.4. OS is Windows Server 2008.
The sql I use is:
select name,value,isdeprecated,isdefault from v$parameter
where isdeprecated='TRUE' and isdefault='FALSE';