内容简介:https://github.com/macleanliu/ora-easy-deploy
https://github.com/macleanliu/ora-easy-deploy
ora-easy-deployWORKS ON (CENTOS REDHAT ORACLE) LINUX 7 国外主机 su - root yum -y install git git clone https://github.com/macleanliu/ora-easy-deploy wget https://www.dropbox.com/s/8097ds292gabpk9/oracle-database-ee-19c-1.0-1.x86_64.rpm wget https://www.dropbox.com/s/x14jlgnj062nef2/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm bash ora-easy-deploy/create_db.sh 国内主机 使用浏览器下载以下2个介质并上传到服务器目录 https://download.oracle.com/otn/linux/oracle19c/190000/oracle-database-ee-19c-1.0-1.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm su - root yum -y install git git clone https://github.com/macleanliu/ora-easy-deploy yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm bash ora-easy-deploy/create_db.sh 安装完成后#设置ORACLE OS账户密码 su - root passwd oracle su - oracle lsnrctl start sql alter system register; [oracle@vultr ~]$ sql SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 15 07:09:52 2019 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> alter system register; System altered. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 [oracle@vultr ~]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-MAY-2019 07:28:31 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 15-MAY-2019 07:27:06 Uptime 0 days 0 hr. 1 min. 24 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /opt/oracle/diag/tnslsnr/vultr/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vultr.guest)(PORT=1521))) Services Summary... Service "PROD" has 1 instance(s). Instance "PROD", status READY, has 1 handler(s) for this service... Service "PRODXDB" has 1 instance(s). Instance "PROD", status READY, has 1 handler(s) for this service... The command completed successfully 关闭部分19c特性sql alter system set "_optimizer_aggr_groupby_elim"=false; alter system set "_drop_stat_segment"=1; alter system set "_common_data_view_enabled"=false; alter system set optimizer_adaptive_features=false; alter system set "_optimizer_dsdir_usage_control"=0; alter system set "_enable_automatic_sqltune"=false scope=both; alter system set "_serial_direct_read"=false; alter system set "_nlj_batching_enabled" = 0; alter system set "_optimizer_undo_cost_change" = '10.2.0.4'; alter system set "_optimizer_null_aware_antijoin" = false; alter system set "_optimizer_extend_jppd_view_types" = false; alter system set "_replace_virtual_columns" = false; alter system set "_first_k_rows_dynamic_proration" = false; alter system set "_bloom_pruning_enabled" = false; alter system set "_optimizer_multi_level_push_pred" = false; alter system set "_optim_peek_user_binds"=false; alter system set client_result_cache_size=0 scope=spfile; alter system set result_cache_mode=MANUAL; alter system set "_diag_hm_rc_enabled"=false; alter system set audit_trail=none scope=spfile; alter system set "_memory_imm_mode_without_autosga"=false scope=both; alter system set "_enable_shared_pool_durations"=false scope=spfile; alter system set deferred_segment_creation=false; alter system set "_datafile_write_errors_crash_instance"=false ; alter system set "_fairness_threshold"=6 scope=spfile; alter system set "_gc_read_mostly_locking"=false scope=spfile; alter system set "_gc_policy_time"=0 scope=spfile; alter system set "_gc_defer_time"=3 scope=spfile; alter system set "parallel_force_local"=false; alter system set "_gc_bypass_readers"=false; alter system set "_row_cr"=false; alter system set ddl_lock_timeout=0; alter system set "_gby_hash_aggregation_enabled"=False scope=spfile; alter system set "_cleanup_rollback_entries"=400 scope=spfile; alter system set "_dbms_sql_security_level"=0 scope=spfile; alter system set "_bloom_pruning_enabled"=False scope=spfile; alter system set "_simple_view_merging"=True scope=spfile; alter system set "_enable_NUMA_optimization"=FALSE scope=spfile; alter system set "_fix_control"='9344709:OFF' scope=spfile; alter system set "_px_use_large_pool"=True scope=spfile; alter system set "_mv_refresh_use_hash_sj"=FALSE scope=spfile; alter system set "_mv_refresh_use_stats"=True scope=spfile; alter system set "_like_with_bind_as_equality"=TRUE scope=spfile; alter system set optimizer_secure_view_merging=false scope=spfile; alter system set optimizer_capture_sql_plan_baselines=False scope=spfile; alter system set event="10949 TRACE NAME CONTEXT FOREVER:28401 trace name context forever, level 1" scope=spfile; exec DBMS_AUTO_TASK_ADMIN.DISABLE( client_name => 'auto optimizer stats collection', operation => NULL,window_name => NULL); exec DBMS_AUTO_TASK_ADMIN.DISABLE( client_name => 'auto space advisor', operation => NULL,window_name => NULL); exec DBMS_AUTO_TASK_ADMIN.DISABLE( client_name => 'sql tuning advisor', operation => NULL,window_name => NULL); commit; exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB'); exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB'); exec DBMS_STATS.SET_PARAM( 'method_opt','FOR ALL COLUMNS SIZE 1' ); commit; shutdown immediate; startup ;
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持 码农网
猜你喜欢:- linux 部署golang 项目(直接部署和基于nginx部署)
- 部署策略对比:蓝绿部署、金丝雀发布及其他
- 使用Docker容器化部署实践之Django应用部署(一)
- 【前端打包部署】谈一谈我在SPA项目打包=>部署的处理
- 「实战篇」开源项目docker化运维部署-后端java部署(七)
- Kubernetes 中的渐进式交付:蓝绿部署和金丝雀部署
本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们。
响应式Web设计
本·弗莱恩 (Ben Frain) / 奇舞团 / 人民邮电出版社 / 2017-2-1 / CNY 59.00
本书将当前Web 设计中热门的响应式设计技术与HTML5 和CSS3 结合起来,为读者全面深入地讲解了针对各种屏幕大小设计和开发现代网站的各种技术。书中不仅讨论了媒体查询、弹性布局、响应式图片,更将最新和最有用的HTML5 和CSS3 技术一并讲解,是学习最新Web 设计技术不可多得的佳作。一起来看看 《响应式Web设计》 这本书的介绍吧!