在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 12CR2（220118）单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.o
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 12CR2（220118）单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
✨ 偷懒可以直接下载本文安装包合集：openEuler 22.03 LTS SP3 安装 Oracle 12CR2（220118）单机版安装包合集（包含补丁！！！）
1# 主机版本2[root@openEuler soft]# cat /etc/openEuler-release 3openEuler release 22.03 (LTS-SP3)45# 网络信息6[root@openEuler soft]# ip a72: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 10008 link/ether 00:0c:29:6b:8e:70 brd ff:ff:ff:ff:ff:ff9 inet 192.168.6.123/24 brd 192.168.6.255 scope global noprefixroute ens3310 valid_lft forever preferred_lft forever11 inet6 fe80::20c:29ff:fe6b:8e70/64 scope link noprefixroute 12 valid_lft forever preferred_lft forever1314# 挂载本地 ISO 镜像15[root@openEuler soft]# mount | grep iso | grep -v "/run/media"16/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)17[root@openEuler soft]# df -h|grep /mnt18/dev/sr0 18G 18G 0 100% /mnt1920# 安装包存放在 /soft 目录下21[root@openEuler ~]# cd /soft/22[root@openEuler soft]# ll23-rwx------. 1 root root 3453696911 Mar 27 15:56 LINUX.X64_122010_db_home.zip24-rwxr-xr-x. 1 root root 168373 Mar 27 15:56 OracleShellInstall25-rwxr-xr-x. 1 root root 138022236 Mar 27 15:55 p33561275_122010_Linux-x86-64.zip26-rwx------. 1 root root 1020001457 Mar 27 15:55 p33587128_122010_Linux-x86-64.zip27-rwx------. 1 root root 124109254 Mar 27 15:55 p6880880_122010_Linux-x86-64.zip28-rwx------. 1 root root 321590 Mar 20 13:58 rlwrap-0.44.tar.gz29## 注意这个必须要，否则无法安装，报错：30## jskm.c:(.text+0x4081): undefined reference to `stat'31## eobtl.c:(.text+0x914): undefined reference to `fstat'32## 下载：https://mirrors.ustc.edu.cn/centos/7/os/x86_64/Packages/compat-glibc-2.12-4.el7.centos.x86_64.rpm33-rwxr-xr-x. 1 root root 1307484 Mar 27 15:55 compat-glibc-2.12-4.el7.centos.x86_64.rpm默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf ens33 `# local ip ifname`\3-n openEuler `# hostname`\4-op welcome1 `# oracle password`\5-d /u01 `# software base dir`\6-ord /oradata `# data dir`\7-o lucifer `# dbname`\8-dp welcome1 `# 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[openEuler]24name=openEuler25baseurl=file:////mnt26enabled=127gpgcheck=128gpgkey=file:////mnt/RPM-GPG-KEY-openEuler2930#==============================================================# 31禁用防火墙 32#==============================================================# 3334防火墙服务未启动，无需禁用。 3536#==============================================================# 37禁用 SELinux 38#==============================================================# 3940SELinux status: enabled41SELinuxfs mount: /sys/fs/selinux42SELinux root directory: /etc/selinux43Loaded policy name: targeted44Current mode: permissive45Mode from config file: disabled46Policy MLS status: enabled47Policy deny_unknown status: allowed48Memory protection checking: actual (secure)49Max kernel policy version: 335051#==============================================================# 52YUM 静默安装依赖包 53#==============================================================# 5455bc-1.07.1-12.oe2203sp3.x86_6456binutils-2.37-24.oe2203sp3.x86_6457package compat-libcap1 is not installed58gcc-10.3.1-49.oe2203sp3.x86_6459gcc-c++-10.3.1-49.oe2203sp3.x86_6460package elfutils-libelf is not installed61package elfutils-libelf-devel is not installed62glibc-2.34-143.oe2203sp3.x86_6463glibc-devel-2.34-143.oe2203sp3.x86_6464libaio-0.3.113-9.oe2203sp3.x86_6465libaio-devel-0.3.113-9.oe2203sp3.x86_6466libgcc-10.3.1-49.oe2203sp3.x86_6467libstdc++-10.3.1-49.oe2203sp3.x86_6468libstdc++-devel-10.3.1-49.oe2203sp3.x86_6469libxcb-1.15-1.oe2203sp3.x86_6470libX11-1.7.2-8.oe2203sp3.x86_6471libXau-1.0.10-1.oe2203sp3.x86_6472libXi-1.8-2.oe2203sp3.x86_6473libXrender-0.9.10-12.oe2203sp3.x86_6474make-4.3-4.oe2203sp3.x86_6475net-tools-2.10-3.oe2203sp3.x86_6476smartmontools-7.2-2.oe2203sp3.x86_6477sysstat-12.5.4-9.oe2203sp3.x86_6478e2fsprogs-1.46.4-24.oe2203sp3.x86_6479package e2fsprogs-libs is not installed80unzip-6.0-50.oe2203sp3.x86_6481openssh-clients-8.8p1-23.oe2203sp3.x86_6482readline-8.1-3.oe2203sp3.x86_6483readline-devel-8.1-3.oe2203sp3.x86_6484psmisc-23.5-2.oe2203sp3.x86_6485ksh-2020.0.0-10.oe2203sp3.x86_6486nfs-utils-2.5.4-15.oe2203sp3.x86_6487tar-1.34-5.oe2203sp3.x86_6488package device-mapper-multipath is not installed89avahi-0.8-18.oe2203sp3.x86_6490ntp-4.2.8p15-13.oe2203sp3.x86_6491chrony-4.1-6.oe2203sp3.x86_6492libXtst-1.2.4-1.oe2203sp3.x86_6493libXrender-devel-0.9.10-12.oe2203sp3.x86_6494fontconfig-devel-2.13.94-3.oe2203sp3.x86_6495policycoreutils-3.3-8.oe2203sp3.x86_6496package policycoreutils-python is not installed97package librdmacm is not installed98package libnsl* is not installed99package libibverbs is not installed100package compat-openssl10 is not installed101policycoreutils-python-utils-3.3-8.oe2203sp3.noarch102package elfutils* is not installed103glibc-2.34-143.oe2203sp3.x86_64104105#==============================================================# 106配置主机名 107#==============================================================# 108109openEuler110111#==============================================================# 112配置 /etc/hosts 文件 113#==============================================================# 114115127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4116::1 localhost localhost.localdomain localhost6 localhost6.localdomain6117192.168.6.130 openEuler118119#==============================================================# 120创建用户和组 121#==============================================================# 122123oracle 用户： 124125uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)126127128#==============================================================# 129配置 Avahi-daemon 服务 130#==============================================================# 131132○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack133 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)134 Active: inactive (dead)135TriggeredBy: ○ avahi-daemon.socket136137#==============================================================# 138配置透明大页 && NUMA && 磁盘 IO 调度器 139#==============================================================# 140141args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"142-resume=/dev/mapper/openeuler-swap143-args="ro144args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"145-rhgb146-crashkernel=512M147148#==============================================================# 149配置 sysctl.conf 150#==============================================================# 151152kernel.sysrq = 0153net.ipv4.ip_forward = 0154net.ipv4.conf.all.send_redirects = 0155net.ipv4.conf.default.send_redirects = 0156net.ipv4.conf.all.accept_source_route = 0157net.ipv4.conf.default.accept_source_route = 0158net.ipv4.conf.all.accept_redirects = 0159net.ipv4.conf.default.accept_redirects = 0160net.ipv4.conf.all.secure_redirects = 0161net.ipv4.conf.default.secure_redirects = 0162net.ipv4.icmp_echo_ignore_broadcasts = 1163net.ipv4.icmp_ignore_bogus_error_responses = 1164net.ipv4.conf.all.rp_filter = 1165net.ipv4.conf.default.rp_filter = 1166net.ipv4.tcp_syncookies = 1167kernel.dmesg_restrict = 1168net.ipv6.conf.all.accept_redirects = 0169net.ipv6.conf.default.accept_redirects = 0170fs.aio-max-nr = 1048576171fs.file-max = 6815744172kernel.shmall = 2097152173kernel.shmmax = 7795097599174kernel.shmmni = 4096175kernel.sem = 250 32000 100 128176net.ipv4.ip_local_port_range = 9000 65500177net.core.rmem_default = 262144178net.core.rmem_max = 4194304179net.core.wmem_default = 262144180net.core.wmem_max = 1048576181vm.min_free_kbytes = 30449182net.ipv4.conf.ens33.rp_filter = 1183vm.swappiness = 10184kernel.panic_on_oops = 1185kernel.randomize_va_space = 2186kernel.numa_balancing = 0187188#==============================================================# 189配置 RemoveIPC 190#==============================================================# 191192[Login]193RemoveIPC=no194195#==============================================================# 196配置 /etc/security/limits.conf 和 /etc/pam.d/login 197#==============================================================# 198199查看 /etc/security/limits.conf： 200201oracle soft nofile 1024202oracle hard nofile 65536203oracle soft stack 10240204oracle hard stack 32768205oracle soft nproc 2047206oracle hard nproc 16384207oracle hard memlock unlimited208oracle soft memlock unlimited209210查看 /etc/pam.d/login 文件： 211212auth substack system-auth213auth include postlogin214account required pam_nologin.so215account include system-auth216password include system-auth217session required pam_selinux.so close218session required pam_loginuid.so219session required pam_selinux.so open220session required pam_namespace.so221session optional pam_keyinit.so force revoke222session include system-auth223session include postlogin224-session optional pam_ck_connector.so225session required pam_limits.so226session required /lib64/security/pam_limits.so227228#==============================================================# 229配置 /dev/shm 230#==============================================================# 231232/dev/mapper/openeuler-root / ext4 defaults 1 1233UUID=07e6a80f-f2f4-42f8-a1ad-df05bd354960 /boot ext4 defaults 1 2234/dev/mapper/openeuler-swap none swap defaults 0 0235tmpfs /dev/shm tmpfs size=7612400k 0 0236237#==============================================================# 238Root 用户环境变量 239#==============================================================# 240241if [ -f ~/.bashrc ]; then242 . ~/.bashrc243fi244PATH=$PATH:$HOME/bin245export PATH246alias so='su - oracle'247export PS1="[`whoami`@`hostname`:"'$PWD]$ '248249#==============================================================# 250Oracle 用户环境变量 251#==============================================================# 252253[ -f ~/.bashrc ] && . ~/.bashrc254umask 022255export TMP=/tmp256export TMPDIR=$TMP257export NLS_LANG=AMERICAN_AMERICA.AL32UTF8258export ORACLE_BASE=/u01/app/oracle259export ORACLE_HOME=/u01/app/oracle/product/12.2.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静默解压 OJVM 软件补丁包： /soft/p33561275*.zip 294295#==============================================================# 296Oracle 安装静默文件 297#==============================================================# 298299oracle.install.option=INSTALL_DB_SWONLY300UNIX_GROUP_NAME=oinstall301INVENTORY_LOCATION=/u01/app/oraInventory302ORACLE_BASE=/u01/app/oracle303oracle.install.db.InstallEdition=EE304oracle.install.db.DBA_GROUP=dba305oracle.install.db.OPER_GROUP=oper306oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0307SELECTED_LANGUAGES=en,zh_CN308ORACLE_HOME=/u01/app/oracle/product/12.2.0/db309oracle.install.db.OSBACKUPDBA_GROUP=backupdba310oracle.install.db.OSDGDBA_GROUP=dgdba311oracle.install.db.OSKMDBA_GROUP=kmdba312oracle.install.db.OSRACDBA_GROUP=racdba313314#==============================================================# 315静默安装数据库软件 316#==============================================================# 317318Starting Oracle Universal Installer...319320Checking Temp space: must be greater than 500 MB. Actual 3707 MB Passed321Checking swap space: must be greater than 150 MB. Actual 8165 MB Passed322Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-03-27_03-05-02PM. Please wait ...You can find the log of this install session at:323 /u01/app/oraInventory/logs/installActions2024-03-27_03-05-02PM.log324325Prepare in progress.326.................................................. 8% Done.327328Prepare successful.329330Copy files in progress.331.................................................. 17% Done.332.................................................. 22% Done.333.................................................. 27% Done.334.................................................. 32% Done.335.................................................. 40% Done.336.................................................. 45% Done.337.................................................. 50% Done.338.................................................. 55% Done.339.................................................. 60% Done.340.................................................. 65% Done.341.................................................. 70% Done.342.................................................. 75% Done.343.................................................. 80% Done.344....................345Copy files successful.346347Link binaries in progress.348..........349Link binaries successful.350351Setup files in progress.352..............................353Setup files successful.354355Setup Inventory in progress.356357Setup Inventory successful.358359Finish Setup successful.360The installation of Oracle Database 12c was successful.361Please check '/u01/app/oraInventory/logs/silentInstall2024-03-27_03-05-02PM.log' for more details.362363Setup Oracle Base in progress.364365Setup Oracle Base successful.366.................................................. 95% Done.367368As a root user, execute the following script(s):369 1. /u01/app/oraInventory/orainstRoot.sh370 2. /u01/app/oracle/product/12.2.0/db/root.sh371372373374.................................................. 100% Done.375Successfully Setup Software.376377#==============================================================# 378执行 root 脚本 379#==============================================================# 380381Changing permissions of /u01/app/oraInventory.382Adding read,write permissions for group.383Removing read,write,execute permissions for world.384385Changing groupname of /u01/app/oraInventory to oinstall.386The execution of the script is complete.387Check /u01/app/oracle/product/12.2.0/db/install/root_openEuler_2024-03-27_15-09-54-559510622.log for the output of root script388389#==============================================================# 390Oracle 软件安装补丁 391#==============================================================# 392393Oracle Interim Patch Installer version 12.2.0.1.30394Copyright (c) 2024, Oracle Corporation. All rights reserved.395396PREREQ session397398Oracle Home : /u01/app/oracle/product/12.2.0/db399Central Inventory : /u01/app/oraInventory400 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc401OPatch version : 12.2.0.1.30402OUI version : 12.2.0.1.4403Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_15-10-00PM_1.log404405Invoking prereq "checkconflictagainstohwithdetail"406407Prereq "checkConflictAgainstOHWithDetail" passed.408409OPatch succeeded.410Oracle Interim Patch Installer version 12.2.0.1.30411Copyright (c) 2024, Oracle Corporation. All rights reserved.412413414Oracle Home : /u01/app/oracle/product/12.2.0/db415Central Inventory : /u01/app/oraInventory416 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc417OPatch version : 12.2.0.1.30418OUI version : 12.2.0.1.4419Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_15-10-02PM_1.log420421Verifying environment and performing prerequisite checks...422OPatch continues with these patches: 33587128 423424Do you want to proceed? [y|n]425Y (auto-answered by -silent)426User Responded with: Y427All checks passed.428429Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.430(Oracle Home = '/u01/app/oracle/product/12.2.0/db')431432433Is the local system ready for patching? [y|n]434Y (auto-answered by -silent)435User Responded with: Y436Backing up files...437Applying interim patch '33587128' to OH '/u01/app/oracle/product/12.2.0/db'438ApplySession: 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.439440Patching component oracle.rdbms.util, 12.2.0.1.0...441442Patching component oracle.rdbms, 12.2.0.1.0...443444Patching component oracle.network.rsf, 12.2.0.1.0...445446Patching component oracle.rdbms.rsf, 12.2.0.1.0...447448Patching component oracle.ctx, 12.2.0.1.0...449450Patching component oracle.has.common.cvu, 12.2.0.1.0...451452Patching component oracle.ldap.owm, 12.2.0.1.0...453454Patching component oracle.ldap.rsf, 12.2.0.1.0...455456Patching component oracle.nlsrtl.rsf, 12.2.0.1.0...457458Patching component oracle.oracore.rsf, 12.2.0.1.0...459460Patching component oracle.oraolap, 12.2.0.1.0...461462Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...463464Patching component oracle.rdbms.deconfig, 12.2.0.1.0...465466Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...467468Patching component oracle.sdo, 12.2.0.1.0...469470Patching component oracle.sdo.locator, 12.2.0.1.0...471472Patching component oracle.sdo.locator.jrf, 12.2.0.1.0...473474Patching component oracle.tfa, 12.2.0.1.0...475476Patching component oracle.ctx.rsf, 12.2.0.1.0...477478Patching component oracle.rdbms.install.plugins, 12.2.0.1.0...479480Patching component oracle.rdbms.install.common, 12.2.0.1.0...481482Patching component oracle.assistants.deconfig, 12.2.0.1.0...483484Patching component oracle.ons.ic, 12.2.0.1.0...485486Patching component oracle.rdbms.rman, 12.2.0.1.0...487488Patching component oracle.precomp.rsf, 12.2.0.1.0...489490Patching component oracle.install.deinstalltool, 12.2.0.1.0...491492Patching component oracle.assistants.acf, 12.2.0.1.0...493494Patching component oracle.rdbms.oci, 12.2.0.1.0...495496Patching component oracle.sqlplus.ic, 12.2.0.1.0...497498Patching component oracle.xdk.parser.java, 12.2.0.1.0...499500Patching component oracle.dbtoolslistener, 12.2.0.1.0...501502Patching component oracle.ldap.rsf.ic, 12.2.0.1.0...503504Patching component oracle.rdbms.dv, 12.2.0.1.0...505506Patching component oracle.rdbms.lbac, 12.2.0.1.0...507508Patching component oracle.ons, 12.2.0.1.0...509510Patching component oracle.ldap.client, 12.2.0.1.0...511512Patching component oracle.xdk, 12.2.0.1.0...513514Patching component oracle.xdk.rsf, 12.2.0.1.0...515516Patching component oracle.sqlplus, 12.2.0.1.0...517518Patching component oracle.assistants.server, 12.2.0.1.0...519520Patching component oracle.rdbms.crs, 12.2.0.1.0...521522Patching component oracle.precomp.common, 12.2.0.1.0...523524Patching component oracle.precomp.lang, 12.2.0.1.0...525526Patching component oracle.jdk, 1.8.0.91.0...527528OPatch found the word "error" in the stderr of the make command.529Please look at this stderr. You can re-run this make command.530Stderr output:531chmod: changing permissions of '/u01/app/oracle/product/12.2.0/db/bin/extjobO': Operation not permitted532make: [ins_rdbms.mk:533: iextjob] Error 1 (ignored)533534535OPatch Session completed with warnings.536Patch 33587128 successfully applied.537Log file location: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_15-10-02PM_1.log538539OPatch completed with warnings.540541#==============================================================# 542OJVM 补丁安装 543#==============================================================# 544545Oracle Interim Patch Installer version 12.2.0.1.30546Copyright (c) 2024, Oracle Corporation. All rights reserved.547548PREREQ session549550Oracle Home : /u01/app/oracle/product/12.2.0/db551Central Inventory : /u01/app/oraInventory552 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc553OPatch version : 12.2.0.1.30554OUI version : 12.2.0.1.4555Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_15-15-35PM_1.log556557Invoking prereq "checkconflictagainstohwithdetail"558559Prereq "checkConflictAgainstOHWithDetail" passed.560561OPatch succeeded.562Oracle Interim Patch Installer version 12.2.0.1.30563Copyright (c) 2024, Oracle Corporation. All rights reserved.564565566Oracle Home : /u01/app/oracle/product/12.2.0/db567Central Inventory : /u01/app/oraInventory568 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc569OPatch version : 12.2.0.1.30570OUI version : 12.2.0.1.4571Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_15-15-37PM_1.log572573Verifying environment and performing prerequisite checks...574OPatch continues with these patches: 33561275 575576Do you want to proceed? [y|n]577Y (auto-answered by -silent)578User Responded with: Y579All checks passed.580581Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.582(Oracle Home = '/u01/app/oracle/product/12.2.0/db')583584585Is the local system ready for patching? [y|n]586Y (auto-answered by -silent)587User Responded with: Y588Backing up files...589Applying interim patch '33561275' to OH '/u01/app/oracle/product/12.2.0/db'590591Patching component oracle.javavm.server, 12.2.0.1.0...592593Patching component oracle.javavm.server.core, 12.2.0.1.0...594595Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...596597Patching component oracle.javavm.client, 12.2.0.1.0...598599Patching component oracle.rdbms, 12.2.0.1.0...600601Patching component oracle.dbjava.jdbc, 12.2.0.1.0...602603Patching component oracle.dbjava.ic, 12.2.0.1.0...604Patch 33561275 successfully applied.605Log file location: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_15-15-37PM_1.log606607OPatch succeeded.608609#==============================================================# 610Oracle 软件版本 611#==============================================================# 612613614SQL*Plus: Release 12.2.0.1.0 Production615616617#==============================================================# 618Oracle 补丁信息 619#==============================================================# 62062133561275;OJVM RELEASE UPDATE 12.2.0.1.220118 (33561275)62233587128;Database Jan 2022 Release Update : 12.2.0.1.220118 (33587128)623624OPatch succeeded.625626627#==============================================================# 628配置监听 629#==============================================================# 630631632Parsing command line arguments:633 Parameter "silent" = true634 Parameter "responsefile" = /u01/app/oracle/product/12.2.0/db/assistants/netca/netca.rsp635Done parsing command line arguments.636Oracle Net Services Configuration:637Profile configuration complete.638Oracle Net Listener Startup:639 Running Listener Control: 640 /u01/app/oracle/product/12.2.0/db/bin/lsnrctl start LISTENER641 Listener Control complete.642 Listener started successfully.643Listener configuration complete.644Oracle Net Services configuration successful. The exit code is 0645646检查监听状态： 647648649LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 27-MAR-2024 15:16:52650651Copyright (c) 1991, 2016, Oracle. All rights reserved.652653Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=openEuler)(PORT=1522)))654STATUS of the LISTENER655------------------------656Alias LISTENER657Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production658Start Date 27-MAR-2024 15:16:42659Uptime 0 days 0 hr. 0 min. 10 sec660Trace Level off661Security ON: Local OS Authentication662SNMP OFF663Listener Parameter File /u01/app/oracle/product/12.2.0/db/network/admin/listener.ora664Listener Log File /u01/app/oracle/diag/tnslsnr/openEuler/listener/alert/log.xml665Listening Endpoints Summary...666 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=openEuler)(PORT=1522)))667 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))668The listener supports no services669The command completed successfully670671#==============================================================# 672静默建库命令 673#==============================================================# 674675dbca -silent -createDatabase \676-ignorePrereqFailure \677-templateName General_Purpose.dbc \678-responseFile NO_VALUE \679-gdbName lucifer \680-sid lucifer \681-sysPassword welcome1 \682-systemPassword welcome1 \683-redoLogFileSize 100 \684-datafileDestination /oradata \685-storageType FS \686-enableArchive true \687-archiveLogDest /oradata \688-databaseConfigType SINGLE \689-characterset AL32UTF8 \690-nationalCharacterSet AL16UTF16 \691-emConfiguration NONE \692-automaticMemoryManagement false \693-totalMemory 3716 \694-databaseType OLTP \695-createAsContainerDatabase false 696697#==============================================================# 698创建数据库 699#==============================================================# 700701[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.702 CAUSE: 703a. 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].704b.The password entered is a keyword that Oracle does not recommend to be used as password705 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.706[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.707 CAUSE: 708a. 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].709b.The password entered is a keyword that Oracle does not recommend to be used as password710 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.711Copying database files7121% complete7132% complete71418% complete71533% complete716Creating and starting Oracle instance71735% complete71840% complete71944% complete72049% complete72150% complete72253% complete72355% complete724Completing Database Creation72556% complete72657% complete72758% complete72862% complete72965% complete73066% complete731Executing Post Configuration Actions732100% complete733Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.734735#==============================================================# 736配置在线重做日志 737#==============================================================# 738739数据库在线重做日志文件： 740741742 THREAD# GROUP# MEMBER size(M)743---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------744 1 1 /oradata/lucifer/redo01.log 100745 1 2 /oradata/lucifer/redo02.log 100746 1 3 /oradata/lucifer/redo03.log 100747 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_m07lkvkg_.log 100748 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_m07lkvoy_.log 100749 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_m07lkvtd_.log 100750 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_m07lkvyr_.log 100751 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_m07lkw87_.log 100752753#==============================================================# 754配置 RMAN 备份任务 755#==============================================================# 756757## OracleBegin75800 02 * * * /home/oracle/scripts/del_arch.sh759#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh760#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh761762#==============================================================# 763配置 glogin.sql 764#==============================================================# 765766define _editor=vi767set serveroutput on size 1000000768set pagesize 9999769set long 99999770set trimspool on771col name format a80772set termout off773define gname=idle774column global_name new_value gname775select 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 );776ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';777set sqlprompt '&gname _DATE> '778set termout on779780#==============================================================# 781优化数据库参数 782#==============================================================# 783784数据库参数： 785786787NAME SID SPVALUE VALUE788-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------789_b_tree_bitmap_plans * FALSE FALSE790_datafile_write_errors_crash_instance * FALSE FALSE791audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump792audit_trail * NONE DB793compatible * 12.2.0 12.2.0794control_file_record_keep_time * 31 31795db_block_size * 8192 8192796db_create_file_dest * /oradata /oradata797db_file_multiblock_read_count * 128798db_files * 5000 200799db_name * lucifer lucifer800db_writer_processes * 1801deferred_segment_creation * FALSE FALSE802diagnostic_dest * /u01/app/oracle /u01/app/oracle803dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)804event * 10949 trace name context forever,level 1805event * 28401 trace name context forever,level 1806fast_start_parallel_rollback * LOW807log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog808log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf809max_dump_file_size * unlimited810max_string_size * STANDARD811nls_language * AMERICAN AMERICAN812nls_territory * AMERICA AMERICA813open_cursors * 1000 300814optimizer_adaptive_plans * TRUE815optimizer_adaptive_statistics * FALSE816optimizer_index_caching * 0817optimizer_mode * ALL_ROWS818parallel_force_local * FALSE819parallel_max_servers * 64 64820pga_aggregate_target * 1246756864 780140544821processes * 2000 640822remote_login_passwordfile * EXCLUSIVE EXCLUSIVE823session_cached_cursors * 300 50824sessions * 984825sga_max_size * 4988076032 3120562176826sga_target * 4988076032 3120562176827spfile * /u01/app/oracle/product/12.2.0/db/dbs/spfilelucifer.ora828statistics_level * TYPICAL829undo_retention * 10800 900830831恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y