五、软件安装
解压两个安装包（解压前先改权限 root用户：chmod 777 /stage）

1. root用户在/u01下建目录
   mkdir /u01/install_db
   chown oracle:oinstall install_db

2. root用户 改压缩包权限
   chown oracle:oinstall .....

3. oracle 用户解压（1of7&2of7）
   cd /u01/install_db
    unzip ***.zip -d ./

4. export DISPLAY=IP:0.0

   cd /stage/database
    ./runInstaller

六、参数调整

1. 限制ASSM调整范围
   SGA_TARGET=DB_CACHE_SIZE+DB_nK_CACHE_SIZE+SHARED_POOL_SIZE+1GB/2GB

2. 控制文件保留时间
   alter system set control_file_record_keep_time=60;

3. 恢复LGWR的post/wait通知方式
   alter system set "_use_adaptive_log_file_sync"=false sid='*' scope=spfile;

4. 死事务回滚调整
   限制回滚进程数
   alter system set fast_start_parallel_rollback=low;
   alter system set recovery_parallelism=10 scope=spfile;

5. 配置每次回滚记录数
   alter system set "_cleanup_rollback_entries"=10000 scope=spfile;

6. 解除密码过期限制
   alter profile default limit PASSWORD_LIFE_TIME unlimited;
   alter profile default limit PASSWORD_LOCK_TIME unlimited;
   alter profile default limit PASSWORD_GRACE_TIME unlimited;

7. AWR收集间隔
   AWR收集间隔修改为30分钟，保留期限为30天    
   exec dbms_workload_repository.modify_snapshot_settings(interval=>30, retention=>30*24*60);
   

8. 禁用“Automatic SQL Tuning Advisor”
   exec dbms_auto_task_admin.disable(client_name => 'sql tuning advisor',operation => NULL,window_name => NULL);
   

9. 禁用“Auto Space Advisor”
   exec dbms_auto_task_admin.disable(client_name => 'auto space advisor',operation => NULL,window_name => NULL);
   

10. 数据文件安全
    alter system set "_datafile_write_errors_crash_instance"=false scope=spfile;
    

11. 开启BCT
    如果启用增量备份，则开启BCT。
    alter database enable block change tracking using file '+DATA';
    

12. 设置28401和10949事件
    alter system set event='28401 trace name context forever,level 1',
    '10949 trace name context forever,level 1' sid='*' scope=spfile;
    

13. 关闭密码大小写敏感
    alter system set sec_case_sensitive_logon=false scope=spfile sid='*';
    

14. 设置dump文件大小上限
    alter system set max_dump_file_size='4096M' scope=spfile sid='*';
    

15. 调整默认分区大小
    alter system set "_partition_large_extents"=false scope=spfile sid='*';
    

16. 设置并行子进程的数量上限
    alter system set parallel_max_servers=128 scope=spfile sid='*';
    

17. 关闭初始化extent的延迟创建
    alter system set deferred_segment_creation=false scope=spfile sid='*';
    

18. 关闭result_cache
    alter system set result_cache_max_size=0 scope=spfile sid='*';
    

19. 关闭登录、登出的审计日志
    noaudit create session;
    

20. 关闭自适应游标共享
    alter system set "_optimizer_adaptive_cursor_sharing"=false sid='*' scope=spfile;
    alter system set "_optimizer_extended_cursor_sharing"=none sid='*' scope=spfile;
    alter system set "_optimizer_extended_cursor_sharing_rel"=none sid='*' scope=spfile;
    

21. 关闭Cardinality feedback
    alter system set "_optimizer_use_feedback"=false sid ='*' scope=spfile;
    

22. 使并行会话改为使用Large Pool
    alter system set "_px_use_large_pool"=true  sid ='*' scope=spfile;
    

23. SGA自动调整间隔设置
    alter system set "_memory_broker_stat_interval"=999;
    

24. 并行执行Message大小
    alter system set parallel_execution_message_size=2148 scope=spfile;