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 )

 

 381 views last month,  4 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply