在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 SUSE 15 SP5 一键安装 Oracle 11GR2（231017）单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshellin
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
Oracle 一键安装脚本，演示 SUSE 15 SP5 一键安装 Oracle 11GR2（231017）单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
✨ 偷懒可以直接下载本文安装包合集：SUSE 15 SP5 一键安装 Oracle 11GR2（231017）单机版安装包合集（包含补丁！！！）
1# 主机版本2suse15:/soft # cat /etc/os-release 3NAME="SLES"4VERSION="15-SP5"5VERSION_ID="15.5"6PRETTY_NAME="SUSE Linux Enterprise Server 15 SP5"7ID="sles"8ID_LIKE="suse"9ANSI_COLOR="0;32"10CPE_NAME="cpe:/o:suse:sles:15:sp5"11DOCUMENTATION_URL="https://documentation.suse.com/"1213# 网络信息14suse15:/soft # ip a152: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 100016 link/ether 00:0c:29:4e:7a:77 brd ff:ff:ff:ff:ff:ff17 altname enp11s018 altname ens19219 inet 192.168.6.138/24 brd 192.168.6.255 scope global eth020 valid_lft forever preferred_lft forever21 inet6 fe80::20c:29ff:fe4e:7a77/64 scope link 22 valid_lft forever preferred_lft forever2324# 挂载本地 ISO 镜像25suse15:/soft # mount | grep iso9660 | grep -v "/run/media"26/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)27suse15:/soft # df -h|grep /mnt28/dev/sr0 14G 14G 0 100% /mnt2930# 安装包存放在 /soft 目录下31suse15:/soft # ll32-rwxr-xr-x 1 root root 169441 Mar 29 10:31 OracleShellInstall33-rwx------ 1 root root 1395582860 Mar 29 11:00 p13390677_112040_Linux-x86-64_1of7.zip34-rwx------ 1 root root 1151304589 Mar 29 11:00 p13390677_112040_Linux-x86-64_2of7.zip35-rwx------ 1 root root 8684 Mar 29 11:03 p33991024_11204220118_Generic.zip36-rwx------ 1 root root 562188912 Mar 29 11:04 p35574075_112040_Linux-x86-64.zip37-rwx------ 1 root root 86183099 Mar 29 11:03 p35685663_112040_Linux-x86-64.zip38-rwx------ 1 root root 128433424 Mar 29 11:03 p6880880_112000_Linux-x86-64.zip39-rwx------ 1 root root 321590 Mar 26 10:35 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf eth0 `# local ip ifname`\3-n suse15 `# hostname`\4-op oracle `# oracle password`\5-d /u01 `# software base dir`\6-ord /oradata `# data dir`\7-o lucifer `# dbname`\8-dp oracle `# sys/system password`\9-ds AL32UTF8 `# database character`\10-ns AL16UTF16 `# national character`\11-redo 100 `# redo size`\12-opa 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#==============================================================# 2223Adding repository 'sles' [...done]24Repository 'sles' successfully added2526URI : dir:/mnt/Module-Basesystem27Enabled : Yes28GPG Check : Yes29Autorefresh : Yes30Priority : 99 (default priority)3132Repository priorities are without effect. All enabled repositories share the same priority.33Adding repository 'sles-Legacy' [...done]34Repository 'sles-Legacy' successfully added3536URI : dir:/mnt/Module-Legacy37Enabled : Yes38GPG Check : Yes39Autorefresh : Yes40Priority : 99 (default priority)4142Repository priorities are without effect. All enabled repositories share the same priority.43Adding repository 'sles-Tools' [...done]44Repository 'sles-Tools' successfully added4546URI : dir:/mnt/Module-Development-Tools47Enabled : Yes48GPG Check : Yes49Autorefresh : Yes50Priority : 99 (default priority)5152Repository priorities are without effect. All enabled repositories share the same priority.5354#==============================================================# 55禁用防火墙 56#==============================================================# 5758○ firewalld.service - firewalld - dynamic firewall daemon59 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: disabled)60 Active: inactive (dead)61 Docs: man:firewalld(1)6263Mar 25 16:02:33 localhost systemd[1]: Starting firewalld - dynamic firewall daemon...64Mar 25 16:02:37 localhost systemd[1]: Started firewalld - dynamic firewall daemon.65Mar 29 11:12:15 suse15 systemd[1]: Stopping firewalld - dynamic firewall daemon...66Mar 29 11:12:16 suse15 systemd[1]: firewalld.service: Deactivated successfully.67Mar 29 11:12:16 suse15 systemd[1]: Stopped firewalld - dynamic firewall daemon.6869#==============================================================# 70YUM 静默安装依赖包 71#==============================================================# 727374bc-1.07.1-11.37.x86_6475binutils-2.39-150100.7.40.1.x86_6476package compat-libcap1 is not installed77gcc-7-3.9.1.x86_6478gcc-c++-7-3.9.1.x86_6479package elfutils-libelf is not installed80package elfutils-libelf-devel is not installed81glibc-2.31-150300.46.1.x86_6482glibc-devel-2.31-150300.46.1.x86_6483package libaio is not installed84libaio-devel-0.3.109-1.25.x86_6485package libgcc is not installed86package libstdc++ is not installed87libstdc++-devel-7-3.9.1.x86_6488package libxcb is not installed89package libX11 is not installed90package libXau is not installed91package libXi is not installed92package libXrender is not installed93make-4.2.1-7.3.2.x86_6494net-tools-2.0+git20170221.479bb4a-3.11.x86_6495smartmontools-7.2-150300.8.8.1.x86_6496sysstat-12.0.2-3.33.1.x86_6497e2fsprogs-1.46.4-150400.3.3.1.x86_6498package e2fsprogs-libs is not installed99unzip-6.00-150000.4.11.1.x86_64100openssh-clients-8.4p1-150300.3.18.2.x86_64101package readline is not installed102readline-devel-7.0-150400.25.22.x86_64103psmisc-23.0-150000.6.22.1.x86_64104package ksh is not installed105package nfs-utils is not installed106tar-1.34-150000.3.31.1.x86_64107package device-mapper-multipath is not installed108avahi-0.8-150400.7.3.1.x86_64109ntp-4.2.8p15-150000.4.22.1.x86_64110chrony-4.1-150400.19.4.x86_64111package libXtst is not installed112libXrender-devel-0.9.10-1.30.x86_64113fontconfig-devel-2.13.1-150400.1.4.x86_64114policycoreutils-3.1-150400.1.5.x86_64115package policycoreutils-python is not installed116insserv-compat-0.1-4.6.1.noarch117libXext-devel-1.3.3-1.30.x86_64118libXi-devel-1.7.9-3.2.1.x86_64119libcap-ng-utils-0.7.9-4.37.x86_64120libcap-progs-2.63-150400.1.7.x86_64121libcap1-1.97-1.15.x86_64122libpcap1-1.10.1-150400.1.7.x86_64123libpcre16-0-8.45-150000.20.13.1.x86_64124pixz-1.0.6-1.13.x86_64125rdma-core-devel-42.0-150500.1.3.x86_64126xorg-x11-libs-7.6.1-1.16.noarch127compat-libpthread-nonshared-0-150300.3.6.1.x86_64128package librdmacm is not installed129package libnsl* is not installed130libibverbs-42.0-150500.1.3.x86_64131package compat-openssl10 is not installed132policycoreutils-python-utils-3.1-150400.1.5.noarch133package elfutils* is not installed134glibc-2.31-150300.46.1.x86_64135136#==============================================================# 137配置主机名 138#==============================================================# 139140suse15141142#==============================================================# 143配置 /etc/hosts 文件 144#==============================================================# 145146127.0.0.1 localhost147::1 localhost ipv6-localhost ipv6-loopback148fe00::0 ipv6-localnet149ff00::0 ipv6-mcastprefix150ff02::1 ipv6-allnodes151ff02::2 ipv6-allrouters152ff02::3 ipv6-allhosts153192.168.6.138 suse15154155#==============================================================# 156创建用户和组 157#==============================================================# 158159oracle 用户： 160161uid=54321(oracle) gid=54321(oinstall) groups=54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54321(oinstall)162163164#==============================================================# 165配置 Avahi-daemon 服务 166#==============================================================# 167168○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack169 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)170 Active: inactive (dead)171TriggeredBy: ○ avahi-daemon.socket172173#==============================================================# 174配置透明大页 && NUMA && 磁盘 IO 调度器 175#==============================================================# 176177Generating grub configuration file ...178Found theme: /boot/grub2/themes/SLE/theme.txt179Found linux image: /boot/vmlinuz-5.14.21-150500.53-default180Found initrd image: /boot/initrd-5.14.21-150500.53-default181Adding boot menu entry for UEFI Firmware Settings ...182done183184#==============================================================# 185配置 sysctl.conf 186#==============================================================# 187188fs.aio-max-nr = 1048576189fs.file-max = 6815744190kernel.shmall = 2097152191kernel.shmmax = 8332693503192kernel.shmmni = 4096193kernel.sem = 250 32000 100 128194net.ipv4.ip_local_port_range = 9000 65500195net.core.rmem_default = 262144196net.core.rmem_max = 4194304197net.core.wmem_default = 262144198net.core.wmem_max = 1048576199vm.min_free_kbytes = 32549200net.ipv4.conf.eth0.rp_filter = 1201vm.swappiness = 10202kernel.panic_on_oops = 1203kernel.randomize_va_space = 2204kernel.numa_balancing = 0205206#==============================================================# 207配置 RemoveIPC 208#==============================================================# 209210[Login]211212#==============================================================# 213配置 /etc/security/limits.conf 和 /etc/pam.d/login 214#==============================================================# 215216查看 /etc/security/limits.conf： 217218oracle soft nofile 1024219oracle hard nofile 65536220oracle soft stack 10240221oracle hard stack 32768222oracle soft nproc 2047223oracle hard nproc 16384224oracle hard memlock unlimited225oracle soft memlock unlimited226227查看 /etc/pam.d/login 文件： 228229auth requisite pam_nologin.so230auth include common-auth231account include common-account232password include common-password233session required pam_loginuid.so234session optional pam_keyinit.so force revoke235session include common-session236session optional pam_mail.so standard237session required pam_limits.so238session required /lib64/security/pam_limits.so239240#==============================================================# 241配置 /dev/shm 242#==============================================================# 243244/dev/rootgv/rootlv / xfs defaults 0 0245UUID=e16e4a70-ce93-4f3e-9103-7b9243fcabcc /boot xfs defaults 0 0246UUID=CBDD-C51E /boot/efi vfat utf8 0 2247/dev/rootgv/swaplv swap swap defaults 0 0248tmpfs /dev/shm tmpfs size=8137396k 0 0249250#==============================================================# 251安装 rlwrap 插件 252#==============================================================# 253254成功安装 rlwrap： rlwrap 0.44 255256#==============================================================# 257Root 用户环境变量 258#==============================================================# 259260alias so='su - oracle'261export PS1="[`whoami`@`hostname`:"'$PWD]$ '262263#==============================================================# 264Oracle 用户环境变量 265#==============================================================# 266267umask 022268export TMP=/tmp269export TMPDIR=$TMP270export NLS_LANG=AMERICAN_AMERICA.AL32UTF8271export ORACLE_BASE=/u01/app/oracle272export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db273export ORACLE_TERM=xterm274export TNS_ADMIN=$ORACLE_HOME/network/admin275export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib276export ORACLE_SID=lucifer277export PATH=/usr/sbin:$PATH278export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH279export PERL5LIB=$ORACLE_HOME/perl/lib280alias sas='sqlplus / as sysdba'281alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'282alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'283alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'284export PS1="[`whoami`@`hostname`:"'$PWD]$ '285export CV_ASSUME_DISTID=OL7286alias sqlplus='rlwrap sqlplus'287alias rman='rlwrap rman'288alias adrci='rlwrap adrci'289290#==============================================================# 291静默解压 Oracle 软件包 292#==============================================================# 293294正在静默解压缩 Oracle 软件包，请稍等： 295296.---- -. -. . . . .297( .',----- - - ' ' ' __298 \_/ ;--:- __--------------------___ ____=========_||___299__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|300c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |301,_\___________'_|,L______],|______________________|_i,!________________!_i302/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)303""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""304305静默解压 Oracle 软件安装包： /soft/p13390677_112040_Linux-x86-64_1of7.zip,/soft/p13390677_112040_Linux-x86-64_2of7.zip 306307静默解压 Oracle 软件补丁包： /soft/p35574075*.zip 308309静默解压 Oracle 软件补丁包：/soft/p33991024_11204220118_Generic.zip 310311静默解压 OJVM 软件补丁包： /soft/p35685663*.zip 312313#==============================================================# 314Oracle 安装静默文件 315#==============================================================# 316317oracle.install.option=INSTALL_DB_SWONLY318UNIX_GROUP_NAME=oinstall319INVENTORY_LOCATION=/u01/app/oraInventory320ORACLE_BASE=/u01/app/oracle321oracle.install.db.InstallEdition=EE322oracle.install.db.DBA_GROUP=dba323oracle.install.db.OPER_GROUP=oper324oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0325SELECTED_LANGUAGES=en,zh_CN326ORACLE_HOME=/u01/app/oracle/product/11.2.0/db327DECLINE_SECURITY_UPDATES=true328oracle.installer.autoupdates.option=SKIP_UPDATES329330#==============================================================# 331静默安装数据库软件 332#==============================================================# 333334Starting Oracle Universal Installer...335336Checking Temp space: must be greater than 120 MB. Actual 80353 MB Passed337Checking swap space: must be greater than 150 MB. Actual 8191 MB Passed338Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-03-29_11-27-04AM. Please wait ...You can find the log of this install session at:339 /u01/app/oraInventory/logs/installActions2024-03-29_11-27-04AM.log340341Prepare in progress.342.................................................. 9% Done.343344Prepare successful.345346Copy files in progress.347.................................................. 14% Done.348.................................................. 20% Done.349.................................................. 26% Done.350.................................................. 31% Done.351.................................................. 36% Done.352.................................................. 41% Done.353.................................................. 47% Done.354.................................................. 52% Done.355.................................................. 57% Done.356.................................................. 63% Done.357.................................................. 68% Done.358.................................................. 73% Done.359.................................................. 78% Done.360.................................................. 83% Done.361..............................362Copy files successful.363364Link binaries in progress.365..........366Link binaries successful.367368Setup files in progress.369.................................................. 88% Done.370.................................................. 94% Done.371372Setup files successful.373The installation of Oracle Database 11g was successful.374Please check '/u01/app/oraInventory/logs/silentInstall2024-03-29_11-27-04AM.log' for more details.375376Execute Root Scripts in progress.377378As a root user, execute the following script(s):379 1. /u01/app/oraInventory/orainstRoot.sh380 2. /u01/app/oracle/product/11.2.0/db/root.sh381382383.................................................. 100% Done.384385Execute Root Scripts successful.386Successfully Setup Software.387388#==============================================================# 389执行 root 脚本 390#==============================================================# 391392Changing permissions of /u01/app/oraInventory.393Adding read,write permissions for group.394Removing read,write,execute permissions for world.395396Changing groupname of /u01/app/oraInventory to oinstall.397The execution of the script is complete.398Check /u01/app/oracle/product/11.2.0/db/install/root_suse15_2024-03-29_11-29-53.log for the output of root script399400#==============================================================# 401Oracle 软件安装补丁 402#==============================================================# 403404Oracle Interim Patch Installer version 11.2.0.3.44405Copyright (c) 2024, Oracle Corporation. All rights reserved.406407PREREQ session408409Oracle Home : /u01/app/oracle/product/11.2.0/db410Central Inventory : /u01/app/oraInventory411 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc412OPatch version : 11.2.0.3.44413OUI version : 11.2.0.4.0414Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_11-29-59AM_1.log415416Invoking prereq "checkconflictagainstohwithdetail"417418Prereq "checkConflictAgainstOHWithDetail" passed.419420OPatch succeeded.421Oracle Interim Patch Installer version 11.2.0.3.44422Copyright (c) 2024, Oracle Corporation. All rights reserved.423424425Oracle Home : /u01/app/oracle/product/11.2.0/db426Central Inventory : /u01/app/oraInventory427 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc428OPatch version : 11.2.0.3.44429OUI version : 11.2.0.4.0430Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_11-30-03AM_1.log431432Verifying environment and performing prerequisite checks...433OPatch 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 434435Do you want to proceed? [y|n]436Y (auto-answered by -silent)437User Responded with: Y438All checks passed.439440Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.441(Oracle Home = '/u01/app/oracle/product/11.2.0/db')442443444Is the local system ready for patching? [y|n]445Y (auto-answered by -silent)446User Responded with: Y447Backing up files...448Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db'449450Patching component oracle.rdbms, 11.2.0.4.0...451452Patching component oracle.rdbms.rsf, 11.2.0.4.0...453454Patching component oracle.sdo, 11.2.0.4.0...455456Patching component oracle.sysman.agent, 10.2.0.4.5...457458Patching component oracle.xdk, 11.2.0.4.0...459460Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...461462Patching component oracle.sdo.locator, 11.2.0.4.0...463464Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...465466Patching component oracle.xdk.rsf, 11.2.0.4.0...467468Patching component oracle.rdbms.rman, 11.2.0.4.0...469Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/db'470471Patching component oracle.rdbms, 11.2.0.4.0...472473Patching component oracle.rdbms.rsf, 11.2.0.4.0...474475Patching component oracle.ldap.rsf, 11.2.0.4.0...476477Patching component oracle.rdbms.crs, 11.2.0.4.0...478479Patching component oracle.precomp.common, 11.2.0.4.0...480481Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...482483Patching component oracle.rdbms.deconfig, 11.2.0.4.0...484485Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...486487Patching component oracle.rdbms.rman, 11.2.0.4.0...488Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/db'489490Patching component oracle.rdbms.rsf, 11.2.0.4.0...491492Patching component oracle.rdbms, 11.2.0.4.0...493494Patching component oracle.precomp.common, 11.2.0.4.0...495496Patching component oracle.rdbms.rman, 11.2.0.4.0...497498Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...499500Patching component oracle.rdbms.deconfig, 11.2.0.4.0...501Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/db'502503Patching component oracle.precomp.common, 11.2.0.4.0...504505Patching component oracle.sysman.console.db, 11.2.0.4.0...506507Patching component oracle.rdbms.rsf, 11.2.0.4.0...508509Patching component oracle.rdbms.rman, 11.2.0.4.0...510511Patching component oracle.rdbms, 11.2.0.4.0...512513Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...514515Patching component oracle.ordim.client, 11.2.0.4.0...516517Patching component oracle.ordim.jai, 11.2.0.4.0...518Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/db'519ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.520521Patching component oracle.precomp.common, 11.2.0.4.0...522523Patching component oracle.ovm, 11.2.0.4.0...524525Patching component oracle.xdk, 11.2.0.4.0...526527Patching component oracle.rdbms.util, 11.2.0.4.0...528529Patching component oracle.rdbms, 11.2.0.4.0...530531Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...532533Patching component oracle.xdk.parser.java, 11.2.0.4.0...534535Patching component oracle.oraolap, 11.2.0.4.0...536537Patching component oracle.rdbms.rsf, 11.2.0.4.0...538539Patching component oracle.xdk.rsf, 11.2.0.4.0...540541Patching component oracle.rdbms.rman, 11.2.0.4.0...542543Patching component oracle.rdbms.deconfig, 11.2.0.4.0...544Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/db'545546Patching component oracle.rdbms.dv, 11.2.0.4.0...547548Patching component oracle.rdbms.oci, 11.2.0.4.0...549550Patching component oracle.precomp.common, 11.2.0.4.0...551552Patching component oracle.sysman.agent, 10.2.0.4.5...553554Patching component oracle.xdk, 11.2.0.4.0...555556Patching component oracle.sysman.common, 10.2.0.4.5...557558Patching component oracle.rdbms, 11.2.0.4.0...559560Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...561562Patching component oracle.xdk.parser.java, 11.2.0.4.0...563564Patching component oracle.sysman.console.db, 11.2.0.4.0...565566Patching component oracle.xdk.rsf, 11.2.0.4.0...567568Patching component oracle.rdbms.rsf, 11.2.0.4.0...569570Patching component oracle.sysman.common.core, 10.2.0.4.5...571572Patching component oracle.rdbms.rman, 11.2.0.4.0...573574Patching component oracle.rdbms.deconfig, 11.2.0.4.0...575Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0/db'576577Patching component oracle.sysman.console.db, 11.2.0.4.0...578579Patching component oracle.rdbms, 11.2.0.4.0...580581Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...582583Patching component oracle.rdbms.rsf, 11.2.0.4.0...584Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0/db'585586Patching component oracle.sysman.agent, 10.2.0.4.5...587588Patching component oracle.rdbms.rsf, 11.2.0.4.0...589590Patching component oracle.rdbms.rman, 11.2.0.4.0...591592Patching component oracle.rdbms, 11.2.0.4.0...593Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0/db'594ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.595596Patching component oracle.sysman.agent, 10.2.0.4.5...597598Patching component oracle.ovm, 11.2.0.4.0...599600Patching component oracle.xdk, 11.2.0.4.0...601602Patching component oracle.rdbms, 11.2.0.4.0...603604Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...605606Patching component oracle.xdk.parser.java, 11.2.0.4.0...607608Patching component oracle.sysman.console.db, 11.2.0.4.0...609610Patching component oracle.xdk.rsf, 11.2.0.4.0...611612Patching component oracle.rdbms.rsf, 11.2.0.4.0...613614Patching component oracle.sysman.oms.core, 10.2.0.4.5...615Applying sub-patch '22502456' to OH '/u01/app/oracle/product/11.2.0/db'616ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.617618Patching component oracle.precomp.common, 11.2.0.4.0...619620Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...621622Patching component oracle.rdbms.olap, 11.2.0.4.0...623624Patching component oracle.oraolap, 11.2.0.4.0...625626Patching component oracle.rdbms.rsf, 11.2.0.4.0...627628Patching component oracle.rdbms.rman, 11.2.0.4.0...629630Patching component oracle.rdbms, 11.2.0.4.0...631632Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...633Applying sub-patch '23054359' to OH '/u01/app/oracle/product/11.2.0/db'634635Patching component oracle.rdbms.dv, 11.2.0.4.0...636637Patching component oracle.rdbms, 11.2.0.4.0...638639Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...640641Patching component oracle.rdbms.rsf, 11.2.0.4.0...642Applying sub-patch '24006111' to OH '/u01/app/oracle/product/11.2.0/db'643644Patching component oracle.sqlplus.ic, 11.2.0.4.0...645646Patching component oracle.sqlplus, 11.2.0.4.0...647648Patching component oracle.rdbms.rsf, 11.2.0.4.0...649650Patching component oracle.rdbms, 11.2.0.4.0...651652Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...653Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0/db'654655Patching component oracle.precomp.common, 11.2.0.4.0...656657Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...658659Patching component oracle.sqlplus.ic, 11.2.0.4.0...660661Patching component oracle.sqlplus, 11.2.0.4.0...662663Patching component oracle.rdbms.rsf, 11.2.0.4.0...664665Patching component oracle.rdbms, 11.2.0.4.0...666667Patching component oracle.rdbms.util, 11.2.0.4.0...668669Patching component oracle.ordim.client, 11.2.0.4.0...670671Patching component oracle.ordim.jai, 11.2.0.4.0...672673Patching component oracle.ordim.server, 11.2.0.4.0...674Applying sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0/db'675ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.676677Patching component oracle.ldap.rsf, 11.2.0.4.0...678679Patching component oracle.oracore.rsf, 11.2.0.4.0...680681Patching component oracle.rdbms, 11.2.0.4.0...682683Patching component oracle.rdbms.rsf, 11.2.0.4.0...684685Patching component oracle.rdbms.rman, 11.2.0.4.0...686Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/db'687688Patching component oracle.oracore.rsf, 11.2.0.4.0...689690Patching component oracle.rdbms, 11.2.0.4.0...691Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0/db'692ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.693694Patching component oracle.network.rsf, 11.2.0.4.0...695696Patching component oracle.ldap.client, 11.2.0.4.0...697698Patching component oracle.sysman.agent, 10.2.0.4.5...699700Patching component oracle.xdk, 11.2.0.4.0...701702Patching component oracle.rdbms, 11.2.0.4.0...703704Patching component oracle.network.listener, 11.2.0.4.0...705706Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...707708Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...709710Patching component oracle.xdk.parser.java, 11.2.0.4.0...711712Patching component oracle.xdk.rsf, 11.2.0.4.0...713714Patching component oracle.rdbms.rsf, 11.2.0.4.0...715716Patching component oracle.rdbms.rman, 11.2.0.4.0...717Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0/db'718719Patching component oracle.rdbms, 11.2.0.4.0...720721Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...722723Patching component oracle.rdbms.rman, 11.2.0.4.0...724725Patching component oracle.rdbms.rsf, 11.2.0.4.0...726Applying sub-patch '27338049' to OH '/u01/app/oracle/product/11.2.0/db'727728Patching component oracle.assistants.server, 11.2.0.4.0...729730Patching component oracle.rdbms.rsf, 11.2.0.4.0...731732Patching component oracle.rdbms, 11.2.0.4.0...733734Patching component oracle.rdbms.rman, 11.2.0.4.0...735736Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...737Applying sub-patch '27734982' to OH '/u01/app/oracle/product/11.2.0/db'738739Patching component oracle.ctx, 11.2.0.4.0...740741Patching component oracle.rdbms.rsf, 11.2.0.4.0...742743Patching component oracle.ctx.rsf, 11.2.0.4.0...744745Patching component oracle.rdbms, 11.2.0.4.0...746747Patching component oracle.rdbms.rman, 11.2.0.4.0...748Applying sub-patch '28204707' to OH '/u01/app/oracle/product/11.2.0/db'749Applying changes to emctl script on the home: /u01/app/oracle/product/11.2.0/db ...750751Patching component oracle.rdbms, 11.2.0.4.0...752753Patching component oracle.oracore.rsf, 11.2.0.4.0...754755Patching component oracle.rdbms.rsf, 11.2.0.4.0...756757Patching component oracle.ldap.rsf, 11.2.0.4.0...758759Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...760761Patching component oracle.network.rsf, 11.2.0.4.0...762763Patching component oracle.sysman.agent, 10.2.0.4.5...764765Patching component oracle.sysman.console.db, 11.2.0.4.0...766767Patching component oracle.ldap.security.osdt, 11.2.0.4.0...768769Patching component oracle.ldap.owm, 11.2.0.4.0...770771Patching component oracle.sqlplus.rsf, 11.2.0.4.0...772773Patching component oracle.ctx, 11.2.0.4.0...774Applying sub-patch '28729262' to OH '/u01/app/oracle/product/11.2.0/db'775INFO: Script isn't applicable to this port!776777Patching component oracle.rdbms, 11.2.0.4.0...778779Patching component oracle.rdbms.rsf, 11.2.0.4.0...780781Patching component oracle.rdbms.util, 11.2.0.4.0...782783Patching component oracle.ldap.rsf, 11.2.0.4.0...784785Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...786787Patching component oracle.network.rsf, 11.2.0.4.0...788789Patching component oracle.rdbms.rman, 11.2.0.4.0...790791Patching component oracle.ctx, 11.2.0.4.0...792Applying sub-patch '29141056' to OH '/u01/app/oracle/product/11.2.0/db'793794Patching component oracle.rdbms, 11.2.0.4.0...795796Patching component oracle.rdbms.rman, 11.2.0.4.0...797798Patching component oracle.oracore.rsf, 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...803Applying sub-patch '29497421' to OH '/u01/app/oracle/product/11.2.0/db'804805Patching component oracle.rdbms, 11.2.0.4.0...806807Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...808809Patching component oracle.rdbms.rman, 11.2.0.4.0...810811Patching component oracle.rdbms.rsf, 11.2.0.4.0...812813Patching component oracle.ldap.rsf, 11.2.0.4.0...814815Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...816817Patching component oracle.oracore.rsf, 11.2.0.4.0...818819Patching component oracle.ctx, 11.2.0.4.0...820Applying sub-patch '29913194' to OH '/u01/app/oracle/product/11.2.0/db'821822Patching component oracle.rdbms, 11.2.0.4.0...823824Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...825826Patching component oracle.rdbms.rsf, 11.2.0.4.0...827828Patching component oracle.network.rsf, 11.2.0.4.0...829830Patching component oracle.ldap.rsf, 11.2.0.4.0...831832Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...833834Patching component oracle.rdbms.util, 11.2.0.4.0...835Applying sub-patch '30298532' to OH '/u01/app/oracle/product/11.2.0/db'836ApplySession: 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.837838Patching component oracle.rdbms.rsf, 11.2.0.4.0...839840Patching component oracle.rdbms, 11.2.0.4.0...841842Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...843844Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...845846Patching component oracle.ldap.rsf, 11.2.0.4.0...847848Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...849Applying sub-patch '30670774' to OH '/u01/app/oracle/product/11.2.0/db'850851Patching component oracle.rdbms.rsf, 11.2.0.4.0...852853Patching component oracle.rdbms, 11.2.0.4.0...854855Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...856857Patching component oracle.network.rsf, 11.2.0.4.0...858859Patching component oracle.ldap.rsf, 11.2.0.4.0...860861Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...862863Patching component oracle.swd.oui, 11.2.0.4.0...864865Patching component oracle.ctx, 11.2.0.4.0...866Applying sub-patch '31103343' to OH '/u01/app/oracle/product/11.2.0/db'867868Patching component oracle.rdbms, 11.2.0.4.0...869870Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...871872Patching component oracle.rdbms.rsf, 11.2.0.4.0...873Applying sub-patch '31537677' to OH '/u01/app/oracle/product/11.2.0/db'874875Patching component oracle.rdbms, 11.2.0.4.0...876877Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...878879Patching component oracle.rdbms.rsf, 11.2.0.4.0...880881Patching component oracle.rdbms.dv, 11.2.0.4.0...882883Patching component oracle.rdbms.rman, 11.2.0.4.0...884885Patching component oracle.ldap.rsf, 11.2.0.4.0...886887Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...888889Patching component oracle.oracore.rsf, 11.2.0.4.0...890891Patching component oracle.rdbms.util, 11.2.0.4.0...892893Patching component oracle.dbdev, 11.2.0.4.0...894895Patching component oracle.ctx, 11.2.0.4.0...896897Patching component oracle.buildtools.rsf, 11.2.0.4.0...898Applying sub-patch '31983472' to OH '/u01/app/oracle/product/11.2.0/db'899900Patching component oracle.rdbms.rsf, 11.2.0.4.0...901902Patching component oracle.rdbms, 11.2.0.4.0...903904Patching component oracle.ctx, 11.2.0.4.0...905Applying sub-patch '32328626' to OH '/u01/app/oracle/product/11.2.0/db'906907Patching component oracle.rdbms, 11.2.0.4.0...908909Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...910911Patching component oracle.rdbms.rsf, 11.2.0.4.0...912913Patching component oracle.rdbms.dv, 11.2.0.4.0...914915Patching component oracle.rdbms.rman, 11.2.0.4.0...916917Patching component oracle.ldap.rsf, 11.2.0.4.0...918919Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...920Applying sub-patch '32758711' to OH '/u01/app/oracle/product/11.2.0/db'921922Patching component oracle.rdbms, 11.2.0.4.0...923924Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...925926Patching component oracle.ctx, 11.2.0.4.0...927928Patching component oracle.network.rsf, 11.2.0.4.0...929Applying sub-patch '33128584' to OH '/u01/app/oracle/product/11.2.0/db'930931Patching component oracle.rdbms, 11.2.0.4.0...932933Patching component oracle.rdbms.rsf, 11.2.0.4.0...934935Patching component oracle.ctx, 11.2.0.4.0...936Applying sub-patch '33477185' to OH '/u01/app/oracle/product/11.2.0/db'937938Patching component oracle.rdbms, 11.2.0.4.0...939940Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...941942Patching component oracle.rdbms.rsf, 11.2.0.4.0...943944Patching component oracle.network.rsf, 11.2.0.4.0...945946Patching component oracle.rdbms.dv, 11.2.0.4.0...947Applying sub-patch '33711103' to OH '/u01/app/oracle/product/11.2.0/db'948ApplySession: 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.949950Patching component oracle.rdbms.rsf, 11.2.0.4.0...951952Patching component oracle.rdbms, 11.2.0.4.0...953954Patching component oracle.rdbms.rsf, 11.2.0.4.0...955956Patching component oracle.network.rsf, 11.2.0.4.0...957958Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...959960Patching component oracle.rdbms.hs_common, 11.2.0.4.0...961962Patching component oracle.buildtools.rsf, 11.2.0.4.0...963964Patching component oracle.buildtools.rsf, 11.2.0.4.0...965Applying sub-patch '34057724' to OH '/u01/app/oracle/product/11.2.0/db'966ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.967968Patching component oracle.rdbms, 11.2.0.4.0...969970Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...971972Patching component oracle.rdbms.rsf, 11.2.0.4.0...973974Patching component oracle.network.rsf, 11.2.0.4.0...975976Patching component oracle.ldap.rsf, 11.2.0.4.0...977978Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...979980Patching component oracle.swd.oui.core, 11.2.0.4.0...981Applying sub-patch '34386237' to OH '/u01/app/oracle/product/11.2.0/db'982ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.983984Patching component oracle.rdbms, 11.2.0.4.0...985986Patching component oracle.rdbms.rsf, 11.2.0.4.0...987988Patching component oracle.network.rsf, 11.2.0.4.0...989990Patching component oracle.swd.oui.core, 11.2.0.4.0...991992Patching component oracle.ctx, 11.2.0.4.0...993Applying sub-patch '34677698' 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.javavm.containers, 11.2.0.4.0...1001Applying sub-patch '34998337' to OH '/u01/app/oracle/product/11.2.0/db'1002ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.10031004Patching component oracle.rdbms, 11.2.0.4.0...10051006Patching component oracle.rdbms.rsf, 11.2.0.4.0...1007Applying sub-patch '35269283' to OH '/u01/app/oracle/product/11.2.0/db'1008ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.10091010Patching component oracle.rdbms, 11.2.0.4.0...10111012Patching component oracle.network.rsf, 11.2.0.4.0...10131014Patching component oracle.rdbms.rsf, 11.2.0.4.0...10151016Patching component oracle.dbdev, 11.2.0.4.0...1017Applying sub-patch '35574075' to OH '/u01/app/oracle/product/11.2.0/db'1018ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.10191020Patching component oracle.rdbms, 11.2.0.4.0...10211022Patching component oracle.rdbms.rsf, 11.2.0.4.0...10231024Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10251026Patching component oracle.network.rsf, 11.2.0.4.0...10271028Patching component oracle.rdbms.rsf, 11.2.0.4.0...10291030Patching component oracle.sysman.oms.core, 10.2.0.4.5...10311032Patching component oracle.marvel, 11.2.0.4.0...10331034Patching component oracle.javavm.containers, 11.2.0.4.0...10351036Patching component oracle.dbjava.ucp, 11.2.0.4.0...10371038Patching component oracle.owb.rsf, 11.2.0.4.0...10391040Patching component oracle.sysman.ccr, 10.3.8.1.0...10411042Patching component oracle.sysman.ccr.client, 10.3.2.1.0...10431044Patching component oracle.sysman.common, 10.2.0.4.5...10451046Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10471048Patching component oracle.javavm.containers, 11.2.0.4.0...1049Composite patch 35574075 successfully applied.1050Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_11-30-03AM_1.log10511052OPatch succeeded.10531054#==============================================================# 1055Oracle 软件安装补丁 33991024 1056#==============================================================# 10571058Oracle Interim Patch Installer version 11.2.0.3.441059Copyright (c) 2024, Oracle Corporation. All rights reserved.10601061PREREQ session10621063Oracle Home : /u01/app/oracle/product/11.2.0/db1064Central Inventory : /u01/app/oraInventory1065 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1066OPatch version : 11.2.0.3.441067OUI version : 11.2.0.4.01068Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_11-42-20AM_1.log10691070Invoking prereq "checkconflictagainstohwithdetail"10711072Prereq "checkConflictAgainstOHWithDetail" passed.10731074OPatch succeeded.1075Oracle Interim Patch Installer version 11.2.0.3.441076Copyright (c) 2024, Oracle Corporation. All rights reserved.107710781079Oracle Home : /u01/app/oracle/product/11.2.0/db1080Central Inventory : /u01/app/oraInventory1081 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1082OPatch version : 11.2.0.3.441083OUI version : 11.2.0.4.01084Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_11-42-23AM_1.log10851086Verifying environment and performing prerequisite checks...1087OPatch continues with these patches: 33991024 10881089Do you want to proceed? [y|n]1090Y (auto-answered by -silent)1091User Responded with: Y1092All checks passed.10931094Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1095(Oracle Home = '/u01/app/oracle/product/11.2.0/db')109610971098Is the local system ready for patching? [y|n]1099Y (auto-answered by -silent)1100User Responded with: Y1101Backing up files...1102Applying interim patch '33991024' to OH '/u01/app/oracle/product/11.2.0/db'11031104Patching component oracle.rdbms.rsf, 11.2.0.4.0...11051106Patching component oracle.buildtools.rsf, 11.2.0.4.0...11071108Patching component oracle.has.db, 11.2.0.4.0...1109Patch 33991024 successfully applied.1110Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_11-42-23AM_1.log11111112OPatch succeeded.11131114#==============================================================# 1115Oracle 执行 relink 1116#==============================================================# 11171118writing relink log to: /u01/app/oracle/product/11.2.0/db/install/relink.log11191120#==============================================================# 1121OJVM 补丁安装 1122#==============================================================# 11231124Oracle Interim Patch Installer version 11.2.0.3.441125Copyright (c) 2024, Oracle Corporation. All rights reserved.11261127PREREQ session11281129Oracle Home : /u01/app/oracle/product/11.2.0/db1130Central Inventory : /u01/app/oraInventory1131 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1132OPatch version : 11.2.0.3.441133OUI version : 11.2.0.4.01134Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_11-44-01AM_1.log11351136Invoking prereq "checkconflictagainstohwithdetail"11371138Prereq "checkConflictAgainstOHWithDetail" passed.11391140OPatch succeeded.1141Oracle Interim Patch Installer version 11.2.0.3.441142Copyright (c) 2024, Oracle Corporation. All rights reserved.114311441145Oracle Home : /u01/app/oracle/product/11.2.0/db1146Central Inventory : /u01/app/oraInventory1147 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1148OPatch version : 11.2.0.3.441149OUI version : 11.2.0.4.01150Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_11-44-04AM_1.log11511152Verifying environment and performing prerequisite checks...1153OPatch continues with these patches: 35685663 11541155Do you want to proceed? [y|n]1156Y (auto-answered by -silent)1157User Responded with: Y1158All checks passed.11591160Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1161(Oracle Home = '/u01/app/oracle/product/11.2.0/db')116211631164Is the local system ready for patching? [y|n]1165Y (auto-answered by -silent)1166User Responded with: Y1167Backing up files...1168Applying interim patch '35685663' to OH '/u01/app/oracle/product/11.2.0/db'1169ApplySession: 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.11701171Patching component oracle.javavm.server, 11.2.0.4.0...11721173Patching component oracle.precomp.common, 11.2.0.4.0...11741175Patching component oracle.rdbms, 11.2.0.4.0...11761177Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...11781179Patching component oracle.javavm.client, 11.2.0.4.0...11801181Patching component oracle.dbjava.jdbc, 11.2.0.4.0...11821183Patching component oracle.dbjava.ic, 11.2.0.4.0...1184Patch 35685663 successfully applied.1185Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-29_11-44-04AM_1.log11861187OPatch succeeded.11881189#==============================================================# 1190Oracle 软件版本 1191#==============================================================# 119211931194SQL*Plus: Release 11.2.0.4.0 Production119511961197#==============================================================# 1198Oracle 补丁信息 1199#==============================================================# 1200120135685663;OJVM PATCH SET UPDATE 11.2.0.4.231017120233991024;11204CERT ON OL8: LINKING ERRORS DURING 11204 FOR DB INSTALL ON OL8.2120335574075;Database Patch Set Update : 11.2.0.4.231017 (35574075)12041205OPatch succeeded.120612071208#==============================================================# 1209配置监听 1210#==============================================================# 121112121213Parsing command line arguments:1214 Parameter "silent" = true1215 Parameter "responsefile" = /u01/app/oracle/product/11.2.0/db/assistants/netca/netca.rsp1216Done parsing command line arguments.1217Oracle Net Services Configuration:1218Profile configuration complete.1219Oracle Net Listener Startup:1220 Running Listener Control: 1221 /u01/app/oracle/product/11.2.0/db/bin/lsnrctl start LISTENER1222 Listener Control complete.1223 Listener started successfully.1224Listener configuration complete.1225Oracle Net Services configuration successful. The exit code is 012261227检查监听状态： 122812291230LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 29-MAR-2024 11:44:5712311232Copyright (c) 1991, 2013, Oracle. All rights reserved.12331234Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))1235STATUS of the LISTENER1236------------------------1237Alias LISTENER1238Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production1239Start Date 29-MAR-2024 11:44:561240Uptime 0 days 0 hr. 0 min. 0 sec1241Trace Level off1242Security ON: Local OS Authentication1243SNMP OFF1244Listener Parameter File /u01/app/oracle/product/11.2.0/db/network/admin/listener.ora1245Listener Log File /u01/app/oracle/diag/tnslsnr/suse15/listener/alert/log.xml1246Listening Endpoints Summary...1247 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))1248 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=suse15)(PORT=1521)))1249The listener supports no services1250The command completed successfully12511252#==============================================================# 1253静默建库命令 1254#==============================================================# 12551256dbca -silent -createDatabase \1257-templateName General_Purpose.dbc \1258-responseFile NO_VALUE \1259-gdbname lucifer \1260-sid lucifer \1261-sysPassword oracle \1262-systemPassword oracle \1263-redoLogFileSize 100 \1264-datafileDestination /oradata \1265-storageType FS \1266-characterSet AL32UTF8 \1267-nationalCharacterSet AL16UTF16 \1268-emConfiguration NONE \1269-automaticMemoryManagement false \1270-totalMemory 3973 \1271-databaseType OLTP 12721273#==============================================================# 1274创建数据库 1275#==============================================================# 12761277Copying database files12781% complete12793% complete128011% complete128118% complete128226% complete128337% complete1284Creating and starting Oracle instance128540% complete128645% complete128750% complete128855% complete128956% complete129060% complete129162% complete1292Completing Database Creation129366% complete129470% complete129573% complete129674% complete129775% complete129876% complete129977% complete130078% complete130179% complete130280% complete130392% complete1304100% complete1305Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.13061307#==============================================================# 1308配置在线重做日志 1309#==============================================================# 13101311数据库在线重做日志文件： 131213131314 THREAD# GROUP# MEMBER size(M)1315---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------1316 1 1 /oradata/lucifer/redo01.log 1001317 1 2 /oradata/lucifer/redo02.log 1001318 1 3 /oradata/lucifer/redo03.log 1001319 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_m0dh08ox_.log 1001320 1 11 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_11_m0dh08sp_.log 1001321 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_m0dh08xk_.log 1001322 1 12 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_12_m0dh0926_.log 1001323 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_m0dh095s_.log 1001324 1 13 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_13_m0dh099j_.log 1001325 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_m0dh09dv_.log 1001326 1 14 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_14_m0dh09kp_.log 1001327 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_m0dh09od_.log 1001328 1 15 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_15_m0dh09s7_.log 10013291330#==============================================================# 1331配置 RMAN 备份任务 1332#==============================================================# 13331334## OracleBegin133500 02 * * * /home/oracle/scripts/del_arch.sh1336#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh1337#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh13381339#==============================================================# 1340配置 glogin.sql 1341#==============================================================# 13421343define _editor=vi1344set serveroutput on size 10000001345set pagesize 99991346set long 999991347set trimspool on1348col name format a801349set termout off1350define gname=idle1351column global_name new_value gname1352select 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 );1353ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';1354set sqlprompt '&gname _DATE> '1355set termout on13561357#==============================================================# 1358优化数据库参数 1359#==============================================================# 13601361数据库参数： 136213631364NAME SID SPVALUE VALUE1365-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------1366_b_tree_bitmap_plans * FALSE FALSE1367_datafile_write_errors_crash_instance * FALSE FALSE1368audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump1369audit_trail * NONE DB1370compatible * 11.2.0.4.0 11.2.0.4.01371control_file_record_keep_time * 31 311372db_block_size * 8192 81921373db_create_file_dest * /oradata /oradata1374db_file_multiblock_read_count * 1281375db_files * 5000 2001376db_name * lucifer lucifer1377db_recovery_file_dest * /u01/app/oracle/fast_recovery_area /u01/app/oracle/fast_recovery_area1378db_recovery_file_dest_size * 4857004032 48570040321379db_writer_processes * 11380deferred_segment_creation * FALSE FALSE1381diagnostic_dest * /u01/app/oracle /u01/app/oracle1382dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)1383enable_ddl_logging * TRUE FALSE1384event * 10949 trace name context forever,level 11385event * 28401 trace name context forever,level 11386fast_start_parallel_rollback * LOW1387log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog1388log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf1389max_dump_file_size * unlimited1390open_cursors * 1000 3001391optimizer_index_caching * 01392optimizer_mode * ALL_ROWS1393parallel_force_local * FALSE1394parallel_max_servers * 64 641395pga_aggregate_target * 1332740096 8325693441396processes * 2000 1501397remote_login_passwordfile * EXCLUSIVE EXCLUSIVE1398resource_limit * TRUE FALSE1399resource_manager_plan * force:1400sec_case_sensitive_logon * FALSE TRUE1401session_cached_cursors * 300 501402sessions * 2481403sga_max_size * 5332008960 33386659841404sga_target * 5332008960 33386659841405spfile * /u01/app/oracle/product/11.2.0/db/dbs/spfilelucifer.ora1406statistics_level * TYPICAL1407undo_retention * 10800 90014081409恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y