This is the 3rd posting in my series about init.ora/SPFILE parameters in Oracle Database 12.2.0.1.
- New SPFILE Parameters in Oracle Database 12.2.0.1
- Obsolete SPFILE Parameters in Oracle Database 12.2.0.1
- Deprecated SPFILE Parameters in Oracle Database 12.2.0.1
- Default SPFILE Parameter changes between Oracle Database 11.2.0.4, 12.1.0.2 and 12.2.0.1
Finally, here’s the list of DEPRECATED parameters in Oracle Database 12.2.0.1:
O7_DICTIONARY_ACCESSIBILITY active_instance_count asm_preferred_read_failure_groups background_dump_dest buffer_pool_keep buffer_pool_recycle commit_write cursor_space_for_time db_block_buffers fast_start_io_target instance_groups lock_name_space log_archive_start parallel_adaptive_multi_user plsql_debug plsql_v2_compatibility rdbms_server_dn remote_os_authent resource_manager_cpu_allocation sec_case_sensitive_logon serial_reuse sql_trace standby_archive_dest unified_audit_sga_queue_size user_dump_dest utl_file_dir
Only the ones in BOLD were newly marked as DEPRECATED in Oracle Database 12.2.0.1. The non-bold ones had been deprecated in earlier releases already.
Please see also the column ISDEPRECATED in V$PARAMETER.
–Mike
Hi Mike,
shouldn’t the first one be "O"7_DICTIONARY_ACCESSIBILITY?
Cheers,
Uwe
Thanks Uwe!
Mike
Mike –
is that "sql_trace" parameter got depreciated ? means we should rely on dbms_monitor.session_trace_enable method rather than this parameter ?
"Deprecated" means only that it is fully supported to use it – but we don’t develop it further anymore. So yes, you still can use it, we would fix upcoming issues. But we may make it OBSOLETE one day.
Cheers
Mike
Hi Mike,
Do you have this list for Oracle Database 19c version?
Thanks in advance
SQL> select name from v$parameter where ISDEPRECATED='TRUE'
NAME
--------------------------------------------------------------------------------
lock_name_space
instance_groups
resource_manager_cpu_allocation
active_instance_count
db_block_buffers
buffer_pool_keep
buffer_pool_recycle
log_archive_start
cluster_database_instances
fast_start_io_target
serial_reuse
rdbms_server_dn
remote_os_authent
sec_case_sensitive_logon
unified_audit_sga_queue_size
cursor_space_for_time
plsql_v2_compatibility
plsql_debug
background_dump_dest
user_dump_dest
commit_write
sql_trace
parallel_adaptive_multi_user
asm_preferred_read_failure_groups
24 rows selected.
🙂
CHeers,
Mike
Has anyone reading this article that is using
remote_os_authent boolean TRUE
Managed to get
os_authent_prefix string
working after upgrading from 11g to 19c 🙁 Even Oracle Support has no success troubleshooting how to get it working 🙁
Can you share an SR number please, Ed?
Cheers
Mike