Deprecated and Desupported Parameters in Oracle Databases

As of Oracle 12c, some parameters are either deprecated or no longer supported. We can learn these parameters from the v$parameter view. These parameters must be removed from the spfile or pfile file before 12c upgrade.

You can identify the deprecated and unsupported parameters with the query below :

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

The following parameters returned from the query result should be removed from the parameter files, if any.

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_start
max_enabled_roles
parallel_automatic_tuning
parallel_io_cap_enabled
parallel_server
parallel_server_instances
plsql_v2_compatibility
remote_os_authent
resource_manager_cpu_allocation
sec_case_sensitive_logon
serial_reuse
sql_trace
standby_archive_dest
user_dump_dest

Also, when opening the instance, the deprecated parameters will be specified in the alert.log file, if it exists in the parameter file.

You can delete or reset a parameter from the spfile file as follows.

SQL> ALTER SYSTEM RESET PARAMETRE_ADI SCOPE=SPFILE;

For example :

SQL> alter system reset user_dump_dest scope=spfile;

 

Please follow and like us:

Leave a Reply

Your email address will not be published. Required fields are marked *