在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 SUSE 15 SP5 一键安装 Oracle 19C（19.22）单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshellinsta
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 SUSE 15 SP5 一键安装 Oracle 19C（19.22）单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
✨ 偷懒可以直接下载本文安装包合集：SUSE 15 SP5 一键安装 Oracle 19C（19.22）单机版安装包合集（包含补丁！！！）
1# 主机版本2suse15:/soft # cat /etc/os-release 3NAME="SLES"4VERSION="15-SP5"5VERSION_ID="15.5"6PRETTY_NAME="SUSE Linux Enterprise Server 15 SP5"7ID="sles"8ID_LIKE="suse"9ANSI_COLOR="0;32"10CPE_NAME="cpe:/o:suse:sles:15:sp5"11DOCUMENTATION_URL="https://documentation.suse.com/"1213# 网络信息14suse15:/soft # ip a152: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 100016 link/ether 00:0c:29:4e:7a:77 brd ff:ff:ff:ff:ff:ff17 altname enp11s018 altname ens19219 inet 192.168.6.138/24 brd 192.168.6.255 scope global eth020 valid_lft forever preferred_lft forever21 inet6 fe80::20c:29ff:fe4e:7a77/64 scope link 22 valid_lft forever preferred_lft forever2324# 挂载本地 ISO 镜像25suse15:/soft # mount | grep iso9660 | grep -v "/run/media"26/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)27suse15:/soft # df -h|grep /mnt28/dev/sr0 14G 14G 0 100% /mnt2930# 安装包存放在 /soft 目录下31suse15:/soft # ll32-rwx------ 1 root root 3059705302 Mar 26 10:36 LINUX.X64_193000_db_home.zip33-rwxr-xr-x 1 root root 164307 Mar 26 10:40 OracleShellInstall34-rwx------ 1 root root 127451050 Mar 26 10:35 p35926646_190000_Linux-x86-64.zip35-rwx------ 1 root root 1817908992 Mar 26 10:36 p35943157_190000_Linux-x86-64.zip36-rwx------ 1 root root 127774864 Mar 26 10:35 p6880880_190000_Linux-x86-64.zip37-rwx------ 1 root root 321590 Mar 26 10:35 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf eth0 `# local ip ifname`\3-n suse15 `# hostname`\4-op oracle `# oracle password`\5-d /u01 `# software base dir`\6-ord /oradata `# data dir`\7-o lucifer `# dbname`\8-dp oracle `# sys/system password`\9-ds AL32UTF8 `# database character`\10-ns AL16UTF16 `# national character`\11-redo 100 `# redo size`\12-opa 35943157 `# oracle PSU/RU`\13-jpa 35926646 `# OJVM PSU/RU`\14-opd Y `# optimize db`默认使用专业版脚本。脚本下载：ora100.com/shell-install
选择需要安装的模式以及版本，即可开始安装：
1 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██2 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██3 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██4░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██5░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██6░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██7 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███8 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 91011请选择安装模式 [单机(si)/单机ASM(sa)/集群(rac)] : si1213数据库安装模式: single 1415请选择数据库版本 [11/12/19/21] : 191617数据库版本: 19 1819#==============================================================# 20配置本地 YUM 源 21#==============================================================# 2223Adding repository 'sles' [...done]24Repository 'sles' successfully added2526URI : dir:/mnt/Module-Basesystem27Enabled : Yes28GPG Check : Yes29Autorefresh : Yes30Priority : 99 (default priority)3132Repository priorities are without effect. All enabled repositories share the same priority.33Adding repository 'sles-Legacy' [...done]34Repository 'sles-Legacy' successfully added3536URI : dir:/mnt/Module-Legacy37Enabled : Yes38GPG Check : Yes39Autorefresh : Yes40Priority : 99 (default priority)4142Repository priorities are without effect. All enabled repositories share the same priority.43Adding repository 'sles-Tools' [...done]44Repository 'sles-Tools' successfully added4546URI : dir:/mnt/Module-Development-Tools47Enabled : Yes48GPG Check : Yes49Autorefresh : Yes50Priority : 99 (default priority)5152Repository priorities are without effect. All enabled repositories share the same priority.5354#==============================================================# 55禁用防火墙 56#==============================================================# 5758○ firewalld.service - firewalld - dynamic firewall daemon59 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: disabled)60 Active: inactive (dead)61 Docs: man:firewalld(1)6263Mar 25 16:02:33 localhost systemd[1]: Starting firewalld - dynamic firewall daemon...64Mar 25 16:02:37 localhost systemd[1]: Started firewalld - dynamic firewall daemon.65Mar 26 16:24:01 suse15 systemd[1]: Stopping firewalld - dynamic firewall daemon...66Mar 26 16:24:03 suse15 systemd[1]: firewalld.service: Deactivated successfully.67Mar 26 16:24:03 suse15 systemd[1]: Stopped firewalld - dynamic firewall daemon.6869#==============================================================# 70YUM 静默安装依赖包 71#==============================================================# 7273bc-1.07.1-11.37.x86_6474binutils-2.39-150100.7.40.1.x86_6475package compat-libcap1 is not installed76gcc-7-3.9.1.x86_6477gcc-c++-7-3.9.1.x86_6478package elfutils-libelf is not installed79package elfutils-libelf-devel is not installed80glibc-2.31-150300.46.1.x86_6481glibc-devel-2.31-150300.46.1.x86_6482package libaio is not installed83libaio-devel-0.3.109-1.25.x86_6484package libgcc is not installed85package libstdc++ is not installed86libstdc++-devel-7-3.9.1.x86_6487package libxcb is not installed88package libX11 is not installed89package libXau is not installed90package libXi is not installed91package libXrender is not installed92make-4.2.1-7.3.2.x86_6493net-tools-2.0+git20170221.479bb4a-3.11.x86_6494smartmontools-7.2-150300.8.8.1.x86_6495sysstat-12.0.2-3.33.1.x86_6496e2fsprogs-1.46.4-150400.3.3.1.x86_6497package e2fsprogs-libs is not installed98unzip-6.00-150000.4.11.1.x86_6499openssh-clients-8.4p1-150300.3.18.2.x86_64100package readline is not installed101readline-devel-7.0-150400.25.22.x86_64102psmisc-23.0-150000.6.22.1.x86_64103package ksh is not installed104package nfs-utils is not installed105tar-1.34-150000.3.31.1.x86_64106package device-mapper-multipath is not installed107avahi-0.8-150400.7.3.1.x86_64108ntp-4.2.8p15-150000.4.22.1.x86_64109chrony-4.1-150400.19.4.x86_64110package libXtst is not installed111libXrender-devel-0.9.10-1.30.x86_64112fontconfig-devel-2.13.1-150400.1.4.x86_64113policycoreutils-3.1-150400.1.5.x86_64114package policycoreutils-python is not installed115package librdmacm is not installed116package libnsl* is not installed117libibverbs-42.0-150500.1.3.x86_64118package compat-openssl10 is not installed119policycoreutils-python-utils-3.1-150400.1.5.noarch120package elfutils* is not installed121glibc-2.31-150300.46.1.x86_64122123#==============================================================# 124配置主机名 125#==============================================================# 126127suse15128129#==============================================================# 130配置 /etc/hosts 文件 131#==============================================================# 132133127.0.0.1 localhost134::1 localhost ipv6-localhost ipv6-loopback135fe00::0 ipv6-localnet136ff00::0 ipv6-mcastprefix137ff02::1 ipv6-allnodes138ff02::2 ipv6-allrouters139ff02::3 ipv6-allhosts140192.168.6.138 suse15141142#==============================================================# 143创建用户和组 144#==============================================================# 145146oracle 用户： 147148uid=54321(oracle) gid=54321(oinstall) groups=54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54321(oinstall)149150151#==============================================================# 152配置 Avahi-daemon 服务 153#==============================================================# 154155○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack156 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)157 Active: inactive (dead)158TriggeredBy: ○ avahi-daemon.socket159160#==============================================================# 161配置透明大页 && NUMA && 磁盘 IO 调度器 162#==============================================================# 163164Generating grub configuration file ...165Found theme: /boot/grub2/themes/SLE/theme.txt166Found linux image: /boot/vmlinuz-5.14.21-150500.53-default167Found initrd image: /boot/initrd-5.14.21-150500.53-default168Adding boot menu entry for UEFI Firmware Settings ...169done170171#==============================================================# 172配置 sysctl.conf 173#==============================================================# 174175fs.aio-max-nr = 1048576176fs.file-max = 6815744177kernel.shmall = 2097152178kernel.shmmax = 8332693503179kernel.shmmni = 4096180kernel.sem = 250 32000 100 128181net.ipv4.ip_local_port_range = 9000 65500182net.core.rmem_default = 262144183net.core.rmem_max = 4194304184net.core.wmem_default = 262144185net.core.wmem_max = 1048576186vm.min_free_kbytes = 32549187net.ipv4.conf.eth0.rp_filter = 1188vm.swappiness = 10189kernel.panic_on_oops = 1190kernel.randomize_va_space = 2191kernel.numa_balancing = 0192193#==============================================================# 194配置 RemoveIPC 195#==============================================================# 196197[Login]198199#==============================================================# 200配置 /etc/security/limits.conf 和 /etc/pam.d/login 201#==============================================================# 202203查看 /etc/security/limits.conf： 204205oracle soft nofile 1024206oracle hard nofile 65536207oracle soft stack 10240208oracle hard stack 32768209oracle soft nproc 2047210oracle hard nproc 16384211oracle hard memlock unlimited212oracle soft memlock unlimited213214查看 /etc/pam.d/login 文件： 215216auth requisite pam_nologin.so217auth include common-auth218account include common-account219password include common-password220session required pam_loginuid.so221session optional pam_keyinit.so force revoke222session include common-session223session optional pam_mail.so standard224session required pam_limits.so225session required /lib64/security/pam_limits.so226227#==============================================================# 228配置 /dev/shm 229#==============================================================# 230231/dev/rootgv/rootlv / xfs defaults 0 0232UUID=e16e4a70-ce93-4f3e-9103-7b9243fcabcc /boot xfs defaults 0 0233UUID=CBDD-C51E /boot/efi vfat utf8 0 2234/dev/rootgv/swaplv swap swap defaults 0 0235tmpfs /dev/shm tmpfs size=8137396k 0 0236237#==============================================================# 238安装 rlwrap 插件 239#==============================================================# 240241成功安装 rlwrap： rlwrap 0.44 242243#==============================================================# 244Root 用户环境变量 245#==============================================================# 246247alias so='su - oracle'248export PS1="[`whoami`@`hostname`:"'$PWD]$ '249250#==============================================================# 251Oracle 用户环境变量 252#==============================================================# 253254umask 022255export TMP=/tmp256export TMPDIR=$TMP257export NLS_LANG=AMERICAN_AMERICA.AL32UTF8258export ORACLE_BASE=/u01/app/oracle259export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db260export ORACLE_TERM=xterm261export TNS_ADMIN=$ORACLE_HOME/network/admin262export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib263export ORACLE_SID=lucifer264export PATH=/usr/sbin:$PATH265export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH266export PERL5LIB=$ORACLE_HOME/perl/lib267alias sas='sqlplus / as sysdba'268alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'269alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'270alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'271export PS1="[`whoami`@`hostname`:"'$PWD]$ '272export CV_ASSUME_DISTID=OL7273alias sqlplus='rlwrap sqlplus'274alias rman='rlwrap rman'275alias adrci='rlwrap adrci'276277#==============================================================# 278静默解压 Oracle 软件包 279#==============================================================# 280281正在静默解压缩 Oracle 软件包，请稍等： 282283.---- -. -. . . . .284( .',----- - - ' ' ' __285 \_/ ;--:- __--------------------___ ____=========_||___286__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|287c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |288,_\___________'_|,L______],|______________________|_i,!________________!_i289/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)290""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""291292293静默解压 Oracle 软件安装包： /soft/LINUX.X64_193000_db_home.zip 294295静默解压 OPatch 软件补丁包： /soft/p6880880_*.zip 296297静默解压 Oracle 软件补丁包： /soft/p35943157*.zip 298299静默解压 OJVM 软件补丁包： /soft/p35926646*.zip 300301#==============================================================# 302Oracle 安装静默文件 303#==============================================================# 304305oracle.install.option=INSTALL_DB_SWONLY306UNIX_GROUP_NAME=oinstall307INVENTORY_LOCATION=/u01/app/oraInventory308ORACLE_BASE=/u01/app/oracle309oracle.install.db.InstallEdition=EE310oracle.install.db.DBA_GROUP=dba311oracle.install.db.OPER_GROUP=oper312oracle.install.db.OSBACKUPDBA_GROUP=backupdba313oracle.install.db.OSDGDBA_GROUP=dgdba314oracle.install.db.OSKMDBA_GROUP=kmdba315oracle.install.db.OSRACDBA_GROUP=racdba316oracle.install.db.rootconfig.executeRootScript=false317oracle.install.db.rootconfig.configMethod=318oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0319320#==============================================================# 321静默安装数据库软件 322#==============================================================# 323324Preparing the home to patch...325Applying the patch /soft/35943157...326Successfully applied the patch.327The log can be found at: /tmp/InstallActions2024-03-26_04-28-37PM/installerPatchActions_2024-03-26_04-28-37PM.log328Launching Oracle Database Setup Wizard...329330[WARNING] [INS-13014] Target environment does not meet some optional requirements.331 CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2024-03-26_04-28-37PM.log332 ACTION: Identify the list of failed prerequisite checks from the log: installActions2024-03-26_04-28-37PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.333The response file for this session can be found at:334 /u01/app/oracle/product/19.3.0/db/install/response/db_2024-03-26_04-28-37PM.rsp335336You can find the log of this install session at:337 /tmp/InstallActions2024-03-26_04-28-37PM/installActions2024-03-26_04-28-37PM.log338339As a root user, execute the following script(s):340 1. /u01/app/oraInventory/orainstRoot.sh341 2. /u01/app/oracle/product/19.3.0/db/root.sh342343Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 344[suse15]345Execute /u01/app/oracle/product/19.3.0/db/root.sh on the following nodes: 346[suse15]347348349Successfully Setup Software with warning(s).350Moved the install session logs to:351 /u01/app/oraInventory/logs/InstallActions2024-03-26_04-28-37PM352353#==============================================================# 354执行 root 脚本 355#==============================================================# 356357Changing permissions of /u01/app/oraInventory.358Adding read,write permissions for group.359Removing read,write,execute permissions for world.360361Changing groupname of /u01/app/oraInventory to oinstall.362The execution of the script is complete.363Check /u01/app/oracle/product/19.3.0/db/install/root_suse15_2024-03-26_16-54-28-422553014.log for the output of root script364365#==============================================================# 366OJVM 补丁安装 367#==============================================================# 368369Oracle Interim Patch Installer version 12.2.0.1.40370Copyright (c) 2024, Oracle Corporation. All rights reserved.371372PREREQ session373374Oracle Home : /u01/app/oracle/product/19.3.0/db375Central Inventory : /u01/app/oraInventory376 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc377OPatch version : 12.2.0.1.40378OUI version : 12.2.0.7.0379Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-26_16-54-33PM_1.log380381Invoking prereq "checkconflictagainstohwithdetail"382383Prereq "checkConflictAgainstOHWithDetail" passed.384385OPatch succeeded.386Oracle Interim Patch Installer version 12.2.0.1.40387Copyright (c) 2024, Oracle Corporation. All rights reserved.388389390Oracle Home : /u01/app/oracle/product/19.3.0/db391Central Inventory : /u01/app/oraInventory392 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc393OPatch version : 12.2.0.1.40394OUI version : 12.2.0.7.0395Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-26_16-54-47PM_1.log396397Verifying environment and performing prerequisite checks...398OPatch continues with these patches: 35926646 399400Do you want to proceed? [y|n]401Y (auto-answered by -silent)402User Responded with: Y403All checks passed.404405Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.406(Oracle Home = '/u01/app/oracle/product/19.3.0/db')407408409Is the local system ready for patching? [y|n]410Y (auto-answered by -silent)411User Responded with: Y412Backing up files...413Applying interim patch '35926646' to OH '/u01/app/oracle/product/19.3.0/db'414415Patching component oracle.javavm.server, 19.0.0.0.0...416417Patching component oracle.javavm.server.core, 19.0.0.0.0...418419Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...420421Patching component oracle.rdbms, 19.0.0.0.0...422423Patching component oracle.javavm.client, 19.0.0.0.0...424Patch 35926646 successfully applied.425Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-26_16-54-47PM_1.log426427OPatch succeeded.428429#==============================================================# 430Oracle 软件版本 431#==============================================================# 432433434SQL*Plus: Release 19.0.0.0.0 - Production435Version 19.22.0.0.0436437438#==============================================================# 439Oracle 补丁信息 440#==============================================================# 44144235926646;OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)44335943157;Database Release Update : 19.22.0.0.240116 (35943157)44429585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)445446OPatch succeeded.447448449#==============================================================# 450配置监听 451#==============================================================# 452453454Parsing command line arguments:455 Parameter "silent" = true456 Parameter "responsefile" = /u01/app/oracle/product/19.3.0/db/assistants/netca/netca.rsp457Done parsing command line arguments.458Oracle Net Services Configuration:459Profile configuration complete.460Oracle Net Listener Startup:461 Running Listener Control: 462 /u01/app/oracle/product/19.3.0/db/bin/lsnrctl start LISTENER463 Listener Control complete.464 Listener started successfully.465Listener configuration complete.466Oracle Net Services configuration successful. The exit code is 0467468检查监听状态： 469470471LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 26-MAR-2024 16:57:14472473Copyright (c) 1991, 2023, Oracle. All rights reserved.474475Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=suse15)(PORT=1521)))476STATUS of the LISTENER477------------------------478Alias LISTENER479Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production480Start Date 26-MAR-2024 16:57:13481Uptime 0 days 0 hr. 0 min. 0 sec482Trace Level off483Security ON: Local OS Authentication484SNMP OFF485Listener Parameter File /u01/app/oracle/product/19.3.0/db/network/admin/listener.ora486Listener Log File /u01/app/oracle/diag/tnslsnr/suse15/listener/alert/log.xml487Listening Endpoints Summary...488 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=suse15)(PORT=1521)))489 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))490The listener supports no services491The command completed successfully492493#==============================================================# 494静默建库命令 495#==============================================================# 496497dbca -silent -createDatabase \498-ignorePrereqFailure \499-templateName General_Purpose.dbc \500-responseFile NO_VALUE \501-gdbName lucifer \502-sid lucifer \503-sysPassword oracle \504-systemPassword oracle \505-redoLogFileSize 100 \506-datafileDestination /oradata \507-storageType FS \508-enableArchive true \509-archiveLogDest /oradata \510-databaseConfigType SINGLE \511-characterset AL32UTF8 \512-nationalCharacterSet AL16UTF16 \513-emConfiguration NONE \514-automaticMemoryManagement false \515-totalMemory 3973 \516-databaseType OLTP \517-createAsContainerDatabase false 518519#==============================================================# 520创建数据库 521#==============================================================# 522523[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.524 CAUSE: 525a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].526b.The password entered is a keyword that Oracle does not recommend to be used as password527 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.528[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.529 CAUSE: 530a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].531b.The password entered is a keyword that Oracle does not recommend to be used as password532 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.533Prepare for db operation53410% complete535Copying database files53640% complete537Creating and starting Oracle instance53842% complete53946% complete54050% complete54154% complete54260% complete543Completing Database Creation54466% complete54569% complete54670% complete547Executing Post Configuration Actions548100% complete549Database creation complete. For details check the logfiles at:550 /u01/app/oracle/cfgtoollogs/dbca/lucifer.551Database Information:552Global Database Name:lucifer553System Identifier(SID):lucifer554Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.555556#==============================================================# 557配置在线重做日志 558#==============================================================# 559560数据库在线重做日志文件： 561562563 THREAD# GROUP# MEMBER size(M)564---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------565 1 1 /oradata/LUCIFER/redo01.log 100566 1 2 /oradata/LUCIFER/redo02.log 100567 1 3 /oradata/LUCIFER/redo03.log 100568 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_m054w6yl_.log 100569 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_m054w747_.log 100570 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_m054w784_.log 100571 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_m054w7dk_.log 100572 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_m054w7k9_.log 100573574#==============================================================# 575配置 RMAN 备份任务 576#==============================================================# 577578## OracleBegin57900 02 * * * /home/oracle/scripts/del_arch.sh580#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh581#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh582583#==============================================================# 584配置 glogin.sql 585#==============================================================# 586587define _editor=vi588set serveroutput on size 1000000589set pagesize 9999590set long 99999591set trimspool on592col name format a80593set termout off594define gname=idle595column global_name new_value gname596select lower(user) || '@' || substr( global_name, 1, decode( dot, 0, length(global_name), dot-1) ) global_name from (select global_name, instr(global_name,'.') dot from global_name );597ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';598set sqlprompt '&gname _DATE> '599set termout on600601#==============================================================# 602优化数据库参数 603#==============================================================# 604605数据库参数： 606607608NAME SID SPVALUE VALUE609-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------610_b_tree_bitmap_plans * FALSE FALSE611_datafile_write_errors_crash_instance * FALSE FALSE612audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump613audit_trail * NONE DB614compatible * 19.0.0 19.0.0615control_file_record_keep_time * 31 31616db_block_size * 8192 8192617db_create_file_dest * /oradata /oradata618db_file_multiblock_read_count * 128619db_files * 5000 200620db_name * lucifer lucifer621db_writer_processes * 1622deferred_segment_creation * FALSE FALSE623diagnostic_dest * /u01/app/oracle /u01/app/oracle624dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)625event * 10949 trace name context forever,level 1626event * 28401 trace name context forever,level 1627fast_start_parallel_rollback * LOW628log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog629log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf630max_dump_file_size * unlimited631max_string_size * STANDARD632nls_language * AMERICAN AMERICAN633nls_territory * AMERICA AMERICA634open_cursors * 1000 300635optimizer_adaptive_plans * TRUE636optimizer_adaptive_statistics * FALSE637optimizer_index_caching * 0638optimizer_mode * ALL_ROWS639parallel_force_local * FALSE640parallel_max_servers * 64 64641pga_aggregate_target * 1332740096 833617920642processes * 2000 640643remote_login_passwordfile * EXCLUSIVE EXCLUSIVE644session_cached_cursors * 300 50645sessions * 984646sga_max_size * 5332008960 3338665984647sga_target * 5332008960 3338665984648spfile * /u01/app/oracle/product/19.3.0/db/dbs/spfilelucifer.ora649statistics_level * TYPICAL650undo_retention * 10800 900651652恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y