自动安装Oracle数据库

prompt ******************************Adjust database ************************************** --密码文件 alter profile default limit password_life_time unlimited password_grace_time unlimited password_reuse_time unlimited password_reuse_max unlimited failed_login_attempts 100 password_lock_time unlimited password_verify_function null; --归档设置 alter system set db_recovery_file_dest_size=500g; alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'; --关闭密码大小写敏感 alter system set sec_case_sensitive_logon=false sid='*'; --禁用AUDIT alter system set audit_trail=none scope=spfile sid='*'; --关闭结果集缓存 alter system set result_cache_max_size = 0 sid='*'; --关闭ACS特性 alter system set "_optimizer_adaptive_cursor_sharing"=FALSE scope=spfile sid='*'; alter system set "_optimizer_extended_cursor_sharing_rel"='NONE' scope=spfile sid='*'; alter system set "_optimizer_extended_cursor_sharing"='NONE' scope=spfile sid='*'; --关闭Null-Aware ANTI-JOIN特性 alter system set "_optimizer_null_aware_antijoin"=FALSE scope=spfile sid='*'; --关闭Cardinality Feedback特性 alter system set "_optimizer_use_feedback"=FALSE scope=spfile sid='*'; --关闭直接路径读特性 alter system set "_serial_direct_read"=NEVER scope=spfile sid='*'; --关闭密码延迟验证特性 alter system set event='28401 trace name context forever,level 1','10949 trace name context forever,level 1'scope=spfile sid='*'; --关闭RAC的DRM特性（仅对RAC） alter system set "_gc_policy_time"=0 scope=spfile sid='*'; --关闭自适应日志文件同步 alter system set "_use_adaptive_log_file_sync" = false scope=spfile sid='*'; ---修改后重启实例生效。 --关闭sql tuning advisor BEGIN dbms_auto_task_admin.disable( client_name => 'sql tuning advisor', operation => NULL, window_name => NULL); END; / --关闭auto space advisor BEGIN dbms_auto_task_admin.disable( client_name => 'auto space advisor', operation => NULL, window_name => NULL); END; / --调整awr 快照间隔时间（30分钟）和保留时间（30天） exec dbms_workload_repository.modify_snapshot_settings(interval=>30, retention=>31*24*60); exec dbms_stats.set_global_prefs('incremental', 'TRUE'); exec dbms_stats.set_global_prefs(pname => 'ESTIMATE_PERCENT', pvalue => '0.1'); --调整对象统计数据收集任务的调度时间窗口和持续时间，需要根据实际情况进行调整 EXECUTE DBMS_SCHEDULER.SET_ATTRIBUTE('MONDAY_WINDOW','repeat_interval','freq=daily;byday=MON;byhour=23;byminute=0; bysecond=0'); EXECUTE DBMS_SCHEDULER.SET_ATTRIBUTE('TUESDAY_WINDOW','repeat_interval','freq=daily;byday=TUE;byhour=23;byminute=0; bysecond=0'); EXECUTE DBMS_SCHEDULER.SET_ATTRIBUTE('WEDNESDAY_WINDOW','repeat_interval','freq=daily;byday=WED;byhour=23;byminute=0; bysecond=0'); EXECUTE DBMS_SCHEDULER.SET_ATTRIBUTE('THURSDAY_WINDOW','repeat_interval','freq=daily;byday=THU;byhour=23;byminute=0; bysecond=0'); EXECUTE DBMS_SCHEDULER.SET_ATTRIBUTE('FRIDAY_WINDOW','repeat_interval','freq=daily;byday=FRI;byhour=23;byminute=0; bysecond=0'); EXECUTE DBMS_SCHEDULER.SET_ATTRIBUTE('SATURDAY_WINDOW','repeat_interval','freq=daily;byday=SAT;byhour=23;byminute=0; bysecond=0'); EXECUTE DBMS_SCHEDULER.SET_ATTRIBUTE('SUNDAY_WINDOW','repeat_interval','freq=daily;byday=SUN;byhour=23;byminute=0; bysecond=0'); exec dbms_scheduler.set_attribute('MONDAY_WINDOW','duration',numtodsinterval(4,'hour')); exec dbms_scheduler.set_attribute('TUESDAY_WINDOW','duration',numtodsinterval(4,'hour')); exec dbms_scheduler.set_attribute('WEDNESDAY_WINDOW','duration',numtodsinterval(4,'hour')); exec dbms_scheduler.set_attribute('THURSDAY_WINDOW','duration',numtodsinterval(4,'hour')); exec dbms_scheduler.set_attribute('FRIDAY_WINDOW','duration',numtodsinterval(4,'hour')); exec dbms_scheduler.set_attribute('SATURDAY_WINDOW','duration',numtodsinterval(4,'hour')); exec dbms_scheduler.set_attribute('SUNDAY_WINDOW','duration',numtodsinterval(4,'hour'));