在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 统信 UOS V20 一键安装 Oracle 19C（19.22）单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshellinstal
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 统信 UOS V20 一键安装 Oracle 19C（19.22）单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
✨ 偷懒可以直接下载本文安装包合集：统信 UOS V20 安装 Oracle 19C（19.22）单机版安装包合集（包含补丁！！！）
1# 主机版本2[root@uosv20 soft]# cat /etc/os-release 3PRETTY_NAME="UOS Server 20"4NAME="UOS Server 20"5VERSION_ID="20"6VERSION="20"7ID=uos8HOME_URL="https://www.chinauos.com/"9BUG_REPORT_URL="https://bbs.chinauos.com/"10VERSION_CODENAME=kongzi11PLATFORM_ID="platform:uelc20"1213# 网络信息14[root@uosv20 soft]# ip a152: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 100016 link/ether 00:0c:29:db:c5:f9 brd ff:ff:ff:ff:ff:ff17 inet 192.168.6.141/24 brd 192.168.6.255 scope global noprefixroute ens3318 valid_lft forever preferred_lft forever19 inet6 fe80::88f9:eb9b:43bc:6d1c/64 scope link noprefixroute 20 valid_lft forever preferred_lft forever2122# 挂载本地 ISO 镜像23[root@uosv20 soft]# mount | grep iso9660 | grep -v "/run/media"24/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)25[root@uosv20 soft]# df -h|grep /mnt26/dev/sr0 7.8G 7.8G 0 100% /mnt2728# 安装包存放在 /soft 目录下29[root@uosv20 ~]# cd /soft/30[root@uosv20 soft]# ll31-rwx------ 1 root root 3059705302 3月 28 18:28 LINUX.X64_193000_db_home.zip32-rwxr-xr-x 1 root root 170166 3月 28 18:26 OracleShellInstall33-rwx------ 1 root root 127451050 3月 28 18:27 p35926646_190000_Linux-x86-64.zip34-rwx------ 1 root root 1817908992 3月 28 18:27 p35943157_190000_Linux-x86-64.zip35-rwx------ 1 root root 127774864 3月 28 18:27 p6880880_190000_Linux-x86-64.zip36-rwx------ 1 root root 321590 3月 28 16:43 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf ens33 `# local ip ifname`\3-n uosv20 `# 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#==============================================================# 2223[BaseOS]24name=BaseOS25baseurl=file:///mnt/BaseOS26enabled=127gpgcheck=028[AppStream]29name=AppStream30baseurl=file:///mnt/AppStream31enabled=132gpgcheck=03334#==============================================================# 35禁用防火墙 36#==============================================================# 3738● firewalld.service - firewalld - dynamic firewall daemon39 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)40 Active: inactive (dead)41 Docs: man:firewalld(1)42433月 28 16:40:22 uosv20 systemd[1]: Starting firewalld - dynamic firewall daemon...443月 28 16:40:25 uosv20 systemd[1]: Started firewalld - dynamic firewall daemon.453月 28 16:40:26 uosv20 firewalld[959]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.463月 28 18:29:38 uosv20 systemd[1]: Stopping firewalld - dynamic firewall daemon...473月 28 18:29:40 uosv20 systemd[1]: firewalld.service: Succeeded.483月 28 18:29:40 uosv20 systemd[1]: Stopped firewalld - dynamic firewall daemon.4950#==============================================================# 51禁用 SELinux 52#==============================================================# 5354SELinux status: disabled5556#==============================================================# 57配置 nsysctl.conf 58#==============================================================# 5960NOZEROCONF=yes6162#==============================================================# 63YUM 静默安装依赖包 64#==============================================================# 6566bc-1.07.1-7.uelc20.1.x86_6467binutils-2.30-117.0.1.uelc20.04.x86_6468未安装软件包 compat-libcap1 69gcc-8.5.0-10.1.0.3.uelc20.03.x86_6470gcc-c++-8.5.0-10.1.0.3.uelc20.03.x86_6471elfutils-libelf-0.187-4.uelc20.02.x86_6472elfutils-libelf-devel-0.187-4.uelc20.02.x86_6473glibc-2.28-189.5.0.2.uelc20.05.x86_6474glibc-devel-2.28-189.5.0.2.uelc20.05.x86_6475libaio-0.3.112-5.up1.uelc20.01.x86_6476libaio-devel-0.3.112-5.up1.uelc20.01.x86_6477libgcc-8.5.0-10.1.0.3.uelc20.03.x86_6478libstdc++-8.5.0-10.1.0.3.uelc20.03.x86_6479libstdc++-devel-8.5.0-10.1.0.3.uelc20.03.x86_6480libxcb-1.13.1-4.uelc20.1.x86_6481libX11-1.6.8-5.uelc20.4.x86_6482libXau-1.0.9-3.uelc20.x86_6483libXi-1.7.10-1.uelc20.x86_6484libXrender-0.9.10-9.uelc20.1.x86_6485make-4.2.1-12.uelc20.2.x86_6486net-tools-2.0-0.53.20160912git.uelc20.3.x86_6487smartmontools-7.1-1.0.2.uelc20.x86_6488sysstat-11.7.3-7.uelc20.01.x86_6489e2fsprogs-1.45.6-18.uelc20.01.x86_6490e2fsprogs-libs-1.45.6-18.uelc20.01.x86_6491unzip-6.0-46.uelc20.4.x86_6492openssh-clients-8.2p1-19.up1.0.2.uelc20.04.x86_6493readline-7.0-12.uelc20.1.x86_6494readline-devel-7.0-12.uelc20.1.x86_6495psmisc-23.3-1.uelc20.01.x86_6496ksh-20120801-255.uelc20.1.x86_6497nfs-utils-2.5.1-8.up3.uelc20.04.x86_6498tar-1.32-3.uelc20.03.x86_6499device-mapper-multipath-0.8.4-30.uelc20.1.x86_64100avahi-0.7-21.uelc20.6.x86_64101ntp-4.2.8p15-3.uelc20.02.x86_64102chrony-4.2-1.0.1.uelc20.02.x86_64103libXtst-1.2.3-9.uelc20.1.x86_64104libXrender-devel-0.9.10-9.uelc20.1.x86_64105fontconfig-devel-2.13.1-5.uelc20.01.x86_64106policycoreutils-2.9-19.uelc20.x86_64107未安装软件包 policycoreutils-python 108librdmacm-37.2-1.0.3.uelc20.x86_64109未安装软件包 libnsl* 110libibverbs-37.2-1.0.3.uelc20.x86_64111未安装软件包 compat-openssl10 112policycoreutils-python-utils-2.9-19.uelc20.noarch113未安装软件包 elfutils* 114glibc-2.28-189.5.0.2.uelc20.05.x86_64115116#==============================================================# 117配置主机名 118#==============================================================# 119120uosv20121122#==============================================================# 123配置 /etc/hosts 文件 124#==============================================================# 125126127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4127::1 localhost localhost.localdomain localhost6 localhost6.localdomain6128192.168.6.141 uosv20129130#==============================================================# 131创建用户和组 132#==============================================================# 133134oracle 用户： 135136用户id=54321(oracle) 组id=54321(oinstall) 组=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)137138139#==============================================================# 140配置 Avahi-daemon 服务 141#==============================================================# 142143● avahi-daemon.service - Avahi mDNS/DNS-SD Stack144 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)145 Active: inactive (dead)1461473月 28 18:30:43 uosv20 avahi-daemon[1073]: No service file found in /etc/avahi/services.1483月 28 18:30:43 uosv20 avahi-daemon[1073]: Files changed, reloading.1493月 28 18:30:43 uosv20 avahi-daemon[1073]: No service file found in /etc/avahi/services.1503月 28 18:30:45 uosv20 avahi-daemon[1073]: Got SIGTERM, quitting.1513月 28 18:30:45 uosv20 avahi-daemon[1073]: Leaving mDNS multicast group on interface ens33.IPv6 with address fe80::88f9:eb9b:43bc:6d1c.1523月 28 18:30:45 uosv20 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...1533月 28 18:30:45 uosv20 avahi-daemon[1073]: Leaving mDNS multicast group on interface ens33.IPv4 with address 192.168.6.141.1543月 28 18:30:45 uosv20 avahi-daemon[1073]: avahi-daemon 0.7 exiting.1553月 28 18:30:45 uosv20 systemd[1]: avahi-daemon.service: Succeeded.1563月 28 18:30:45 uosv20 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.157158#==============================================================# 159配置透明大页 && NUMA && 磁盘 IO 调度器 160#==============================================================# 161162args="ro resume=/dev/mapper/uos-swap rd.lvm.lv=uos/root rd.lvm.lv=uos/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"163-resume=/dev/mapper/uos-swap164-args="ro165args="ro resume=/dev/mapper/uos-swap rd.lvm.lv=uos/root rd.lvm.lv=uos/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"166-elevator=deadline"167-transparent_hugepage=never168169#==============================================================# 170配置 sysctl.conf 171#==============================================================# 172173net.core.busy_read = 100174vm.dirty_ratio = 50175kernel.sysrq = 0176kernel.panic = 3177fs.aio-max-nr = 1048576178fs.file-max = 6815744179kernel.shmall = 2097152180kernel.shmmax = 8352497663181kernel.shmmni = 4096182kernel.sem = 250 32000 100 128183net.ipv4.ip_local_port_range = 9000 65500184net.core.rmem_default = 262144185net.core.rmem_max = 4194304186net.core.wmem_default = 262144187net.core.wmem_max = 1048576188vm.min_free_kbytes = 32626189net.ipv4.conf.ens33.rp_filter = 1190vm.swappiness = 10191kernel.panic_on_oops = 1192kernel.randomize_va_space = 2193kernel.numa_balancing = 0194195#==============================================================# 196配置 RemoveIPC 197#==============================================================# 198199[Login]200RemoveIPC=no201202#==============================================================# 203配置 /etc/security/limits.conf 和 /etc/pam.d/login 204#==============================================================# 205206查看 /etc/security/limits.conf： 207208* soft core 0209* hard core 0210oracle soft nofile 1024211oracle hard nofile 65536212oracle soft stack 10240213oracle hard stack 32768214oracle soft nproc 2047215oracle hard nproc 16384216oracle hard memlock unlimited217oracle soft memlock unlimited218219查看 /etc/pam.d/login 文件： 220221auth substack system-auth222auth include postlogin223account required pam_nologin.so224account include system-auth225password include system-auth226session required pam_selinux.so close227session required pam_loginuid.so228session required pam_selinux.so open229session required pam_namespace.so230session optional pam_keyinit.so force revoke231session include system-auth232session include postlogin233-session optional pam_ck_connector.so234session required pam_limits.so235session required /lib64/security/pam_limits.so236237#==============================================================# 238配置 /dev/shm 239#==============================================================# 240241/dev/mapper/uos-root / xfs defaults 0 0242UUID=c1af6e7c-5714-4a4e-b05a-2f06a1942dd7 /boot xfs defaults 0 0243/dev/mapper/uos-swap none swap defaults 0 0244tmpfs /dev/shm tmpfs size=8156736k 0 0245246#==============================================================# 247安装 rlwrap 插件 248#==============================================================# 249250成功安装 rlwrap： rlwrap 0.44 251252#==============================================================# 253Root 用户环境变量 254#==============================================================# 255256if [ -f ~/.bashrc ]; then257 . ~/.bashrc258fi259PATH=$PATH:$HOME/bin260export PATH261alias so='su - oracle'262export PS1="[`whoami`@`hostname`:"'$PWD]$ '263264#==============================================================# 265Oracle 用户环境变量 266#==============================================================# 267268if [ -f ~/.bashrc ]; then269 . ~/.bashrc270fi271umask 022272export TMP=/tmp273export TMPDIR=$TMP274export NLS_LANG=AMERICAN_AMERICA.AL32UTF8275export ORACLE_BASE=/u01/app/oracle276export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db277export ORACLE_TERM=xterm278export TNS_ADMIN=$ORACLE_HOME/network/admin279export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib280export ORACLE_SID=lucifer281export PATH=/usr/sbin:$PATH282export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH283export PERL5LIB=$ORACLE_HOME/perl/lib284alias sas='sqlplus / as sysdba'285alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'286alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'287alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'288export PS1="[`whoami`@`hostname`:"'$PWD]$ '289export CV_ASSUME_DISTID=OL7290alias sqlplus='rlwrap sqlplus'291alias rman='rlwrap rman'292alias adrci='rlwrap adrci'293294#==============================================================# 295静默解压 Oracle 软件包 296#==============================================================# 297298正在静默解压缩 Oracle 软件包，请稍等： 299300.---- -. -. . . . .301( .',----- - - ' ' ' __302 \_/ ;--:- __--------------------___ ____=========_||___303__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|304c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |305,_\___________'_|,L______],|______________________|_i,!________________!_i306/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)307""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""308309310静默解压 Oracle 软件安装包： /soft/LINUX.X64_193000_db_home.zip 311312静默解压 OPatch 软件补丁包： /soft/p6880880_*.zip 313314静默解压 Oracle 软件补丁包： /soft/p35943157*.zip 315316静默解压 OJVM 软件补丁包： /soft/p35926646*.zip 317318#==============================================================# 319Oracle 安装静默文件 320#==============================================================# 321322oracle.install.option=INSTALL_DB_SWONLY323UNIX_GROUP_NAME=oinstall324INVENTORY_LOCATION=/u01/app/oraInventory325ORACLE_BASE=/u01/app/oracle326oracle.install.db.InstallEdition=EE327oracle.install.db.DBA_GROUP=dba328oracle.install.db.OPER_GROUP=oper329oracle.install.db.OSBACKUPDBA_GROUP=backupdba330oracle.install.db.OSDGDBA_GROUP=dgdba331oracle.install.db.OSKMDBA_GROUP=kmdba332oracle.install.db.OSRACDBA_GROUP=racdba333oracle.install.db.rootconfig.executeRootScript=false334oracle.install.db.rootconfig.configMethod=335oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0336337#==============================================================# 338静默安装数据库软件 339#==============================================================# 340341Preparing the home to patch...342Applying the patch /soft/35943157...343Successfully applied the patch.344The log can be found at: /tmp/InstallActions2024-03-28_06-33-29PM/installerPatchActions_2024-03-28_06-33-29PM.log345Launching Oracle Database Setup Wizard...346347[WARNING] [INS-13014] Target environment does not meet some optional requirements.348 CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2024-03-28_06-33-29PM.log349 ACTION: Identify the list of failed prerequisite checks from the log: installActions2024-03-28_06-33-29PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.350The response file for this session can be found at:351 /u01/app/oracle/product/19.3.0/db/install/response/db_2024-03-28_06-33-29PM.rsp352353You can find the log of this install session at:354 /tmp/InstallActions2024-03-28_06-33-29PM/installActions2024-03-28_06-33-29PM.log355356As a root user, execute the following script(s):357 1. /u01/app/oraInventory/orainstRoot.sh358 2. /u01/app/oracle/product/19.3.0/db/root.sh359360Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 361[uosv20]362Execute /u01/app/oracle/product/19.3.0/db/root.sh on the following nodes: 363[uosv20]364365366Successfully Setup Software with warning(s).367Moved the install session logs to:368 /u01/app/oraInventory/logs/InstallActions2024-03-28_06-33-29PM369370#==============================================================# 371执行 root 脚本 372#==============================================================# 373374Changing permissions of /u01/app/oraInventory.375Adding read,write permissions for group.376Removing read,write,execute permissions for world.377378Changing groupname of /u01/app/oraInventory to oinstall.379The execution of the script is complete.380Check /u01/app/oracle/product/19.3.0/db/install/root_uosv20_2024-03-28_18-59-46-687369635.log for the output of root script381382#==============================================================# 383OJVM 补丁安装 384#==============================================================# 385386Oracle Interim Patch Installer version 12.2.0.1.40387Copyright (c) 2024, Oracle Corporation. All rights reserved.388389PREREQ session390391Oracle Home : /u01/app/oracle/product/19.3.0/db392Central Inventory : /u01/app/oraInventory393 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc394OPatch version : 12.2.0.1.40395OUI version : 12.2.0.7.0396Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-28_18-59-52PM_1.log397398Invoking prereq "checkconflictagainstohwithdetail"399400Prereq "checkConflictAgainstOHWithDetail" passed.401402OPatch succeeded.403Oracle Interim Patch Installer version 12.2.0.1.40404Copyright (c) 2024, Oracle Corporation. All rights reserved.405406407Oracle Home : /u01/app/oracle/product/19.3.0/db408Central Inventory : /u01/app/oraInventory409 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc410OPatch version : 12.2.0.1.40411OUI version : 12.2.0.7.0412Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-28_19-00-10PM_1.log413414Verifying environment and performing prerequisite checks...415OPatch continues with these patches: 35926646 416417Do you want to proceed? [y|n]418Y (auto-answered by -silent)419User Responded with: Y420All checks passed.421422Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.423(Oracle Home = '/u01/app/oracle/product/19.3.0/db')424425426Is the local system ready for patching? [y|n]427Y (auto-answered by -silent)428User Responded with: Y429Backing up files...430Applying interim patch '35926646' to OH '/u01/app/oracle/product/19.3.0/db'431432Patching component oracle.javavm.server, 19.0.0.0.0...433434Patching component oracle.javavm.server.core, 19.0.0.0.0...435436Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...437438Patching component oracle.rdbms, 19.0.0.0.0...439440Patching component oracle.javavm.client, 19.0.0.0.0...441Patch 35926646 successfully applied.442Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-28_19-00-10PM_1.log443444OPatch succeeded.445446#==============================================================# 447Oracle 软件版本 448#==============================================================# 449450451SQL*Plus: Release 19.0.0.0.0 - Production452Version 19.22.0.0.0453454455#==============================================================# 456Oracle 补丁信息 457#==============================================================# 45845935926646;OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)46035943157;Database Release Update : 19.22.0.0.240116 (35943157)46129585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)462463OPatch succeeded.464465466#==============================================================# 467配置监听 468#==============================================================# 469470471Parsing command line arguments:472 Parameter "silent" = true473 Parameter "responsefile" = /u01/app/oracle/product/19.3.0/db/assistants/netca/netca.rsp474Done parsing command line arguments.475Oracle Net Services Configuration:476Profile configuration complete.477Oracle Net Listener Startup:478 Running Listener Control: 479 /u01/app/oracle/product/19.3.0/db/bin/lsnrctl start LISTENER480 Listener Control complete.481 Listener started successfully.482Listener configuration complete.483Oracle Net Services configuration successful. The exit code is 0484485检查监听状态： 486487488LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 28-MAR-2024 19:02:50489490Copyright (c) 1991, 2023, Oracle. All rights reserved.491492Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=uosv20)(PORT=1521)))493STATUS of the LISTENER494------------------------495Alias LISTENER496Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production497Start Date 28-MAR-2024 19:02:39498Uptime 0 days 0 hr. 0 min. 10 sec499Trace Level off500Security ON: Local OS Authentication501SNMP OFF502Listener Parameter File /u01/app/oracle/product/19.3.0/db/network/admin/listener.ora503Listener Log File /u01/app/oracle/diag/tnslsnr/uosv20/listener/alert/log.xml504Listening Endpoints Summary...505 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=uosv20)(PORT=1521)))506 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))507The listener supports no services508The command completed successfully509510#==============================================================# 511静默建库命令 512#==============================================================# 513514dbca -silent -createDatabase \515-ignorePrereqFailure \516-templateName General_Purpose.dbc \517-responseFile NO_VALUE \518-gdbName lucifer \519-sid lucifer \520-sysPassword oracle \521-systemPassword oracle \522-redoLogFileSize 100 \523-datafileDestination /oradata \524-storageType FS \525-enableArchive true \526-archiveLogDest /oradata \527-databaseConfigType SINGLE \528-characterset AL32UTF8 \529-nationalCharacterSet AL16UTF16 \530-emConfiguration NONE \531-automaticMemoryManagement false \532-totalMemory 3982 \533-databaseType OLTP \534-createAsContainerDatabase false 535536#==============================================================# 537创建数据库 538#==============================================================# 539540[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.541 CAUSE: 542a. 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].543b.The password entered is a keyword that Oracle does not recommend to be used as password544 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.545[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.546 CAUSE: 547a. 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].548b.The password entered is a keyword that Oracle does not recommend to be used as password549 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.550Prepare for db operation55110% complete552Copying database files55340% complete554Creating and starting Oracle instance55542% complete55646% complete55750% complete55854% complete55960% complete560Completing Database Creation56166% complete56269% complete56370% complete564Executing Post Configuration Actions565100% complete566Database creation complete. For details check the logfiles at:567 /u01/app/oracle/cfgtoollogs/dbca/lucifer.568Database Information:569Global Database Name:lucifer570System Identifier(SID):lucifer571Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.572573#==============================================================# 574配置在线重做日志 575#==============================================================# 576577数据库在线重做日志文件： 578579580 THREAD# GROUP# MEMBER size(M)581---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------582 1 1 /oradata/LUCIFER/redo01.log 100583 1 2 /oradata/LUCIFER/redo02.log 100584 1 3 /oradata/LUCIFER/redo03.log 100585 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_m0bofcj1_.log 100586 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_m0bofcol_.log 100587 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_m0bofcry_.log 100588 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_m0bofcwo_.log 100589 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_m0bofd2p_.log 100590591#==============================================================# 592配置 RMAN 备份任务 593#==============================================================# 594595## OracleBegin59600 02 * * * /home/oracle/scripts/del_arch.sh597#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh598#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh599600#==============================================================# 601配置 glogin.sql 602#==============================================================# 603604define _editor=vi605set serveroutput on size 1000000606set pagesize 9999607set long 99999608set trimspool on609col name format a80610set termout off611define gname=idle612column global_name new_value gname613select 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 );614ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';615set sqlprompt '&gname _DATE> '616set termout on617618#==============================================================# 619优化数据库参数 620#==============================================================# 621622数据库参数： 623624625NAME SID SPVALUE VALUE626-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------627_b_tree_bitmap_plans * FALSE FALSE628_datafile_write_errors_crash_instance * FALSE FALSE629audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump630audit_trail * NONE DB631compatible * 19.0.0 19.0.0632control_file_record_keep_time * 31 31633db_block_size * 8192 8192634db_create_file_dest * /oradata /oradata635db_file_multiblock_read_count * 128636db_files * 5000 200637db_name * lucifer lucifer638db_writer_processes * 1639deferred_segment_creation * FALSE FALSE640diagnostic_dest * /u01/app/oracle /u01/app/oracle641dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)642event * 10949 trace name context forever,level 1643event * 28401 trace name context forever,level 1644fast_start_parallel_rollback * LOW645log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog646log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf647max_dump_file_size * unlimited648max_string_size * STANDARD649nls_language * AMERICAN AMERICAN650nls_territory * AMERICA AMERICA651open_cursors * 1000 300652optimizer_adaptive_plans * TRUE653optimizer_adaptive_statistics * FALSE654optimizer_index_caching * 0655optimizer_mode * ALL_ROWS656parallel_force_local * FALSE657parallel_max_servers * 64 64658pga_aggregate_target * 1335885824 835715072659processes * 2000 640660remote_login_passwordfile * EXCLUSIVE EXCLUSIVE661session_cached_cursors * 300 50662sessions * 984663sga_max_size * 5344591872 3355443200664sga_target * 5344591872 3355443200665spfile * /u01/app/oracle/product/19.3.0/db/dbs/spfilelucifer.ora666statistics_level * TYPICAL667undo_retention * 10800 900668669恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y