ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
2017-06-15 13:40 abce 阅读(988) 评论(0) 编辑 收藏 举报打开一个12.2的测试库，报以下信息提示：
SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 5905580032 bytes Fixed Size 8805624 bytes Variable Size 1426064136 bytes Database Buffers 4462739456 bytes Redo Buffers 7970816 bytes Database mounted. Database opened. SQL>
查看数据库弃用的系统参数：
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 standby_archive_dest fast_start_io_target serial_reuse rdbms_server_dn remote_os_authent sec_case_sensitive_logon O7_DICTIONARY_ACCESSIBILITY unified_audit_sga_queue_size cursor_space_for_time utl_file_dir plsql_v2_compatibility plsql_debug background_dump_dest user_dump_dest commit_write sql_trace parallel_adaptive_multi_user asm_preferred_read_failure_groups 26 rows selected. SQL>
原来设置了参数sec_case_sensitive_logon为false，但是该参数在该版本中已经失效。
reset一下该参数即可：
SQL> alter system reset sec_case_sensitive_logon scope=spfile; System altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 5905580032 bytes Fixed Size 8805624 bytes Variable Size 1426064136 bytes Database Buffers 4462739456 bytes Redo Buffers 7970816 bytes Database mounted. Database opened. SQL>
