• ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance


    打开一个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> 
    

      

  • 相关阅读:
    CUDA[2] Hello,World
    mysql操作
    virsh 连接虚拟机 (vnc 或 控制台)
    ssh访问流程
    使用ceph-deploy进行ceph安装
    openstack 的horizon的结构
    django 后台格式化数据库查询出的日期
    web 应用的部署
    工具
    python性能优化
  • 原文地址:https://www.cnblogs.com/abclife/p/7017258.html
Copyright © 2020-2023  润新知