Skip to content

[安装实录] 统信 UOS Server 20 Oracle 11gR2 单机 #3

Description

@pc-study

操作系统 / Operating System

统信 UOS Server 20

Oracle 版本 / Oracle Version

11gR2

安装模式 / Install Mode

单机 / Single

服务器配置 / Server Config

4C 8G 100G

安装命令 / Install Command

# 根据脚本 README 或者 -h 命令提示,编辑好一键安装命令,进入 /soft 目录执行安装:./OracleShellInstall -lf ens33 `# local ip ifname`\-n uosv20 `# hostname`\-op oracle `# oracle password`\-d /u01 `# software base dir`\-ord /oradata `# data dir`\-o lucifer `# dbname`\-dp oracle `# sys/system password`\-ds AL32UTF8 `# database character`\-ns AL16UTF16 `# national character`\-redo 100 `# redo size`\-opa 35574075 `# oracle PSU/RU`\-jpa 35685663 `# OJVM PSU/RU`\-opd Y `# optimize db`

安装耗时 / Install Duration

20分钟

安装过程日志 / Install Log (可选)


验证结果 / Verification

数据库参数:                                                                                    
NAME                                               SID        SPVALUE                                                                          VALUE
-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
_b_tree_bitmap_plans                               *          FALSE                                                                            FALSE
_datafile_write_errors_crash_instance              *          FALSE                                                                            FALSE
audit_file_dest                                    *          /u01/app/oracle/admin/lucifer/adump                                              /u01/app/oracle/admin/lucifer/adump
audit_trail                                        *          NONE                                                                             DB
compatible                                         *          11.2.0.4.0                                                                       11.2.0.4.0
control_file_record_keep_time                      *          31                                                                               31
db_block_size                                      *          8192                                                                             8192
db_create_file_dest                                *          /oradata                                                                         /oradata
db_file_multiblock_read_count                      *                                                                                           128
db_files                                           *          5000                                                                             200
db_name                                            *          lucifer                                                                          lucifer
db_recovery_file_dest                              *          /u01/app/oracle/fast_recovery_area                                               /u01/app/oracle/fast_recovery_area
db_recovery_file_dest_size                         *          4857004032                                                                       4857004032
db_writer_processes                                *                                                                                           1
deferred_segment_creation                          *          FALSE                                                                            FALSE
diagnostic_dest                                    *          /u01/app/oracle                                                                  /u01/app/oracle
dispatchers                                        *          (PROTOCOL=TCP) (SERVICE=luciferXDB)                                              (PROTOCOL=TCP) (SERVICE=luciferXDB)
enable_ddl_logging                                 *          TRUE                                                                             FALSE
event                                              *          10949 trace name context forever,level 1
event                                              *          28401 trace name context forever,level 1
fast_start_parallel_rollback                       *                                                                                           LOW
log_archive_dest_1                                 *          location=/oradata/archivelog                                                     location=/oradata/archivelog
log_archive_format                                 *          %t_%s_%r.dbf                                                                     %t_%s_%r.dbf
max_dump_file_size                                 *                                                                                           unlimited
open_cursors                                       *          1000                                                                             300
optimizer_index_caching                            *                                                                                           0
optimizer_mode                                     *                                                                                           ALL_ROWS
parallel_force_local                               *                                                                                           FALSE
parallel_max_servers                               *          64                                                                               64
pga_aggregate_target                               *          1335885824                                                                       834666496
processes                                          *          2000                                                                             150
remote_login_passwordfile                          *          EXCLUSIVE                                                                        EXCLUSIVE
resource_limit                                     *          TRUE                                                                             FALSE
resource_manager_plan                              *          force:
sec_case_sensitive_logon                           *          FALSE                                                                            TRUE
session_cached_cursors                             *          300                                                                              50
sessions                                           *                                                                                           248
sga_max_size                                       *          5344591872                                                                       3355443200
sga_target                                         *          5344591872                                                                       3355443200
spfile                                             *                                                                                           /u01/app/oracle/product/11.2.0/db/dbs/spfilelucifer.ora
statistics_level                                   *                                                                                           TYPICAL
undo_retention                                     *          10800

使用感受 / Experience

牛而逼之,真正的一键安装,全自动解放双手!

署名 / Author Name

三笠丶

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions