[Tech] oracle 12c 미지원 파라미터

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

 

NAME

--------------------------------------------------------------------------------

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

 

26 rows selected.

 

또는 아래와 같이 deprecated할 파라메타 값을 지정한다.

Deprecated system parameters with specified values:

  sec_case_sensitive_logon 

End of deprecated system parameter listing

[출처] 오라클 12c 기동시 ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance 오류|작성자 허수아비

https://boeok.tistory.com/entry/Oracle11g-111070-%EB%B6%80%ED%84%B0-deprecate%EB%90%9C-parameters