Database Administration (MOSC)

MOSC Banner

ORA-32004: obsolete and/or deprecated parameter(s) specified is always there and problem cannot be f

edited Jan 15, 2014 9:27AM in Database Administration (MOSC) 2 commentsAnswered
Hello,

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center