Total Pageviews

Saturday, September 25, 2021

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

Try to find which parameter is deprecated.

col NAME format a30;
col VALUE format a10;

SQL> 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 so no need anymore.

Now reset the parameter:

alter system reset sec_case_sensitive_logon scope=spfile;

SQL> shutdown immediate;

SQL> startup;

No comments:

Post a Comment

ORA-00845: MEMORY_TARGET not supported on this system

 The shared memory file system should have enough space to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values. To verify: SQL> sh...