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

I got ” ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ”  error in Oracle database.

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

Details of error are as follows.

ORA-32004: Obsolete and/or deprecated parameter(s) specified.
 
Cause: One or more obsolete and/or parameters were specified in the SPFILE or the PFILE
 on the server side.

Action: See alert log for a list of parameters that are obsolete. or deprecated. 
Remove them from the SPFILE or the server side PFILE.

Obsolete and/or deprecated parameter(s) specified.

This ORA-32004 error is related with One or more obsolete and/or parameters were specified in the SPFILE or the PFILE on the server side.

To solve this error, See alert log for a list of parameters that are obsolete. or deprecated. Remove them from the SPFILE or the server side PFILE.

How to Check Obsolete Parameter in Oracle

You can query the deprecated parameter list using the following script.

SQL>SELECT name from v$parameter WHERE isdeprecated = 'TRUE' ORDER BY 1;

NAME
——————————————————————————–
active_instance_count
background_dump_dest
buffer_pool_keep
buffer_pool_recycle
commit_write
cursor_space_for_time
fast_start_io_target
global_context_pool_size
instance_groups
lock_name_space
log_archive_local_first
log_archive_start
max_enabled_roles
parallel_automatic_tuning
parallel_io_cap_enabled
parallel_server
parallel_server_instances
plsql_debug
plsql_v2_compatibility
remote_os_authent
resource_manager_cpu_allocation
sec_case_sensitive_logon
serial_reuse
sql_trace
standby_archive_dest
user_dump_dest

26 rows selected.

You can also use the following script.

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

You can remove or disable this parameter from spfile as follows.

alter system reset sec_case_sensitive_logon scope=spfile sid='*';

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )