在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 统信 UOS V20 一键安装 Oracle 12CR2（220118）单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshellins
Oracle 一键安装脚本，演示 统信 UOS V20 一键安装 Oracle 12CR2（220118）单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
image.png
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
✨ 偷懒可以直接下载本文安装包合集：统信 UOS V20 安装 Oracle Oracle 12CR2（220118）单机版安装包合集（包含补丁！！！）
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 3453696911 3月 28 16:44 LINUX.X64_122010_db_home.zip32-rwxr-xr-x 1 root root 169044 3月 28 16:43 OracleShellInstall33-rwxr-xr-x 1 root root 138022236 3月 28 16:43 p33561275_122010_Linux-x86-64.zip34-rwx------ 1 root root 1020001457 3月 28 16:43 p33587128_122010_Linux-x86-64.zip35-rwx------ 1 root root 124109254 3月 28 16:43 p6880880_122010_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 33587128 `# oracle PSU/RU`\13-jpa 33561275 `# 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] : 121617数据库版本: 12 1819#==============================================================# 20配置本地 YUM 源 21#==============================================================# 2223[BaseOS]24name=BaseOS25baseurl=file:///mnt/BaseOS26enabled=127gpgcheck=028[AppStream]29name=AppStream30baseurl=file:///mnt/AppStream31enabled=132gpgcheck=03334#==============================================================# 35禁用防火墙 36#==============================================================# 3738防火墙服务未启动，无需禁用。 3940#==============================================================# 41禁用 SELinux 42#==============================================================# 4344SELinux status: disabled4546#==============================================================# 47YUM 静默安装依赖包 48#==============================================================# 4950bc-1.07.1-7.uelc20.1.x86_6451binutils-2.30-117.0.1.uelc20.04.x86_6452未安装软件包 compat-libcap1 53gcc-8.5.0-10.1.0.3.uelc20.03.x86_6454gcc-c++-8.5.0-10.1.0.3.uelc20.03.x86_6455elfutils-libelf-0.187-4.uelc20.02.x86_6456elfutils-libelf-devel-0.187-4.uelc20.02.x86_6457glibc-2.28-189.5.0.2.uelc20.05.x86_6458glibc-devel-2.28-189.5.0.2.uelc20.05.x86_6459libaio-0.3.112-5.up1.uelc20.01.x86_6460libaio-devel-0.3.112-5.up1.uelc20.01.x86_6461libgcc-8.5.0-10.1.0.3.uelc20.03.x86_6462libstdc++-8.5.0-10.1.0.3.uelc20.03.x86_6463libstdc++-devel-8.5.0-10.1.0.3.uelc20.03.x86_6464libxcb-1.13.1-4.uelc20.1.x86_6465libX11-1.6.8-5.uelc20.4.x86_6466libXau-1.0.9-3.uelc20.x86_6467libXi-1.7.10-1.uelc20.x86_6468libXrender-0.9.10-9.uelc20.1.x86_6469make-4.2.1-12.uelc20.2.x86_6470net-tools-2.0-0.53.20160912git.uelc20.3.x86_6471smartmontools-7.1-1.0.2.uelc20.x86_6472sysstat-11.7.3-7.uelc20.01.x86_6473e2fsprogs-1.45.6-18.uelc20.01.x86_6474e2fsprogs-libs-1.45.6-18.uelc20.01.x86_6475unzip-6.0-46.uelc20.4.x86_6476openssh-clients-8.2p1-19.up1.0.2.uelc20.04.x86_6477readline-7.0-12.uelc20.1.x86_6478readline-devel-7.0-12.uelc20.1.x86_6479psmisc-23.3-1.uelc20.01.x86_6480ksh-20120801-255.uelc20.1.x86_6481nfs-utils-2.5.1-8.up3.uelc20.04.x86_6482tar-1.32-3.uelc20.03.x86_6483device-mapper-multipath-0.8.4-30.uelc20.1.x86_6484avahi-0.7-21.uelc20.6.x86_6485ntp-4.2.8p15-3.uelc20.02.x86_6486chrony-4.2-1.0.1.uelc20.02.x86_6487libXtst-1.2.3-9.uelc20.1.x86_6488libXrender-devel-0.9.10-9.uelc20.1.x86_6489fontconfig-devel-2.13.1-5.uelc20.01.x86_6490policycoreutils-2.9-19.uelc20.x86_6491未安装软件包 policycoreutils-python 92librdmacm-37.2-1.0.3.uelc20.x86_6493未安装软件包 libnsl* 94libibverbs-37.2-1.0.3.uelc20.x86_6495未安装软件包 compat-openssl10 96policycoreutils-python-utils-2.9-19.uelc20.noarch97未安装软件包 elfutils* 98glibc-2.28-189.5.0.2.uelc20.05.x86_6499100#==============================================================# 101配置主机名 102#==============================================================# 103104uosv20105106#==============================================================# 107配置 /etc/hosts 文件 108#==============================================================# 109110127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4111::1 localhost localhost.localdomain localhost6 localhost6.localdomain6112192.168.6.141 uosv20113114#==============================================================# 115创建用户和组 116#==============================================================# 117118oracle 用户： 119120用户id=54321(oracle) 组id=54321(oinstall) 组=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)121122123#==============================================================# 124配置 Avahi-daemon 服务 125#==============================================================# 126127● avahi-daemon.service - Avahi mDNS/DNS-SD Stack128 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)129 Active: inactive (dead)1301313月 29 09:22:41 uosv20 avahi-daemon[1073]: No service file found in /etc/avahi/services.1323月 29 09:22:41 uosv20 avahi-daemon[1073]: Files changed, reloading.1333月 29 09:22:41 uosv20 avahi-daemon[1073]: No service file found in /etc/avahi/services.1343月 29 09:22:43 uosv20 avahi-daemon[1073]: Got SIGTERM, quitting.1353月 29 09:22:43 uosv20 avahi-daemon[1073]: Leaving mDNS multicast group on interface ens33.IPv6 with address fe80::88f9:eb9b:43bc:6d1c.1363月 29 09:22:43 uosv20 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...1373月 29 09:22:43 uosv20 avahi-daemon[1073]: Leaving mDNS multicast group on interface ens33.IPv4 with address 192.168.6.141.1383月 29 09:22:43 uosv20 avahi-daemon[1073]: avahi-daemon 0.7 exiting.1393月 29 09:22:43 uosv20 systemd[1]: avahi-daemon.service: Succeeded.1403月 29 09:22:43 uosv20 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.141142#==============================================================# 143配置透明大页 && NUMA && 磁盘 IO 调度器 144#==============================================================# 145146args="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"147-resume=/dev/mapper/uos-swap148-args="ro149args="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"150-elevator=deadline"151-transparent_hugepage=never152153#==============================================================# 154配置 sysctl.conf 155#==============================================================# 156157net.core.busy_read = 100158vm.dirty_ratio = 50159kernel.sysrq = 0160kernel.panic = 3161fs.aio-max-nr = 1048576162fs.file-max = 6815744163kernel.shmall = 2097152164kernel.shmmax = 8352497663165kernel.shmmni = 4096166kernel.sem = 250 32000 100 128167net.ipv4.ip_local_port_range = 9000 65500168net.core.rmem_default = 262144169net.core.rmem_max = 4194304170net.core.wmem_default = 262144171net.core.wmem_max = 1048576172vm.min_free_kbytes = 32626173net.ipv4.conf.ens33.rp_filter = 1174vm.swappiness = 10175kernel.panic_on_oops = 1176kernel.randomize_va_space = 2177kernel.numa_balancing = 0178179#==============================================================# 180配置 RemoveIPC 181#==============================================================# 182183[Login]184RemoveIPC=no185186#==============================================================# 187配置 /etc/security/limits.conf 和 /etc/pam.d/login 188#==============================================================# 189190查看 /etc/security/limits.conf： 191192* soft core 0193* hard core 0194oracle soft nofile 1024195oracle hard nofile 65536196oracle soft stack 10240197oracle hard stack 32768198oracle soft nproc 2047199oracle hard nproc 16384200oracle hard memlock unlimited201oracle soft memlock unlimited202203查看 /etc/pam.d/login 文件： 204205auth substack system-auth206auth include postlogin207account required pam_nologin.so208account include system-auth209password include system-auth210session required pam_selinux.so close211session required pam_loginuid.so212session required pam_selinux.so open213session required pam_namespace.so214session optional pam_keyinit.so force revoke215session include system-auth216session include postlogin217-session optional pam_ck_connector.so218session required pam_limits.so219session required /lib64/security/pam_limits.so220221#==============================================================# 222配置 /dev/shm 223#==============================================================# 224225/dev/mapper/uos-root / xfs defaults 0 0226UUID=c1af6e7c-5714-4a4e-b05a-2f06a1942dd7 /boot xfs defaults 0 0227/dev/mapper/uos-swap none swap defaults 0 0228tmpfs /dev/shm tmpfs size=8156736k 0 0229230#==============================================================# 231安装 rlwrap 插件 232#==============================================================# 233234成功安装 rlwrap： rlwrap 0.44 235236#==============================================================# 237Root 用户环境变量 238#==============================================================# 239240if [ -f ~/.bashrc ]; then241 . ~/.bashrc242fi243PATH=$PATH:$HOME/bin244export PATH245alias so='su - oracle'246export PS1="[`whoami`@`hostname`:"'$PWD]$ '247248#==============================================================# 249Oracle 用户环境变量 250#==============================================================# 251252if [ -f ~/.bashrc ]; then253 . ~/.bashrc254fi255umask 022256export TMP=/tmp257export TMPDIR=$TMP258export NLS_LANG=AMERICAN_AMERICA.AL32UTF8259export ORACLE_BASE=/u01/app/oracle260export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db261export ORACLE_TERM=xterm262export TNS_ADMIN=$ORACLE_HOME/network/admin263export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib264export ORACLE_SID=lucifer265export PATH=/usr/sbin:$PATH266export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH267export PERL5LIB=$ORACLE_HOME/perl/lib268alias sas='sqlplus / as sysdba'269alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'270alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'271alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'272export PS1="[`whoami`@`hostname`:"'$PWD]$ '273export CV_ASSUME_DISTID=OL7274alias sqlplus='rlwrap sqlplus'275alias rman='rlwrap rman'276alias adrci='rlwrap adrci'277278#==============================================================# 279静默解压 Oracle 软件包 280#==============================================================# 281282正在静默解压缩 Oracle 软件包，请稍等： 283284.---- -. -. . . . .285( .',----- - - ' ' ' __286 \_/ ;--:- __--------------------___ ____=========_||___287__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|288c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |289,_\___________'_|,L______],|______________________|_i,!________________!_i290/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)291""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""292293静默解压 Oracle 软件安装包： /soft/LINUX.X64_122010_db_home.zip 294295静默解压 Oracle 软件补丁包： /soft/p33587128*.zip 296297静默解压 OJVM 软件补丁包： /soft/p33561275*.zip 298299#==============================================================# 300Oracle 安装静默文件 301#==============================================================# 302303oracle.install.option=INSTALL_DB_SWONLY304UNIX_GROUP_NAME=oinstall305INVENTORY_LOCATION=/u01/app/oraInventory306ORACLE_BASE=/u01/app/oracle307oracle.install.db.InstallEdition=EE308oracle.install.db.DBA_GROUP=dba309oracle.install.db.OPER_GROUP=oper310oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0311SELECTED_LANGUAGES=en,zh_CN312ORACLE_HOME=/u01/app/oracle/product/12.2.0/db313oracle.install.db.OSBACKUPDBA_GROUP=backupdba314oracle.install.db.OSDGDBA_GROUP=dgdba315oracle.install.db.OSKMDBA_GROUP=kmdba316oracle.install.db.OSRACDBA_GROUP=racdba317318#==============================================================# 319静默安装数据库软件 320#==============================================================# 321322Starting Oracle Universal Installer...323324Checking Temp space: must be greater than 500 MB. Actual 3982 MB Passed325Checking swap space: must be greater than 150 MB. Actual 8185 MB Passed326Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-03-29_09-23-57AM. Please wait ...You can find the log of this install session at:327 /u01/app/oraInventory/logs/installActions2024-03-29_09-23-57AM.log328329Prepare in progress.330.................................................. 8% Done.331332Prepare successful.333334Copy files in progress.335.................................................. 17% Done.336.................................................. 22% Done.337.................................................. 27% Done.338.................................................. 32% Done.339.................................................. 40% Done.340.................................................. 45% Done.341.................................................. 50% Done.342.................................................. 55% Done.343.................................................. 60% Done.344.................................................. 65% Done.345.................................................. 70% Done.346.................................................. 75% Done.347.................................................. 80% Done.348....................349Copy files successful.350351Link binaries in progress.352..........353Link binaries successful.354355Setup files in progress.356..............................357Setup files successful.358359Setup Inventory in progress.360361Setup Inventory successful.362363Finish Setup successful.364The installation of Oracle Database 12c was successful.365Please check '/u01/app/oraInventory/logs/silentInstall2024-03-29_09-23-57AM.log' for more details.366367Setup Oracle Base in progress.368369Setup Oracle Base successful.370.................................................. 95% Done.371372As a root user, execute the following script(s):373 1. /u01/app/oraInventory/orainstRoot.sh374 2. /u01/app/oracle/product/12.2.0/db/root.sh375376377378.................................................. 100% Done.379Successfully Setup Software.380381#==============================================================# 382执行 root 脚本 383#==============================================================# 384385Changing permissions of /u01/app/oraInventory.386Adding read,write permissions for group.387Removing read,write,execute permissions for world.388389Changing groupname of /u01/app/oraInventory to oinstall.390The execution of the script is complete.391Check /u01/app/oracle/product/12.2.0/db/install/root_uosv20_2024-03-29_09-28-36-858905821.log for the output of root script392393#==============================================================# 394Oracle 软件安装补丁 395#==============================================================# 396397Oracle Interim Patch Installer version 12.2.0.1.30398Copyright (c) 2024, Oracle Corporation. All rights reserved.399400PREREQ session401402Oracle Home : /u01/app/oracle/product/12.2.0/db403Central Inventory : /u01/app/oraInventory404 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc405OPatch version : 12.2.0.1.30406OUI version : 12.2.0.1.4407Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_09-28-42AM_1.log408409Invoking prereq "checkconflictagainstohwithdetail"410411Prereq "checkConflictAgainstOHWithDetail" passed.412413OPatch succeeded.414Oracle Interim Patch Installer version 12.2.0.1.30415Copyright (c) 2024, Oracle Corporation. All rights reserved.416417418Oracle Home : /u01/app/oracle/product/12.2.0/db419Central Inventory : /u01/app/oraInventory420 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc421OPatch version : 12.2.0.1.30422OUI version : 12.2.0.1.4423Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_09-28-44AM_1.log424425Verifying environment and performing prerequisite checks...426OPatch continues with these patches: 33587128 427428Do you want to proceed? [y|n]429Y (auto-answered by -silent)430User Responded with: Y431All checks passed.432433Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.434(Oracle Home = '/u01/app/oracle/product/12.2.0/db')435436437Is the local system ready for patching? [y|n]438Y (auto-answered by -silent)439User Responded with: Y440Backing up files...441Applying interim patch '33587128' to OH '/u01/app/oracle/product/12.2.0/db'442ApplySession: Optional component(s) [ oracle.swd, 12.2.0.1.0 ] , [ oracle.swd.oui, 12.2.0.1.0 ] , [ oracle.network.cman, 12.2.0.1.0 ] , [ oracle.network.gsm, 12.2.0.1.0 ] , [ oracle.rdbms.drdaas, 12.2.0.1.0 ] , [ oracle.ons.cclient, 12.2.0.1.0 ] , [ oracle.ons.daemon, 12.2.0.1.0 ] , [ oracle.ons.eons.bwcompat, 12.2.0.1.0 ] , [ oracle.oid.client, 12.2.0.1.0 ] not present in the Oracle Home or a higher version is found.443444Patching component oracle.rdbms.util, 12.2.0.1.0...445446Patching component oracle.rdbms, 12.2.0.1.0...447448Patching component oracle.network.rsf, 12.2.0.1.0...449450Patching component oracle.rdbms.rsf, 12.2.0.1.0...451452Patching component oracle.ctx, 12.2.0.1.0...453454Patching component oracle.has.common.cvu, 12.2.0.1.0...455456Patching component oracle.ldap.owm, 12.2.0.1.0...457458Patching component oracle.ldap.rsf, 12.2.0.1.0...459460Patching component oracle.nlsrtl.rsf, 12.2.0.1.0...461462Patching component oracle.oracore.rsf, 12.2.0.1.0...463464Patching component oracle.oraolap, 12.2.0.1.0...465466Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...467468Patching component oracle.rdbms.deconfig, 12.2.0.1.0...469470Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...471472Patching component oracle.sdo, 12.2.0.1.0...473474Patching component oracle.sdo.locator, 12.2.0.1.0...475476Patching component oracle.sdo.locator.jrf, 12.2.0.1.0...477478Patching component oracle.tfa, 12.2.0.1.0...479480Patching component oracle.ctx.rsf, 12.2.0.1.0...481482Patching component oracle.rdbms.install.plugins, 12.2.0.1.0...483484Patching component oracle.rdbms.install.common, 12.2.0.1.0...485486Patching component oracle.assistants.deconfig, 12.2.0.1.0...487488Patching component oracle.ons.ic, 12.2.0.1.0...489490Patching component oracle.rdbms.rman, 12.2.0.1.0...491492Patching component oracle.precomp.rsf, 12.2.0.1.0...493494Patching component oracle.install.deinstalltool, 12.2.0.1.0...495496Patching component oracle.assistants.acf, 12.2.0.1.0...497498Patching component oracle.rdbms.oci, 12.2.0.1.0...499500Patching component oracle.sqlplus.ic, 12.2.0.1.0...501502Patching component oracle.xdk.parser.java, 12.2.0.1.0...503504Patching component oracle.dbtoolslistener, 12.2.0.1.0...505506Patching component oracle.ldap.rsf.ic, 12.2.0.1.0...507508Patching component oracle.rdbms.dv, 12.2.0.1.0...509510Patching component oracle.rdbms.lbac, 12.2.0.1.0...511512Patching component oracle.ons, 12.2.0.1.0...513514Patching component oracle.ldap.client, 12.2.0.1.0...515516Patching component oracle.xdk, 12.2.0.1.0...517518Patching component oracle.xdk.rsf, 12.2.0.1.0...519520Patching component oracle.sqlplus, 12.2.0.1.0...521522Patching component oracle.assistants.server, 12.2.0.1.0...523524Patching component oracle.rdbms.crs, 12.2.0.1.0...525526Patching component oracle.precomp.common, 12.2.0.1.0...527528Patching component oracle.precomp.lang, 12.2.0.1.0...529530Patching component oracle.jdk, 1.8.0.91.0...531532OPatch found the word "error" in the stderr of the make command.533Please look at this stderr. You can re-run this make command.534Stderr output:535chmod: changing permissions of '/u01/app/oracle/product/12.2.0/db/bin/extjobO': Operation not permitted536make: [ins_rdbms.mk:533: iextjob] Error 1 (ignored)537538539Patch 33587128 successfully applied.540OPatch Session completed with warnings.541Log file location: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_09-28-44AM_1.log542543OPatch completed with warnings.544545#==============================================================# 546OJVM 补丁安装 547#==============================================================# 548549Oracle Interim Patch Installer version 12.2.0.1.30550Copyright (c) 2024, Oracle Corporation. All rights reserved.551552PREREQ session553554Oracle Home : /u01/app/oracle/product/12.2.0/db555Central Inventory : /u01/app/oraInventory556 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc557OPatch version : 12.2.0.1.30558OUI version : 12.2.0.1.4559Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_09-33-45AM_1.log560561Invoking prereq "checkconflictagainstohwithdetail"562563Prereq "checkConflictAgainstOHWithDetail" passed.564565OPatch succeeded.566Oracle Interim Patch Installer version 12.2.0.1.30567Copyright (c) 2024, Oracle Corporation. All rights reserved.568569570Oracle Home : /u01/app/oracle/product/12.2.0/db571Central Inventory : /u01/app/oraInventory572 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc573OPatch version : 12.2.0.1.30574OUI version : 12.2.0.1.4575Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_09-33-47AM_1.log576577Verifying environment and performing prerequisite checks...578OPatch continues with these patches: 33561275 579580Do you want to proceed? [y|n]581Y (auto-answered by -silent)582User Responded with: Y583All checks passed.584585Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.586(Oracle Home = '/u01/app/oracle/product/12.2.0/db')587588589Is the local system ready for patching? [y|n]590Y (auto-answered by -silent)591User Responded with: Y592Backing up files...593Applying interim patch '33561275' to OH '/u01/app/oracle/product/12.2.0/db'594595Patching component oracle.javavm.server, 12.2.0.1.0...596597Patching component oracle.javavm.server.core, 12.2.0.1.0...598599Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...600601Patching component oracle.javavm.client, 12.2.0.1.0...602603Patching component oracle.rdbms, 12.2.0.1.0...604605Patching component oracle.dbjava.jdbc, 12.2.0.1.0...606607Patching component oracle.dbjava.ic, 12.2.0.1.0...608Patch 33561275 successfully applied.609Log file location: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_09-33-47AM_1.log610611OPatch succeeded.612613#==============================================================# 614Oracle 软件版本 615#==============================================================# 616617618SQL*Plus: Release 12.2.0.1.0 Production619620621#==============================================================# 622Oracle 补丁信息 623#==============================================================# 62462533561275;OJVM RELEASE UPDATE 12.2.0.1.220118 (33561275)62633587128;Database Jan 2022 Release Update : 12.2.0.1.220118 (33587128)627628OPatch succeeded.629630631#==============================================================# 632配置监听 633#==============================================================# 634635636Parsing command line arguments:637 Parameter "silent" = true638 Parameter "responsefile" = /u01/app/oracle/product/12.2.0/db/assistants/netca/netca.rsp639Done parsing command line arguments.640Oracle Net Services Configuration:641Profile configuration complete.642Oracle Net Listener Startup:643 Running Listener Control: 644 /u01/app/oracle/product/12.2.0/db/bin/lsnrctl start LISTENER645 Listener Control complete.646 Listener started successfully.647Listener configuration complete.648Oracle Net Services configuration successful. The exit code is 0649650检查监听状态： 651652653LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 29-MAR-2024 09:34:57654655Copyright (c) 1991, 2016, Oracle. All rights reserved.656657Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=uosv20)(PORT=1521)))658STATUS of the LISTENER659------------------------660Alias LISTENER661Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production662Start Date 29-MAR-2024 09:34:46663Uptime 0 days 0 hr. 0 min. 11 sec664Trace Level off665Security ON: Local OS Authentication666SNMP OFF667Listener Parameter File /u01/app/oracle/product/12.2.0/db/network/admin/listener.ora668Listener Log File /u01/app/oracle/diag/tnslsnr/uosv20/listener/alert/log.xml669Listening Endpoints Summary...670 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=uosv20)(PORT=1521)))671 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))672The listener supports no services673The command completed successfully674675#==============================================================# 676静默建库命令 677#==============================================================# 678679dbca -silent -createDatabase \680-ignorePrereqFailure \681-templateName General_Purpose.dbc \682-responseFile NO_VALUE \683-gdbName lucifer \684-sid lucifer \685-sysPassword oracle \686-systemPassword oracle \687-redoLogFileSize 100 \688-datafileDestination /oradata \689-storageType FS \690-enableArchive true \691-archiveLogDest /oradata \692-databaseConfigType SINGLE \693-characterset AL32UTF8 \694-nationalCharacterSet AL16UTF16 \695-emConfiguration NONE \696-automaticMemoryManagement false \697-totalMemory 3982 \698-databaseType OLTP \699-createAsContainerDatabase false 700701#==============================================================# 702创建数据库 703#==============================================================# 704705[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.706 CAUSE: 707a. 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].708b.The password entered is a keyword that Oracle does not recommend to be used as password709 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.710[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.711 CAUSE: 712a. 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].713b.The password entered is a keyword that Oracle does not recommend to be used as password714 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.715Copying database files7161% complete7172% complete71818% complete71933% complete720Creating and starting Oracle instance72135% complete72240% complete72344% complete72449% complete72550% complete72653% complete72755% complete728Completing Database Creation72956% complete73057% complete73158% complete73262% complete73365% complete73466% complete735Executing Post Configuration Actions736100% complete737Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.738739#==============================================================# 740配置在线重做日志 741#==============================================================# 742743数据库在线重做日志文件： 744745746 THREAD# GROUP# MEMBER size(M)747---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------748 1 1 /oradata/lucifer/redo01.log 100749 1 2 /oradata/lucifer/redo02.log 100750 1 3 /oradata/lucifer/redo03.log 100751 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_m0d78yg8_.log 100752 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_m0d78yky_.log 100753 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_m0d78yot_.log 100754 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_m0d78ysh_.log 100755 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_m0d78yyl_.log 100756757#==============================================================# 758配置 RMAN 备份任务 759#==============================================================# 760761## OracleBegin76200 02 * * * /home/oracle/scripts/del_arch.sh763#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh764#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh765766#==============================================================# 767配置 glogin.sql 768#==============================================================# 769770define _editor=vi771set serveroutput on size 1000000772set pagesize 9999773set long 99999774set trimspool on775col name format a80776set termout off777define gname=idle778column global_name new_value gname779select 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 );780ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';781set sqlprompt '&gname _DATE> '782set termout on783784#==============================================================# 785优化数据库参数 786#==============================================================# 787788数据库参数： 789790791NAME SID SPVALUE VALUE792-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------793_b_tree_bitmap_plans * FALSE FALSE794_datafile_write_errors_crash_instance * FALSE FALSE795audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump796audit_trail * NONE DB797compatible * 12.2.0 12.2.0798control_file_record_keep_time * 31 31799db_block_size * 8192 8192800db_create_file_dest * /oradata /oradata801db_file_multiblock_read_count * 128802db_files * 5000 200803db_name * lucifer lucifer804db_writer_processes * 1805deferred_segment_creation * FALSE FALSE806diagnostic_dest * /u01/app/oracle /u01/app/oracle807dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)808event * 10949 trace name context forever,level 1809event * 28401 trace name context forever,level 1810fast_start_parallel_rollback * LOW811log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog812log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf813max_dump_file_size * unlimited814max_string_size * STANDARD815nls_language * AMERICAN AMERICAN816nls_territory * AMERICA AMERICA817open_cursors * 1000 300818optimizer_adaptive_plans * TRUE819optimizer_adaptive_statistics * FALSE820optimizer_index_caching * 0821optimizer_mode * ALL_ROWS822parallel_force_local * FALSE823parallel_max_servers * 64 64824pga_aggregate_target * 1335885824 835715072825processes * 2000 640826remote_login_passwordfile * EXCLUSIVE EXCLUSIVE827session_cached_cursors * 300 50828sessions * 984829sga_max_size * 5344591872 3355443200830sga_target * 5344591872 3355443200831spfile * /u01/app/oracle/product/12.2.0/db/dbs/spfilelucifer.ora832statistics_level * TYPICAL833undo_retention * 10800 900834835恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y