在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 11GR2 单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oraclesh
Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 11GR2 单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
image.png
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
✨ 偷懒可以直接下载本文安装包合集：openEuler 22.03 LTS SP3 安装 Oracle 11GR2（231017） 单机版安装包合集（包含补丁！！！）
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]$ ll23total 305729624-rwxr-xr-x 1 root root 163360 Mar 18 13:05 OracleShellInstall25-rwx------ 1 root root 1395582860 Mar 18 13:06 p13390677_112040_Linux-x86-64_1of7.zip26-rwx------ 1 root root 1151304589 Mar 18 13:06 p13390677_112040_Linux-x86-64_2of7.zip27-rwx------ 1 root root 457726607 Mar 18 13:06 p33477185_112040_Linux-x86-64.zip28-rwx------ 1 root root 8684 Mar 18 13:06 p33991024_11204220118_Generic.zip29-rwx------ 1 root root 125534784 Mar 18 13:06 p6880880_112000_Linux-x86-64.zip30-rwx------ 1 root root 321590 Mar 18 13:06 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：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 35574075 `# oracle PSU/RU`\13-jpa 35685663 `# 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] : 111617数据库版本: 11 1819#==============================================================# 20配置本地 YUM 源 21#==============================================================# 2223[openEuler]24name=openEuler25baseurl=file:////run/media/oracle/openEuler-22.03-LTS-SP3-x86_6426/mnt27enabled=128gpgcheck=129gpgkey=file:////run/media/oracle/openEuler-22.03-LTS-SP3-x86_6430/mnt/RPM-GPG-KEY-openEuler3132#==============================================================# 33禁用防火墙 34#==============================================================# 3536防火墙服务未启动，无需禁用。 3738#==============================================================# 39禁用 SELinux 40#==============================================================# 4142SELinux status: disabled4344#==============================================================# 45YUM 静默安装依赖包 46#==============================================================# 4748bc-1.07.1-12.oe2203sp3.x86_6449binutils-2.37-24.oe2203sp3.x86_6450package compat-libcap1 is not installed51gcc-10.3.1-49.oe2203sp3.x86_6452gcc-c++-10.3.1-49.oe2203sp3.x86_6453package elfutils-libelf is not installed54package elfutils-libelf-devel is not installed55glibc-2.34-143.oe2203sp3.x86_6456glibc-devel-2.34-143.oe2203sp3.x86_6457libaio-0.3.113-9.oe2203sp3.x86_6458libaio-devel-0.3.113-9.oe2203sp3.x86_6459libgcc-10.3.1-49.oe2203sp3.x86_6460libstdc++-10.3.1-49.oe2203sp3.x86_6461libstdc++-devel-10.3.1-49.oe2203sp3.x86_6462libxcb-1.15-1.oe2203sp3.x86_6463libX11-1.7.2-8.oe2203sp3.x86_6464libXau-1.0.10-1.oe2203sp3.x86_6465libXi-1.8-2.oe2203sp3.x86_6466libXrender-0.9.10-12.oe2203sp3.x86_6467make-4.3-4.oe2203sp3.x86_6468net-tools-2.10-3.oe2203sp3.x86_6469smartmontools-7.2-2.oe2203sp3.x86_6470sysstat-12.5.4-9.oe2203sp3.x86_6471e2fsprogs-1.46.4-24.oe2203sp3.x86_6472package e2fsprogs-libs is not installed73unzip-6.0-50.oe2203sp3.x86_6474openssh-clients-8.8p1-23.oe2203sp3.x86_6475readline-8.1-3.oe2203sp3.x86_6476readline-devel-8.1-3.oe2203sp3.x86_6477psmisc-23.5-2.oe2203sp3.x86_6478ksh-2020.0.0-10.oe2203sp3.x86_6479nfs-utils-2.5.4-15.oe2203sp3.x86_6480tar-1.34-5.oe2203sp3.x86_6481package device-mapper-multipath is not installed82avahi-0.8-18.oe2203sp3.x86_6483ntp-4.2.8p15-13.oe2203sp3.x86_6484chrony-4.1-6.oe2203sp3.x86_6485libXtst-1.2.4-1.oe2203sp3.x86_6486libXrender-devel-0.9.10-12.oe2203sp3.x86_6487fontconfig-devel-2.13.94-3.oe2203sp3.x86_6488policycoreutils-3.3-8.oe2203sp3.x86_6489package policycoreutils-python is not installed90package librdmacm is not installed91package libnsl* is not installed92package libibverbs is not installed93package compat-openssl10 is not installed94policycoreutils-python-utils-3.3-8.oe2203sp3.noarch9596#==============================================================# 97配置主机名 98#==============================================================# 99100openEuler101102#==============================================================# 103配置 /etc/hosts 文件 104#==============================================================# 105106127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4107::1 localhost localhost.localdomain localhost6 localhost6.localdomain6108109## OracleBegin110## Public IP111192.168.6.123 openEuler112113#==============================================================# 114创建用户和组 115#==============================================================# 116117oracle 用户： 118119uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)120121122#==============================================================# 123配置 Avahi-daemon 服务 124#==============================================================# 125126○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack127 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)128 Active: inactive (dead)129TriggeredBy: ○ avahi-daemon.socket130131#==============================================================# 132配置透明大页 && NUMA && 磁盘 IO 调度器 133#==============================================================# 134135args="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"136-resume=/dev/mapper/openeuler-swap137-args="ro138args="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"139-rhgb140-crashkernel=512M141142#==============================================================# 143配置 sysctl.conf 144#==============================================================# 145146kernel.sysrq = 0147net.ipv4.ip_forward = 0148net.ipv4.conf.all.send_redirects = 0149net.ipv4.conf.default.send_redirects = 0150net.ipv4.conf.all.accept_source_route = 0151net.ipv4.conf.default.accept_source_route = 0152net.ipv4.conf.all.accept_redirects = 0153net.ipv4.conf.default.accept_redirects = 0154net.ipv4.conf.all.secure_redirects = 0155net.ipv4.conf.default.secure_redirects = 0156net.ipv4.icmp_echo_ignore_broadcasts = 1157net.ipv4.icmp_ignore_bogus_error_responses = 1158net.ipv4.conf.all.rp_filter = 1159net.ipv4.conf.default.rp_filter = 1160net.ipv4.tcp_syncookies = 1161kernel.dmesg_restrict = 1162net.ipv6.conf.all.accept_redirects = 0163net.ipv6.conf.default.accept_redirects = 0164fs.aio-max-nr = 1048576165fs.file-max = 6815744166kernel.shmall = 2097152167kernel.shmmax = 7795085311168kernel.shmmni = 4096169kernel.sem = 250 32000 100 128170net.ipv4.ip_local_port_range = 9000 65500171net.core.rmem_default = 262144172net.core.rmem_max = 4194304173net.core.wmem_default = 262144174net.core.wmem_max = 1048576175vm.min_free_kbytes = 30449176net.ipv4.conf.ens33.rp_filter = 1177vm.swappiness = 10178kernel.panic_on_oops = 1179kernel.randomize_va_space = 2180kernel.numa_balancing = 0181182#==============================================================# 183配置 RemoveIPC 184#==============================================================# 185186[Login]187RemoveIPC=no188189#==============================================================# 190配置 /etc/security/limits.conf 和 /etc/pam.d/login 191#==============================================================# 192193查看 /etc/security/limits.conf： 194195oracle soft nofile 1024196oracle hard nofile 65536197oracle soft stack 10240198oracle hard stack 32768199oracle soft nproc 2047200oracle hard nproc 16384201oracle hard memlock unlimited202oracle soft memlock unlimited203204查看 /etc/pam.d/login 文件： 205206auth substack system-auth207auth include postlogin208account required pam_nologin.so209account include system-auth210password include system-auth211session required pam_selinux.so close212session required pam_loginuid.so213session required pam_selinux.so open214session required pam_namespace.so215session optional pam_keyinit.so force revoke216session include system-auth217session include postlogin218-session optional pam_ck_connector.so219session required pam_limits.so220session required /lib64/security/pam_limits.so221222#==============================================================# 223配置 /dev/shm 224#==============================================================# 225226/dev/mapper/openeuler-root / ext4 defaults 1 1227UUID=ac85e3a2-8535-4088-ae31-19e4938ffcbc /boot ext4 defaults 1 2228/dev/mapper/openeuler-swap none swap defaults 0 0229tmpfs /dev/shm tmpfs size=7612388k 0 0230231#==============================================================# 232Root 用户环境变量 233#==============================================================# 234235if [ -f ~/.bashrc ]; then236 . ~/.bashrc237fi238PATH=$PATH:$HOME/bin239export PATH240alias so='su - oracle'241export PS1="[`whoami`@`hostname`:"'$PWD]$ '242243#==============================================================# 244Oracle 用户环境变量 245#==============================================================# 246247[ -f ~/.bashrc ] && . ~/.bashrc248umask 022249export TMP=/tmp250export TMPDIR=$TMP251export NLS_LANG=AMERICAN_AMERICA.AL32UTF8252export ORACLE_BASE=/u01/app/oracle253export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db254export ORACLE_TERM=xterm255export TNS_ADMIN=$ORACLE_HOME/network/admin256export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib257export ORACLE_SID=lucifer258export PATH=/usr/sbin:$PATH259export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH260export PERL5LIB=$ORACLE_HOME/perl/lib261alias sas='sqlplus / as sysdba'262alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'263alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'264alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'265export PS1="[`whoami`@`hostname`:"'$PWD]$ '266export CV_ASSUME_DISTID=OL7267alias sqlplus='rlwrap sqlplus'268alias rman='rlwrap rman'269alias adrci='rlwrap adrci'270271#==============================================================# 272静默解压 Oracle 软件包 273#==============================================================# 274275正在静默解压缩 Oracle 软件包，请稍等： 276277.---- -. -. . . . .278( .',----- - - ' ' ' __279 \_/ ;--:- __--------------------___ ____=========_||___280__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|281c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |282,_\___________'_|,L______],|______________________|_i,!________________!_i283/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)284""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""285286287静默解压 OJVM 软件补丁包： /soft/p35685663*.zip 288289#==============================================================# 290Oracle 安装静默文件 291#==============================================================# 292293oracle.install.option=INSTALL_DB_SWONLY294UNIX_GROUP_NAME=oinstall295INVENTORY_LOCATION=/u01/app/oraInventory296ORACLE_BASE=/u01/app/oracle297oracle.install.db.InstallEdition=EE298oracle.install.db.DBA_GROUP=dba299oracle.install.db.OPER_GROUP=oper300oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0301SELECTED_LANGUAGES=en,zh_CN302ORACLE_HOME=/u01/app/oracle/product/11.2.0/db303DECLINE_SECURITY_UPDATES=true304oracle.installer.autoupdates.option=SKIP_UPDATES305306#==============================================================# 307静默安装数据库软件 308#==============================================================# 309310Starting Oracle Universal Installer...311312Checking Temp space: must be greater than 120 MB. Actual 3500 MB Passed313Checking swap space: must be greater than 150 MB. Actual 8159 MB Passed314Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-03-19_03-21-08PM. Please wait ...You can find the log of this install session at:315 /u01/app/oraInventory/logs/installActions2024-03-19_03-21-08PM.log316317Prepare in progress.318.................................................. 9% Done.319320Prepare successful.321322Copy files in progress.323.................................................. 14% Done.324.................................................. 20% Done.325.................................................. 26% Done.326.................................................. 31% Done.327.................................................. 36% Done.328.................................................. 41% Done.329.................................................. 47% Done.330.................................................. 52% Done.331.................................................. 57% Done.332.................................................. 63% Done.333.................................................. 68% Done.334.................................................. 73% Done.335.................................................. 78% Done.336.................................................. 83% Done.337..............................338Copy files successful.339340Link binaries in progress.341..........342Link binaries successful.343344Setup files in progress.345.................................................. 88% Done.346.................................................. 94% Done.347348Setup files successful.349The installation of Oracle Database 11g was successful.350Please check '/u01/app/oraInventory/logs/silentInstall2024-03-19_03-21-08PM.log' for more details.351352Execute Root Scripts in progress.353354As a root user, execute the following script(s):355 1. /u01/app/oraInventory/orainstRoot.sh356 2. /u01/app/oracle/product/11.2.0/db/root.sh357358359.................................................. 100% Done.360361Execute Root Scripts successful.362Successfully Setup Software.363364#==============================================================# 365执行 root 脚本 366#==============================================================# 367368Changing permissions of /u01/app/oraInventory.369Adding read,write permissions for group.370Removing read,write,execute permissions for world.371372Changing groupname of /u01/app/oraInventory to oinstall.373The execution of the script is complete.374Check /u01/app/oracle/product/11.2.0/db/install/root_openEuler_2024-03-19_15-23-55.log for the output of root script375376#==============================================================# 377Oracle 软件安装补丁 378#==============================================================# 379380Oracle Interim Patch Installer version 11.2.0.3.44381Copyright (c) 2024, Oracle Corporation. All rights reserved.382383PREREQ session384385Oracle Home : /u01/app/oracle/product/11.2.0/db386Central Inventory : /u01/app/oraInventory387 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc388OPatch version : 11.2.0.3.44389OUI version : 11.2.0.4.0390Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-19_15-23-59PM_1.log391392Invoking prereq "checkconflictagainstohwithdetail"393394Prereq "checkConflictAgainstOHWithDetail" passed.395396OPatch succeeded.397Oracle Interim Patch Installer version 11.2.0.3.44398Copyright (c) 2024, Oracle Corporation. All rights reserved.399400401Oracle Home : /u01/app/oracle/product/11.2.0/db402Central Inventory : /u01/app/oraInventory403 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc404OPatch version : 11.2.0.3.44405OUI version : 11.2.0.4.0406Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-19_15-24-03PM_1.log407408Verifying environment and performing prerequisite checks...409OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075 25869727 26609445 26392168 26925576 27338049 27734982 28204707 28729262 29141056 29497421 29913194 30298532 30670774 31103343 31537677 31983472 32328626 32758711 33128584 33477185 33711103 34057724 34386237 34677698 34998337 35269283 35574075 410411Do you want to proceed? [y|n]412Y (auto-answered by -silent)413User Responded with: Y414All checks passed.415416Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.417(Oracle Home = '/u01/app/oracle/product/11.2.0/db')418419420Is the local system ready for patching? [y|n]421Y (auto-answered by -silent)422User Responded with: Y423Backing up files...424Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db'425426Patching component oracle.rdbms, 11.2.0.4.0...427428Patching component oracle.rdbms.rsf, 11.2.0.4.0...429430Patching component oracle.sdo, 11.2.0.4.0...431432Patching component oracle.sysman.agent, 10.2.0.4.5...433434Patching component oracle.xdk, 11.2.0.4.0...435436Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...437438Patching component oracle.sdo.locator, 11.2.0.4.0...439440Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...441442Patching component oracle.xdk.rsf, 11.2.0.4.0...443444Patching component oracle.rdbms.rman, 11.2.0.4.0...445Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/db'446447Patching component oracle.rdbms, 11.2.0.4.0...448449Patching component oracle.rdbms.rsf, 11.2.0.4.0...450451Patching component oracle.ldap.rsf, 11.2.0.4.0...452453Patching component oracle.rdbms.crs, 11.2.0.4.0...454455Patching component oracle.precomp.common, 11.2.0.4.0...456457Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...458459Patching component oracle.rdbms.deconfig, 11.2.0.4.0...460461Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...462463Patching component oracle.rdbms.rman, 11.2.0.4.0...464Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/db'465466Patching component oracle.rdbms.rsf, 11.2.0.4.0...467468Patching component oracle.rdbms, 11.2.0.4.0...469470Patching component oracle.precomp.common, 11.2.0.4.0...471472Patching component oracle.rdbms.rman, 11.2.0.4.0...473474Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...475476Patching component oracle.rdbms.deconfig, 11.2.0.4.0...477Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/db'478479Patching component oracle.precomp.common, 11.2.0.4.0...480481Patching component oracle.sysman.console.db, 11.2.0.4.0...482483Patching component oracle.rdbms.rsf, 11.2.0.4.0...484485Patching component oracle.rdbms.rman, 11.2.0.4.0...486487Patching component oracle.rdbms, 11.2.0.4.0...488489Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...490491Patching component oracle.ordim.client, 11.2.0.4.0...492493Patching component oracle.ordim.jai, 11.2.0.4.0...494Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/db'495ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.496497Patching component oracle.precomp.common, 11.2.0.4.0...498499Patching component oracle.ovm, 11.2.0.4.0...500501Patching component oracle.xdk, 11.2.0.4.0...502503Patching component oracle.rdbms.util, 11.2.0.4.0...504505Patching component oracle.rdbms, 11.2.0.4.0...506507Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...508509Patching component oracle.xdk.parser.java, 11.2.0.4.0...510511Patching component oracle.oraolap, 11.2.0.4.0...512513Patching component oracle.rdbms.rsf, 11.2.0.4.0...514515Patching component oracle.xdk.rsf, 11.2.0.4.0...516517Patching component oracle.rdbms.rman, 11.2.0.4.0...518519Patching component oracle.rdbms.deconfig, 11.2.0.4.0...520Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/db'521522Patching component oracle.rdbms.dv, 11.2.0.4.0...523524Patching component oracle.rdbms.oci, 11.2.0.4.0...525526Patching component oracle.precomp.common, 11.2.0.4.0...527528Patching component oracle.sysman.agent, 10.2.0.4.5...529530Patching component oracle.xdk, 11.2.0.4.0...531532Patching component oracle.sysman.common, 10.2.0.4.5...533534Patching component oracle.rdbms, 11.2.0.4.0...535536Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...537538Patching component oracle.xdk.parser.java, 11.2.0.4.0...539540Patching component oracle.sysman.console.db, 11.2.0.4.0...541542Patching component oracle.xdk.rsf, 11.2.0.4.0...543544Patching component oracle.rdbms.rsf, 11.2.0.4.0...545546Patching component oracle.sysman.common.core, 10.2.0.4.5...547548Patching component oracle.rdbms.rman, 11.2.0.4.0...549550Patching component oracle.rdbms.deconfig, 11.2.0.4.0...551Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0/db'552553Patching component oracle.sysman.console.db, 11.2.0.4.0...554555Patching component oracle.rdbms, 11.2.0.4.0...556557Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...558559Patching component oracle.rdbms.rsf, 11.2.0.4.0...560Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0/db'561562Patching component oracle.sysman.agent, 10.2.0.4.5...563564Patching component oracle.rdbms.rsf, 11.2.0.4.0...565566Patching component oracle.rdbms.rman, 11.2.0.4.0...567568Patching component oracle.rdbms, 11.2.0.4.0...569Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0/db'570ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.571572Patching component oracle.sysman.agent, 10.2.0.4.5...573574Patching component oracle.ovm, 11.2.0.4.0...575576Patching component oracle.xdk, 11.2.0.4.0...577578Patching component oracle.rdbms, 11.2.0.4.0...579580Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...581582Patching component oracle.xdk.parser.java, 11.2.0.4.0...583584Patching component oracle.sysman.console.db, 11.2.0.4.0...585586Patching component oracle.xdk.rsf, 11.2.0.4.0...587588Patching component oracle.rdbms.rsf, 11.2.0.4.0...589590Patching component oracle.sysman.oms.core, 10.2.0.4.5...591Applying sub-patch '22502456' to OH '/u01/app/oracle/product/11.2.0/db'592ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.593594Patching component oracle.precomp.common, 11.2.0.4.0...595596Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...597598Patching component oracle.rdbms.olap, 11.2.0.4.0...599600Patching component oracle.oraolap, 11.2.0.4.0...601602Patching component oracle.rdbms.rsf, 11.2.0.4.0...603604Patching component oracle.rdbms.rman, 11.2.0.4.0...605606Patching component oracle.rdbms, 11.2.0.4.0...607608Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...609Applying sub-patch '23054359' to OH '/u01/app/oracle/product/11.2.0/db'610611Patching component oracle.rdbms.dv, 11.2.0.4.0...612613Patching component oracle.rdbms, 11.2.0.4.0...614615Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...616617Patching component oracle.rdbms.rsf, 11.2.0.4.0...618Applying sub-patch '24006111' to OH '/u01/app/oracle/product/11.2.0/db'619620Patching component oracle.sqlplus.ic, 11.2.0.4.0...621622Patching component oracle.sqlplus, 11.2.0.4.0...623624Patching component oracle.rdbms.rsf, 11.2.0.4.0...625626Patching component oracle.rdbms, 11.2.0.4.0...627628Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...629Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0/db'630631Patching component oracle.precomp.common, 11.2.0.4.0...632633Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...634635Patching component oracle.sqlplus.ic, 11.2.0.4.0...636637Patching component oracle.sqlplus, 11.2.0.4.0...638639Patching component oracle.rdbms.rsf, 11.2.0.4.0...640641Patching component oracle.rdbms, 11.2.0.4.0...642643Patching component oracle.rdbms.util, 11.2.0.4.0...644645Patching component oracle.ordim.client, 11.2.0.4.0...646647Patching component oracle.ordim.jai, 11.2.0.4.0...648649Patching component oracle.ordim.server, 11.2.0.4.0...650Applying sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0/db'651ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.652653Patching component oracle.ldap.rsf, 11.2.0.4.0...654655Patching component oracle.oracore.rsf, 11.2.0.4.0...656657Patching component oracle.rdbms, 11.2.0.4.0...658659Patching component oracle.rdbms.rsf, 11.2.0.4.0...660661Patching component oracle.rdbms.rman, 11.2.0.4.0...662Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/db'663664Patching component oracle.oracore.rsf, 11.2.0.4.0...665666Patching component oracle.rdbms, 11.2.0.4.0...667Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0/db'668ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.669670Patching component oracle.network.rsf, 11.2.0.4.0...671672Patching component oracle.ldap.client, 11.2.0.4.0...673674Patching component oracle.sysman.agent, 10.2.0.4.5...675676Patching component oracle.xdk, 11.2.0.4.0...677678Patching component oracle.rdbms, 11.2.0.4.0...679680Patching component oracle.network.listener, 11.2.0.4.0...681682Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...683684Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...685686Patching component oracle.xdk.parser.java, 11.2.0.4.0...687688Patching component oracle.xdk.rsf, 11.2.0.4.0...689690Patching component oracle.rdbms.rsf, 11.2.0.4.0...691692Patching component oracle.rdbms.rman, 11.2.0.4.0...693Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0/db'694695Patching component oracle.rdbms, 11.2.0.4.0...696697Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...698699Patching component oracle.rdbms.rman, 11.2.0.4.0...700701Patching component oracle.rdbms.rsf, 11.2.0.4.0...702Applying sub-patch '27338049' to OH '/u01/app/oracle/product/11.2.0/db'703704Patching component oracle.assistants.server, 11.2.0.4.0...705706Patching component oracle.rdbms.rsf, 11.2.0.4.0...707708Patching component oracle.rdbms, 11.2.0.4.0...709710Patching component oracle.rdbms.rman, 11.2.0.4.0...711712Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...713Applying sub-patch '27734982' to OH '/u01/app/oracle/product/11.2.0/db'714715Patching component oracle.ctx, 11.2.0.4.0...716717Patching component oracle.rdbms.rsf, 11.2.0.4.0...718719Patching component oracle.ctx.rsf, 11.2.0.4.0...720721Patching component oracle.rdbms, 11.2.0.4.0...722723Patching component oracle.rdbms.rman, 11.2.0.4.0...724Applying sub-patch '28204707' to OH '/u01/app/oracle/product/11.2.0/db'725Applying changes to emctl script on the home: /u01/app/oracle/product/11.2.0/db ...726727Patching component oracle.rdbms, 11.2.0.4.0...728729Patching component oracle.oracore.rsf, 11.2.0.4.0...730731Patching component oracle.rdbms.rsf, 11.2.0.4.0...732733Patching component oracle.ldap.rsf, 11.2.0.4.0...734735Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...736737Patching component oracle.network.rsf, 11.2.0.4.0...738739Patching component oracle.sysman.agent, 10.2.0.4.5...740741Patching component oracle.sysman.console.db, 11.2.0.4.0...742743Patching component oracle.ldap.security.osdt, 11.2.0.4.0...744745Patching component oracle.ldap.owm, 11.2.0.4.0...746747Patching component oracle.sqlplus.rsf, 11.2.0.4.0...748749Patching component oracle.ctx, 11.2.0.4.0...750Applying sub-patch '28729262' to OH '/u01/app/oracle/product/11.2.0/db'751INFO: Script isn't applicable to this port!752753Patching component oracle.rdbms, 11.2.0.4.0...754755Patching component oracle.rdbms.rsf, 11.2.0.4.0...756757Patching component oracle.rdbms.util, 11.2.0.4.0...758759Patching component oracle.ldap.rsf, 11.2.0.4.0...760761Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...762763Patching component oracle.network.rsf, 11.2.0.4.0...764765Patching component oracle.rdbms.rman, 11.2.0.4.0...766767Patching component oracle.ctx, 11.2.0.4.0...768Applying sub-patch '29141056' to OH '/u01/app/oracle/product/11.2.0/db'769770Patching component oracle.rdbms, 11.2.0.4.0...771772Patching component oracle.rdbms.rman, 11.2.0.4.0...773774Patching component oracle.oracore.rsf, 11.2.0.4.0...775776Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...777778Patching component oracle.rdbms.rsf, 11.2.0.4.0...779Applying sub-patch '29497421' to OH '/u01/app/oracle/product/11.2.0/db'780781Patching component oracle.rdbms, 11.2.0.4.0...782783Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...784785Patching component oracle.rdbms.rman, 11.2.0.4.0...786787Patching component oracle.rdbms.rsf, 11.2.0.4.0...788789Patching component oracle.ldap.rsf, 11.2.0.4.0...790791Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...792793Patching component oracle.oracore.rsf, 11.2.0.4.0...794795Patching component oracle.ctx, 11.2.0.4.0...796Applying sub-patch '29913194' to OH '/u01/app/oracle/product/11.2.0/db'797798Patching component oracle.rdbms, 11.2.0.4.0...799800Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...801802Patching component oracle.rdbms.rsf, 11.2.0.4.0...803804Patching component oracle.network.rsf, 11.2.0.4.0...805806Patching component oracle.ldap.rsf, 11.2.0.4.0...807808Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...809810Patching component oracle.rdbms.util, 11.2.0.4.0...811Applying sub-patch '30298532' to OH '/u01/app/oracle/product/11.2.0/db'812ApplySession: Optional component(s) [ oracle.rdbms.tg4tera, 11.2.0.4.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.813814Patching component oracle.rdbms.rsf, 11.2.0.4.0...815816Patching component oracle.rdbms, 11.2.0.4.0...817818Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...819820Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...821822Patching component oracle.ldap.rsf, 11.2.0.4.0...823824Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...825Applying sub-patch '30670774' to OH '/u01/app/oracle/product/11.2.0/db'826827Patching component oracle.rdbms.rsf, 11.2.0.4.0...828829Patching component oracle.rdbms, 11.2.0.4.0...830831Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...832833Patching component oracle.network.rsf, 11.2.0.4.0...834835Patching component oracle.ldap.rsf, 11.2.0.4.0...836837Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...838839Patching component oracle.swd.oui, 11.2.0.4.0...840841Patching component oracle.ctx, 11.2.0.4.0...842Applying sub-patch '31103343' to OH '/u01/app/oracle/product/11.2.0/db'843844Patching component oracle.rdbms, 11.2.0.4.0...845846Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...847848Patching component oracle.rdbms.rsf, 11.2.0.4.0...849Applying sub-patch '31537677' to OH '/u01/app/oracle/product/11.2.0/db'850851Patching component oracle.rdbms, 11.2.0.4.0...852853Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...854855Patching component oracle.rdbms.rsf, 11.2.0.4.0...856857Patching component oracle.rdbms.dv, 11.2.0.4.0...858859Patching component oracle.rdbms.rman, 11.2.0.4.0...860861Patching component oracle.ldap.rsf, 11.2.0.4.0...862863Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...864865Patching component oracle.oracore.rsf, 11.2.0.4.0...866867Patching component oracle.rdbms.util, 11.2.0.4.0...868869Patching component oracle.dbdev, 11.2.0.4.0...870871Patching component oracle.ctx, 11.2.0.4.0...872873Patching component oracle.buildtools.rsf, 11.2.0.4.0...874Applying sub-patch '31983472' to OH '/u01/app/oracle/product/11.2.0/db'875876Patching component oracle.rdbms.rsf, 11.2.0.4.0...877878Patching component oracle.rdbms, 11.2.0.4.0...879880Patching component oracle.ctx, 11.2.0.4.0...881Applying sub-patch '32328626' to OH '/u01/app/oracle/product/11.2.0/db'882883Patching component oracle.rdbms, 11.2.0.4.0...884885Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...886887Patching component oracle.rdbms.rsf, 11.2.0.4.0...888889Patching component oracle.rdbms.dv, 11.2.0.4.0...890891Patching component oracle.rdbms.rman, 11.2.0.4.0...892893Patching component oracle.ldap.rsf, 11.2.0.4.0...894895Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...896Applying sub-patch '32758711' to OH '/u01/app/oracle/product/11.2.0/db'897898Patching component oracle.rdbms, 11.2.0.4.0...899900Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...901902Patching component oracle.ctx, 11.2.0.4.0...903904Patching component oracle.network.rsf, 11.2.0.4.0...905Applying sub-patch '33128584' to OH '/u01/app/oracle/product/11.2.0/db'906907Patching component oracle.rdbms, 11.2.0.4.0...908909Patching component oracle.rdbms.rsf, 11.2.0.4.0...910911Patching component oracle.ctx, 11.2.0.4.0...912Applying sub-patch '33477185' to OH '/u01/app/oracle/product/11.2.0/db'913914Patching component oracle.rdbms, 11.2.0.4.0...915916Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...917918Patching component oracle.rdbms.rsf, 11.2.0.4.0...919920Patching component oracle.network.rsf, 11.2.0.4.0...921922Patching component oracle.rdbms.dv, 11.2.0.4.0...923Applying sub-patch '33711103' to OH '/u01/app/oracle/product/11.2.0/db'924ApplySession: Optional component(s) [ oracle.rdbms.tg4tera, 11.2.0.4.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.4.0 ] , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.925926Patching component oracle.rdbms.rsf, 11.2.0.4.0...927928Patching component oracle.rdbms, 11.2.0.4.0...929930Patching component oracle.rdbms.rsf, 11.2.0.4.0...931932Patching component oracle.network.rsf, 11.2.0.4.0...933934Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...935936Patching component oracle.rdbms.hs_common, 11.2.0.4.0...937938Patching component oracle.buildtools.rsf, 11.2.0.4.0...939940Patching component oracle.buildtools.rsf, 11.2.0.4.0...941Applying sub-patch '34057724' to OH '/u01/app/oracle/product/11.2.0/db'942ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.943944Patching component oracle.rdbms, 11.2.0.4.0...945946Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...947948Patching component oracle.rdbms.rsf, 11.2.0.4.0...949950Patching component oracle.network.rsf, 11.2.0.4.0...951952Patching component oracle.ldap.rsf, 11.2.0.4.0...953954Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...955956Patching component oracle.swd.oui.core, 11.2.0.4.0...957Applying sub-patch '34386237' to OH '/u01/app/oracle/product/11.2.0/db'958ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.959960Patching component oracle.rdbms, 11.2.0.4.0...961962Patching component oracle.rdbms.rsf, 11.2.0.4.0...963964Patching component oracle.network.rsf, 11.2.0.4.0...965966Patching component oracle.swd.oui.core, 11.2.0.4.0...967968Patching component oracle.ctx, 11.2.0.4.0...969Applying sub-patch '34677698' to OH '/u01/app/oracle/product/11.2.0/db'970ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.971972Patching component oracle.rdbms, 11.2.0.4.0...973974Patching component oracle.rdbms.rsf, 11.2.0.4.0...975976Patching component oracle.javavm.containers, 11.2.0.4.0...977Applying sub-patch '34998337' to OH '/u01/app/oracle/product/11.2.0/db'978ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.979980Patching component oracle.rdbms, 11.2.0.4.0...981982Patching component oracle.rdbms.rsf, 11.2.0.4.0...983Applying sub-patch '35269283' to OH '/u01/app/oracle/product/11.2.0/db'984ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.985986Patching component oracle.rdbms, 11.2.0.4.0...987988Patching component oracle.network.rsf, 11.2.0.4.0...989990Patching component oracle.rdbms.rsf, 11.2.0.4.0...991992Patching component oracle.dbdev, 11.2.0.4.0...993Applying sub-patch '35574075' to OH '/u01/app/oracle/product/11.2.0/db'994ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.995996Patching component oracle.rdbms, 11.2.0.4.0...997998Patching component oracle.rdbms.rsf, 11.2.0.4.0...9991000Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10011002Patching component oracle.network.rsf, 11.2.0.4.0...10031004Patching component oracle.rdbms.rsf, 11.2.0.4.0...10051006Patching component oracle.sysman.oms.core, 10.2.0.4.5...10071008Patching component oracle.marvel, 11.2.0.4.0...10091010Patching component oracle.javavm.containers, 11.2.0.4.0...10111012Patching component oracle.dbjava.ucp, 11.2.0.4.0...10131014Patching component oracle.owb.rsf, 11.2.0.4.0...10151016Patching component oracle.sysman.ccr, 10.3.8.1.0...10171018Patching component oracle.sysman.ccr.client, 10.3.2.1.0...10191020Patching component oracle.sysman.common, 10.2.0.4.5...10211022Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10231024Patching component oracle.javavm.containers, 11.2.0.4.0...1025Composite patch 35574075 successfully applied.1026Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-19_15-24-03PM_1.log10271028OPatch succeeded.10291030#==============================================================# 1031Oracle 软件安装补丁 33991024 1032#==============================================================# 10331034Oracle Interim Patch Installer version 11.2.0.3.441035Copyright (c) 2024, Oracle Corporation. All rights reserved.10361037PREREQ session10381039Oracle Home : /u01/app/oracle/product/11.2.0/db1040Central Inventory : /u01/app/oraInventory1041 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1042OPatch version : 11.2.0.3.441043OUI version : 11.2.0.4.01044Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-19_15-34-57PM_1.log10451046Invoking prereq "checkconflictagainstohwithdetail"10471048Prereq "checkConflictAgainstOHWithDetail" passed.10491050OPatch succeeded.1051Oracle Interim Patch Installer version 11.2.0.3.441052Copyright (c) 2024, Oracle Corporation. All rights reserved.105310541055Oracle Home : /u01/app/oracle/product/11.2.0/db1056Central Inventory : /u01/app/oraInventory1057 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1058OPatch version : 11.2.0.3.441059OUI version : 11.2.0.4.01060Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-19_15-35-00PM_1.log10611062Verifying environment and performing prerequisite checks...1063OPatch continues with these patches: 33991024 10641065Do you want to proceed? [y|n]1066Y (auto-answered by -silent)1067User Responded with: Y1068All checks passed.10691070Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1071(Oracle Home = '/u01/app/oracle/product/11.2.0/db')107210731074Is the local system ready for patching? [y|n]1075Y (auto-answered by -silent)1076User Responded with: Y1077Backing up files...1078Applying interim patch '33991024' to OH '/u01/app/oracle/product/11.2.0/db'10791080Patching component oracle.rdbms.rsf, 11.2.0.4.0...10811082Patching component oracle.buildtools.rsf, 11.2.0.4.0...10831084Patching component oracle.has.db, 11.2.0.4.0...1085Patch 33991024 successfully applied.1086Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-19_15-35-00PM_1.log10871088OPatch succeeded.10891090#==============================================================# 1091Oracle 执行 relink 1092#==============================================================# 10931094writing relink log to: /u01/app/oracle/product/11.2.0/db/install/relink.log10951096#==============================================================# 1097OJVM 补丁安装 1098#==============================================================# 10991100Oracle Interim Patch Installer version 11.2.0.3.441101Copyright (c) 2024, Oracle Corporation. All rights reserved.11021103PREREQ session11041105Oracle Home : /u01/app/oracle/product/11.2.0/db1106Central Inventory : /u01/app/oraInventory1107 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1108OPatch version : 11.2.0.3.441109OUI version : 11.2.0.4.01110Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-19_15-36-10PM_1.log11111112Invoking prereq "checkconflictagainstohwithdetail"11131114Prereq "checkConflictAgainstOHWithDetail" passed.11151116OPatch succeeded.1117Oracle Interim Patch Installer version 11.2.0.3.441118Copyright (c) 2024, Oracle Corporation. All rights reserved.111911201121Oracle Home : /u01/app/oracle/product/11.2.0/db1122Central Inventory : /u01/app/oraInventory1123 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1124OPatch version : 11.2.0.3.441125OUI version : 11.2.0.4.01126Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-19_15-36-13PM_1.log11271128Verifying environment and performing prerequisite checks...1129OPatch continues with these patches: 35685663 11301131Do you want to proceed? [y|n]1132Y (auto-answered by -silent)1133User Responded with: Y1134All checks passed.11351136Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1137(Oracle Home = '/u01/app/oracle/product/11.2.0/db')113811391140Is the local system ready for patching? [y|n]1141Y (auto-answered by -silent)1142User Responded with: Y1143Backing up files...1144Applying interim patch '35685663' to OH '/u01/app/oracle/product/11.2.0/db'1145ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.11461147Patching component oracle.javavm.server, 11.2.0.4.0...11481149Patching component oracle.precomp.common, 11.2.0.4.0...11501151Patching component oracle.rdbms, 11.2.0.4.0...11521153Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...11541155Patching component oracle.javavm.client, 11.2.0.4.0...11561157Patching component oracle.dbjava.jdbc, 11.2.0.4.0...11581159Patching component oracle.dbjava.ic, 11.2.0.4.0...1160Patch 35685663 successfully applied.1161Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-19_15-36-13PM_1.log11621163OPatch succeeded.11641165#==============================================================# 1166Oracle 软件版本 1167#==============================================================# 116811691170SQL*Plus: Release 11.2.0.4.0 Production117111721173#==============================================================# 1174Oracle 补丁信息 1175#==============================================================# 1176117735685663;OJVM PATCH SET UPDATE 11.2.0.4.231017117833991024;11204CERT ON OL8: LINKING ERRORS DURING 11204 FOR DB INSTALL ON OL8.2117935574075;Database Patch Set Update : 11.2.0.4.231017 (35574075)11801181OPatch succeeded.118211831184#==============================================================# 1185配置监听 1186#==============================================================# 118711881189Parsing command line arguments:1190 Parameter "silent" = true1191 Parameter "responsefile" = /u01/app/oracle/product/11.2.0/db/assistants/netca/netca.rsp1192Done parsing command line arguments.1193Oracle Net Services Configuration:1194Profile configuration complete.1195Oracle Net Listener Startup:1196 Running Listener Control: 1197 /u01/app/oracle/product/11.2.0/db/bin/lsnrctl start LISTENER1198 Listener Control complete.1199 Listener started successfully.1200Listener configuration complete.1201Oracle Net Services configuration successful. The exit code is 012021203检查监听状态： 120412051206LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-MAR-2024 15:37:0012071208Copyright (c) 1991, 2013, Oracle. All rights reserved.12091210Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))1211STATUS of the LISTENER1212------------------------1213Alias LISTENER1214Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production1215Start Date 19-MAR-2024 15:36:501216Uptime 0 days 0 hr. 0 min. 10 sec1217Trace Level off1218Security ON: Local OS Authentication1219SNMP OFF1220Listener Parameter File /u01/app/oracle/product/11.2.0/db/network/admin/listener.ora1221Listener Log File /u01/app/oracle/diag/tnslsnr/openEuler/listener/alert/log.xml1222Listening Endpoints Summary...1223 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))1224 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=openEuler)(PORT=1521)))1225The listener supports no services1226The command completed successfully12271228#==============================================================# 1229静默建库命令 1230#==============================================================# 12311232dbca -silent -createDatabase \1233-templateName General_Purpose.dbc \1234-responseFile NO_VALUE \1235-gdbname lucifer \1236-sid lucifer \1237-sysPassword welcome1 \1238-systemPassword welcome1 \1239-redoLogFileSize 100 \1240-datafileDestination /oradata \1241-storageType FS \1242-characterSet AL32UTF8 \1243-nationalCharacterSet AL16UTF16 \1244-emConfiguration NONE \1245-automaticMemoryManagement false \1246-totalMemory 3716 \1247-databaseType OLTP 12481249#==============================================================# 1250创建数据库 1251#==============================================================# 12521253Copying database files12541% complete12553% complete125611% complete125718% complete125826% complete125937% complete1260Creating and starting Oracle instance126140% complete126245% complete126350% complete126455% complete126556% complete126660% complete126762% complete1268Completing Database Creation126966% complete127070% complete127173% complete127274% complete127375% complete127476% complete127577% complete127678% complete127779% complete127880% complete127992% complete1280100% complete1281Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.12821283#==============================================================# 1284配置在线重做日志 1285#==============================================================# 12861287数据库在线重做日志文件： 128812891290 THREAD# GROUP# MEMBER size(M)1291---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------1292 1 1 /oradata/lucifer/redo01.log 1001293 1 2 /oradata/lucifer/redo02.log 1001294 1 3 /oradata/lucifer/redo03.log 1001295 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_lzljrj8k_.log 1001296 1 11 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_11_lzljrjff_.log 1001297 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_lzljrjl3_.log 1001298 1 12 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_12_lzljrjpq_.log 1001299 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_lzljrjvy_.log 1001300 1 13 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_13_lzljrk1m_.log 1001301 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_lzljrk64_.log 1001302 1 14 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_14_lzljrlk7_.log 1001303 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_lzljrm10_.log 1001304 1 15 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_15_lzljrn6p_.log 10013051306#==============================================================# 1307配置 RMAN 备份任务 1308#==============================================================# 13091310## OracleBegin131100 02 * * * /home/oracle/scripts/del_arch.sh1312#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh1313#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh13141315#==============================================================# 1316配置 glogin.sql 1317#==============================================================# 13181319define _editor=vi1320set serveroutput on size 10000001321set pagesize 99991322set long 999991323set trimspool on1324col name format a801325set termout off1326define gname=idle1327column global_name new_value gname1328select 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 );1329ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';1330set sqlprompt '&gname _DATE> '1331set termout on13321333#==============================================================# 1334优化数据库参数 1335#==============================================================# 13361337数据库参数： 133813391340NAME SID SPVALUE VALUE1341-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------1342_b_tree_bitmap_plans * FALSE FALSE1343_datafile_write_errors_crash_instance * FALSE FALSE1344audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump1345audit_trail * NONE DB1346compatible * 11.2.0.4.0 11.2.0.4.01347control_file_record_keep_time * 31 311348db_block_size * 8192 81921349db_create_file_dest * /oradata /oradata1350db_file_multiblock_read_count * 1281351db_files * 5000 2001352db_name * lucifer lucifer1353db_recovery_file_dest * /u01/app/oracle/fast_recovery_area /u01/app/oracle/fast_recovery_area1354db_recovery_file_dest_size * 4857004032 48570040321355db_writer_processes * 11356deferred_segment_creation * FALSE FALSE1357diagnostic_dest * /u01/app/oracle /u01/app/oracle1358dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)1359enable_ddl_logging * TRUE FALSE1360event * 10949 trace name context forever,level 11361event * 28401 trace name context forever,level 11362fast_start_parallel_rollback * LOW1363log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog1364log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf1365max_dump_file_size * unlimited1366open_cursors * 1000 3001367optimizer_index_caching * 01368optimizer_mode * ALL_ROWS1369parallel_force_local * FALSE1370parallel_max_servers * 64 641371pga_aggregate_target * 1246756864 7790919681372processes * 2000 1501373remote_login_passwordfile * EXCLUSIVE EXCLUSIVE1374resource_limit * TRUE FALSE1375resource_manager_plan * force:1376sec_case_sensitive_logon * FALSE TRUE1377session_cached_cursors * 300 501378sessions * 2481379sga_max_size * 4988076032 31205621761380sga_target * 4988076032 31205621761381spfile * /u01/app/oracle/product/11.2.0/db/dbs/spfilelucifer.ora1382statistics_level * TYPICAL1383undo_retention * 10800 90013841385恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] n