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:
