ORA-32004: obsolete or deprecated parameter

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

ORA-32004:

You can fix the above error as follow.

PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment.

Try to find which parameter is deprecated.

col NAME format a30;

col VALUE format a10;

select p.name,p.value from v$parameter p, v$spparameter s where s.name=p.name and p.isdeprecated='TRUE' and s.isspecified='TRUE';

NAME                           VALUE

------------------------------ ----------

sec_case_sensitive_logon       FALSE

NOTE:  This parameter is deprecated in the 12c Version so no need anymore.

Now reset the parameter:

alter system reset sec_case_sensitive_logon scope=spfile;

The Error should be gone: