在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 麒麟 V10 一键安装 Oracle 11GR2 单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://ora100.com/shell-install 脚
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 麒麟 V10 一键安装 Oracle 11GR2 单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
✨ 偷懒可以直接下载本文安装包合集：麒麟 V10 安装 Oracle 11GR2（231017） 单机版安装包合集（包含补丁！！！）
1# 主机版本2[root@kylin soft]# cat /etc/kylin-release3Kylin Linux Advanced Server release V10 (Lance)45# 网络信息6[root@kylin 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:62:a0:e5 brd ff:ff:ff:ff:ff:ff9 inet 192.168.6.222/24 brd 192.168.6.255 scope global noprefixroute ens3310 valid_lft forever preferred_lft forever11 inet6 fe80::735:5307:2e5e:803c/64 scope link noprefixroute 12 valid_lft forever preferred_lft forever1314# 挂载本地 ISO 镜像15[root@kylin soft]# mount | grep iso | grep -v "/run/media"16/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048)17[root@kylin soft]# df -h|grep /mnt18/dev/sr0 4.4G 4.4G 0 100% /mnt1920# 安装包存放在 /soft 目录下21[root@lucifer ~]# cd /soft/22[root@kylin soft]# ll23总用量 324630024-rwxr-xr-x 1 root root 162550 2月 26 13:31 OracleShellInstall25-rwx------ 1 root root 1395582860 2月 26 13:34 p13390677_112040_Linux-x86-64_1of7.zip26-rwx------ 1 root root 1151304589 2月 26 13:34 p13390677_112040_Linux-x86-64_2of7.zip27-rwx------ 1 root root 8684 2月 26 13:37 p33991024_11204220118_Generic.zip28-rwx------ 1 root root 562188912 2月 26 13:34 p35574075_112040_Linux-x86-64.zip29-rwx------ 1 root root 86183099 2月 26 13:34 p35685663_112040_Linux-x86-64.zip30-rwx------ 1 root root 128433424 2月 26 13:34 p6880880_112000_Linux-x86-64.zip31-rw-r--r-- 1 root root 4973 2月 26 13:37 print_ora_install_20240226133727.log32-rwxr-xr-x 1 root root 321590 2月 26 13:31 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf ens33 `# local ip ifname`\3-n kylin `# 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[server]24name=server25baseurl=file:///mnt26enabled=127gpgcheck=02829#==============================================================# 30禁用防火墙 31#==============================================================# 3233● firewalld.service - firewalld - dynamic firewall daemon34 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)35 Active: inactive (dead)36 Docs: man:firewalld(1)37382月 26 13:11:07 kylin systemd[1]: Starting firewalld - dynamic firewall daemon...392月 26 13:11:09 kylin systemd[1]: Started firewalld - dynamic firewall daemon.402月 26 13:37:29 kylin systemd[1]: Stopping firewalld - dynamic firewall daemon...412月 26 13:37:30 kylin systemd[1]: firewalld.service: Succeeded.422月 26 13:37:30 kylin systemd[1]: Stopped firewalld - dynamic firewall daemon.4344#==============================================================# 45禁用 SELinux 46#==============================================================# 4748SELinux status: disabled4950#==============================================================# 51YUM 静默安装依赖包 52#==============================================================# 5354bc-1.07.1-11.ky10.x86_6455binutils-2.34-19.p01.ky10.x86_6456未安装软件包 compat-libcap1 57gcc-7.3.0-20220207.45.ky10.x86_6458gcc-c++-7.3.0-20220207.45.ky10.x86_6459未安装软件包 elfutils-libelf 60未安装软件包 elfutils-libelf-devel 61glibc-2.28-88.p06.ky10.x86_6462glibc-devel-2.28-88.p06.ky10.x86_6463libaio-0.3.112-1.p01.ky10.x86_6464libaio-devel-0.3.112-1.p01.ky10.x86_6465libgcc-7.3.0-20220207.45.ky10.x86_6466libstdc++-7.3.0-20220207.45.ky10.x86_6467libstdc++-devel-7.3.0-20220207.45.ky10.x86_6468libxcb-1.14-1.ky10.x86_6469libX11-1.6.9-5.ky10.x86_6470libXau-1.0.9-2.ky10.x86_6471libXi-1.7.10-1.ky10.x86_6472libXrender-0.9.10-10.ky10.x86_6473make-4.3-1.ky10.x86_6474net-tools-2.0-0.54.ky10.x86_6475smartmontools-7.1-1.ky10.x86_6476sysstat-12.2.1-1.p00.ky10.x86_6477e2fsprogs-1.45.6-8.ky10.x86_6478未安装软件包 e2fsprogs-libs 79unzip-6.0-47.ky10.x86_6480openssh-clients-8.2p1-16.p04.ky10.x86_6481readline-8.0-3.ky10.x86_6482readline-devel-8.0-3.ky10.x86_6483psmisc-23.3-2.ky10.x86_6484ksh-2020.0.0-4.ky10.x86_6485nfs-utils-2.5.1-5.ky10.x86_6486tar-1.32-2.ky10.x86_6487未安装软件包 device-mapper-multipath 88avahi-0.8-8.ky10.x86_6489ntp-4.2.8p14-5.ky10.x86_6490chrony-3.5-3.p01.ky10.x86_6491libXtst-1.2.3-10.ky10.x86_6492libXrender-devel-0.9.10-10.ky10.x86_6493fontconfig-devel-2.13.92-1.ky10.x86_6494policycoreutils-3.1-7.p01.ky10.x86_6495未安装软件包 policycoreutils-python 96未安装软件包 librdmacm 97未安装软件包 libnsl* 98未安装软件包 libibverbs 99未安装软件包 compat-openssl10 100policycoreutils-python-utils-3.1-7.p01.ky10.noarch101102#==============================================================# 103配置主机名 104#==============================================================# 105106kylin107108#==============================================================# 109配置 /etc/hosts 文件 110#==============================================================# 111112127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4113::1 localhost localhost.localdomain localhost6 localhost6.localdomain6114115## OracleBegin116## Public IP117192.168.6.222 kylin118119#==============================================================# 120创建用户和组 121#==============================================================# 122123oracle 用户： 124125用户id=54321(oracle) 组id=54321(oinstall) 组=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)126127128#==============================================================# 129配置 Avahi-daemon 服务 130#==============================================================# 131132● avahi-daemon.service - Avahi mDNS/DNS-SD Stack133 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)134 Active: inactive (dead)135136#==============================================================# 137配置透明大页 && NUMA && 磁盘 IO 调度器 138#==============================================================# 139140args="ro resume=/dev/mapper/klas-swap rd.lvm.lv=klas/root rd.lvm.lv=klas/swap rhgb quiet crashkernel=1024M,high audit=0 numa=off transparent_hugepage=never elevator=deadline"141-resume=/dev/mapper/klas-swap142-args="ro143args="ro resume=/dev/mapper/klas-swap rd.lvm.lv=klas/root rd.lvm.lv=klas/swap rhgb quiet crashkernel=1024M,high audit=0 numa=off transparent_hugepage=never elevator=deadline"144-audit=0145-crashkernel=1024M,high146147#==============================================================# 148配置 sysctl.conf 149#==============================================================# 150151kernel.sysrq = 0152net.ipv4.ip_forward = 0153net.ipv4.conf.all.send_redirects = 0154net.ipv4.conf.default.send_redirects = 0155net.ipv4.conf.all.accept_source_route = 0156net.ipv4.conf.default.accept_source_route = 0157net.ipv4.conf.all.accept_redirects = 0158net.ipv4.conf.default.accept_redirects = 0159net.ipv4.conf.all.secure_redirects = 0160net.ipv4.conf.default.secure_redirects = 0161net.ipv4.icmp_echo_ignore_broadcasts = 1162net.ipv4.icmp_ignore_bogus_error_responses = 1163net.ipv4.conf.all.rp_filter = 1164net.ipv4.conf.default.rp_filter = 1165net.ipv4.tcp_syncookies = 1166kernel.dmesg_restrict = 1167net.ipv6.conf.all.accept_redirects = 0168net.ipv6.conf.default.accept_redirects = 0169fs.aio-max-nr = 1048576170fs.file-max = 6815744171kernel.shmall = 2097152172kernel.shmmax = 7010422783173kernel.shmmni = 4096174kernel.sem = 250 32000 100 128175net.ipv4.ip_local_port_range = 9000 65500176net.core.rmem_default = 262144177net.core.rmem_max = 4194304178net.core.wmem_default = 262144179net.core.wmem_max = 1048576180vm.min_free_kbytes = 27384181net.ipv4.conf.ens33.rp_filter = 1182vm.swappiness = 10183kernel.panic_on_oops = 1184kernel.randomize_va_space = 2185kernel.numa_balancing = 0186187#==============================================================# 188配置 nsysctl.conf 189#==============================================================# 190191NOZEROCONF=yes192193#==============================================================# 194配置 RemoveIPC 195#==============================================================# 196197[Login]198RemoveIPC=no199200#==============================================================# 201配置 /etc/security/limits.conf 和 /etc/pam.d/login 202#==============================================================# 203204查看 /etc/security/limits.conf： 205206oracle soft nofile 1024207oracle hard nofile 65536208oracle soft stack 10240209oracle hard stack 32768210oracle soft nproc 2047211oracle hard nproc 16384212oracle hard memlock unlimited213oracle soft memlock unlimited214215查看 /etc/pam.d/login 文件： 216217auth substack system-auth218auth include postlogin219account required pam_nologin.so220account include system-auth221password include system-auth222session required pam_selinux.so close223session required pam_loginuid.so224session required pam_selinux.so open225session required pam_namespace.so226session optional pam_keyinit.so force revoke227session include system-auth228session include postlogin229-session optional pam_ck_connector.so230session required pam_limits.so231session required /lib64/security/pam_limits.so232233#==============================================================# 234配置 /dev/shm 235#==============================================================# 236237/dev/mapper/klas-root / xfs defaults 0 0238UUID=c8e47a65-11c4-4e4e-84ce-95f9f618be7e /boot xfs defaults 0 0239/dev/mapper/klas-swap none swap defaults 0 0240tmpfs /dev/shm tmpfs size=6846116k 0 0241242#==============================================================# 243安装 rlwrap 插件 244#==============================================================# 245246成功安装 rlwrap： rlwrap 0.44 247248#==============================================================# 249Root 用户环境变量 250#==============================================================# 251252if [ -f ~/.bashrc ]; then253 . ~/.bashrc254fi255PATH=$PATH:$HOME/bin256export PATH257alias so='su - oracle'258export PS1="[`whoami`@`hostname`:"'$PWD]$ '259260#==============================================================# 261Oracle 用户环境变量 262#==============================================================# 263264[ -f ~/.bashrc ] && . ~/.bashrc265umask 022266export TMP=/tmp267export TMPDIR=$TMP268export NLS_LANG=AMERICAN_AMERICA.AL32UTF8269export ORACLE_BASE=/u01/app/oracle270export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db271export ORACLE_TERM=xterm272export TNS_ADMIN=$ORACLE_HOME/network/admin273export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib274export ORACLE_SID=lucifer275export PATH=/usr/sbin:$PATH276export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH277export PERL5LIB=$ORACLE_HOME/perl/lib278alias sas='sqlplus / as sysdba'279alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'280alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'281alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'282export PS1="[`whoami`@`hostname`:"'$PWD]$ '283export CV_ASSUME_DISTID=OL7284alias sqlplus='rlwrap sqlplus'285alias rman='rlwrap rman'286alias adrci='rlwrap adrci'287288#==============================================================# 289静默解压 Oracle 软件包 290#==============================================================# 291292正在静默解压缩 Oracle 软件包，请稍等： 293294.---- -. -. . . . .295( .',----- - - ' ' ' __296 \_/ ;--:- __--------------------___ ____=========_||___297__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|298c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |299,_\___________'_|,L______],|______________________|_i,!________________!_i300/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)301""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""302303静默解压 Oracle 软件安装包： /soft/p13390677_112040_Linux-x86-64_1of7.zip,/soft/p13390677_112040_Linux-x86-64_2of7.zip 304305静默解压 Oracle 软件补丁包： /soft/p35574075*.zip 306307静默解压 Oracle 软件补丁包：/soft/p33991024_11204220118_Generic.zip 308309静默解压 OJVM 软件补丁包： /soft/p35685663*.zip 310311#==============================================================# 312Oracle 安装静默文件 313#==============================================================# 314315oracle.install.option=INSTALL_DB_SWONLY316UNIX_GROUP_NAME=oinstall317INVENTORY_LOCATION=/u01/app/oraInventory318ORACLE_BASE=/u01/app/oracle319oracle.install.db.InstallEdition=EE320oracle.install.db.DBA_GROUP=dba321oracle.install.db.OPER_GROUP=oper322oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0323SELECTED_LANGUAGES=en,zh_CN324ORACLE_HOME=/u01/app/oracle/product/11.2.0/db325DECLINE_SECURITY_UPDATES=true326oracle.installer.autoupdates.option=SKIP_UPDATES327328#==============================================================# 329静默安装数据库软件 330#==============================================================# 331332Starting Oracle Universal Installer...333334Checking Temp space: must be greater than 120 MB. Actual 3342 MB Passed335Checking swap space: must be greater than 150 MB. Actual 8180 MB Passed336Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-02-26_01-38-53PM. Please wait ...You can find the log of this install session at:337 /u01/app/oraInventory/logs/installActions2024-02-26_01-38-53PM.log338339Prepare in progress.340.................................................. 9% Done.341342Prepare successful.343344Copy files in progress.345.................................................. 14% Done.346.................................................. 20% Done.347.................................................. 26% Done.348.................................................. 31% Done.349.................................................. 36% Done.350.................................................. 41% Done.351.................................................. 47% Done.352.................................................. 52% Done.353.................................................. 57% Done.354.................................................. 63% Done.355.................................................. 68% Done.356.................................................. 73% Done.357.................................................. 78% Done.358.................................................. 83% Done.359..............................360Copy files successful.361362Link binaries in progress.363..........364Link binaries successful.365366Setup files in progress.367.................................................. 88% Done.368.................................................. 94% Done.369370Setup files successful.371The installation of Oracle Database 11g was successful.372Please check '/u01/app/oraInventory/logs/silentInstall2024-02-26_01-38-53PM.log' for more details.373374Execute Root Scripts in progress.375376As a root user, execute the following script(s):377 1. /u01/app/oraInventory/orainstRoot.sh378 2. /u01/app/oracle/product/11.2.0/db/root.sh379380381.................................................. 100% Done.382383Execute Root Scripts successful.384Successfully Setup Software.385386#==============================================================# 387执行 root 脚本 388#==============================================================# 389390Changing permissions of /u01/app/oraInventory.391Adding read,write permissions for group.392Removing read,write,execute permissions for world.393394Changing groupname of /u01/app/oraInventory to oinstall.395The execution of the script is complete.396Check /u01/app/oracle/product/11.2.0/db/install/root_kylin_2024-02-26_13-41-18.log for the output of root script397398#==============================================================# 399Oracle 软件安装补丁 400#==============================================================# 401402Oracle Interim Patch Installer version 11.2.0.3.44403Copyright (c) 2024, Oracle Corporation. All rights reserved.404405PREREQ session406407Oracle Home : /u01/app/oracle/product/11.2.0/db408Central Inventory : /u01/app/oraInventory409 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc410OPatch version : 11.2.0.3.44411OUI version : 11.2.0.4.0412Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_13-41-22PM_1.log413414Invoking prereq "checkconflictagainstohwithdetail"415416Prereq "checkConflictAgainstOHWithDetail" passed.417418OPatch succeeded.419Oracle Interim Patch Installer version 11.2.0.3.44420Copyright (c) 2024, Oracle Corporation. All rights reserved.421422423Oracle Home : /u01/app/oracle/product/11.2.0/db424Central Inventory : /u01/app/oraInventory425 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc426OPatch version : 11.2.0.3.44427OUI version : 11.2.0.4.0428Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_13-41-26PM_1.log429430Verifying environment and performing prerequisite checks...431OPatch 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 432433Do you want to proceed? [y|n]434Y (auto-answered by -silent)435User Responded with: Y436All checks passed.437438Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.439(Oracle Home = '/u01/app/oracle/product/11.2.0/db')440441442Is the local system ready for patching? [y|n]443Y (auto-answered by -silent)444User Responded with: Y445Backing up files...446Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db'447448Patching component oracle.rdbms, 11.2.0.4.0...449450Patching component oracle.rdbms.rsf, 11.2.0.4.0...451452Patching component oracle.sdo, 11.2.0.4.0...453454Patching component oracle.sysman.agent, 10.2.0.4.5...455456Patching component oracle.xdk, 11.2.0.4.0...457458Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...459460Patching component oracle.sdo.locator, 11.2.0.4.0...461462Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...463464Patching component oracle.xdk.rsf, 11.2.0.4.0...465466Patching component oracle.rdbms.rman, 11.2.0.4.0...467Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/db'468469Patching component oracle.rdbms, 11.2.0.4.0...470471Patching component oracle.rdbms.rsf, 11.2.0.4.0...472473Patching component oracle.ldap.rsf, 11.2.0.4.0...474475Patching component oracle.rdbms.crs, 11.2.0.4.0...476477Patching component oracle.precomp.common, 11.2.0.4.0...478479Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...480481Patching component oracle.rdbms.deconfig, 11.2.0.4.0...482483Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...484485Patching component oracle.rdbms.rman, 11.2.0.4.0...486Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/db'487488Patching component oracle.rdbms.rsf, 11.2.0.4.0...489490Patching component oracle.rdbms, 11.2.0.4.0...491492Patching component oracle.precomp.common, 11.2.0.4.0...493494Patching component oracle.rdbms.rman, 11.2.0.4.0...495496Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...497498Patching component oracle.rdbms.deconfig, 11.2.0.4.0...499Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/db'500501Patching component oracle.precomp.common, 11.2.0.4.0...502503Patching component oracle.sysman.console.db, 11.2.0.4.0...504505Patching component oracle.rdbms.rsf, 11.2.0.4.0...506507Patching component oracle.rdbms.rman, 11.2.0.4.0...508509Patching component oracle.rdbms, 11.2.0.4.0...510511Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...512513Patching component oracle.ordim.client, 11.2.0.4.0...514515Patching component oracle.ordim.jai, 11.2.0.4.0...516Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/db'517ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.518519Patching component oracle.precomp.common, 11.2.0.4.0...520521Patching component oracle.ovm, 11.2.0.4.0...522523Patching component oracle.xdk, 11.2.0.4.0...524525Patching component oracle.rdbms.util, 11.2.0.4.0...526527Patching component oracle.rdbms, 11.2.0.4.0...528529Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...530531Patching component oracle.xdk.parser.java, 11.2.0.4.0...532533Patching component oracle.oraolap, 11.2.0.4.0...534535Patching component oracle.rdbms.rsf, 11.2.0.4.0...536537Patching component oracle.xdk.rsf, 11.2.0.4.0...538539Patching component oracle.rdbms.rman, 11.2.0.4.0...540541Patching component oracle.rdbms.deconfig, 11.2.0.4.0...542Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/db'543544Patching component oracle.rdbms.dv, 11.2.0.4.0...545546Patching component oracle.rdbms.oci, 11.2.0.4.0...547548Patching component oracle.precomp.common, 11.2.0.4.0...549550Patching component oracle.sysman.agent, 10.2.0.4.5...551552Patching component oracle.xdk, 11.2.0.4.0...553554Patching component oracle.sysman.common, 10.2.0.4.5...555556Patching component oracle.rdbms, 11.2.0.4.0...557558Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...559560Patching component oracle.xdk.parser.java, 11.2.0.4.0...561562Patching component oracle.sysman.console.db, 11.2.0.4.0...563564Patching component oracle.xdk.rsf, 11.2.0.4.0...565566Patching component oracle.rdbms.rsf, 11.2.0.4.0...567568Patching component oracle.sysman.common.core, 10.2.0.4.5...569570Patching component oracle.rdbms.rman, 11.2.0.4.0...571572Patching component oracle.rdbms.deconfig, 11.2.0.4.0...573Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0/db'574575Patching component oracle.sysman.console.db, 11.2.0.4.0...576577Patching component oracle.rdbms, 11.2.0.4.0...578579Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...580581Patching component oracle.rdbms.rsf, 11.2.0.4.0...582Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0/db'583584Patching component oracle.sysman.agent, 10.2.0.4.5...585586Patching component oracle.rdbms.rsf, 11.2.0.4.0...587588Patching component oracle.rdbms.rman, 11.2.0.4.0...589590Patching component oracle.rdbms, 11.2.0.4.0...591Applying sub-patch '21948347' 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.sysman.agent, 10.2.0.4.5...595596Patching component oracle.ovm, 11.2.0.4.0...597598Patching component oracle.xdk, 11.2.0.4.0...599600Patching component oracle.rdbms, 11.2.0.4.0...601602Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...603604Patching component oracle.xdk.parser.java, 11.2.0.4.0...605606Patching component oracle.sysman.console.db, 11.2.0.4.0...607608Patching component oracle.xdk.rsf, 11.2.0.4.0...609610Patching component oracle.rdbms.rsf, 11.2.0.4.0...611612Patching component oracle.sysman.oms.core, 10.2.0.4.5...613Applying sub-patch '22502456' to OH '/u01/app/oracle/product/11.2.0/db'614ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.615616Patching component oracle.precomp.common, 11.2.0.4.0...617618Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...619620Patching component oracle.rdbms.olap, 11.2.0.4.0...621622Patching component oracle.oraolap, 11.2.0.4.0...623624Patching component oracle.rdbms.rsf, 11.2.0.4.0...625626Patching component oracle.rdbms.rman, 11.2.0.4.0...627628Patching component oracle.rdbms, 11.2.0.4.0...629630Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...631Applying sub-patch '23054359' to OH '/u01/app/oracle/product/11.2.0/db'632633Patching component oracle.rdbms.dv, 11.2.0.4.0...634635Patching component oracle.rdbms, 11.2.0.4.0...636637Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...638639Patching component oracle.rdbms.rsf, 11.2.0.4.0...640Applying sub-patch '24006111' to OH '/u01/app/oracle/product/11.2.0/db'641642Patching component oracle.sqlplus.ic, 11.2.0.4.0...643644Patching component oracle.sqlplus, 11.2.0.4.0...645646Patching component oracle.rdbms.rsf, 11.2.0.4.0...647648Patching component oracle.rdbms, 11.2.0.4.0...649650Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...651Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0/db'652653Patching component oracle.precomp.common, 11.2.0.4.0...654655Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...656657Patching component oracle.sqlplus.ic, 11.2.0.4.0...658659Patching component oracle.sqlplus, 11.2.0.4.0...660661Patching component oracle.rdbms.rsf, 11.2.0.4.0...662663Patching component oracle.rdbms, 11.2.0.4.0...664665Patching component oracle.rdbms.util, 11.2.0.4.0...666667Patching component oracle.ordim.client, 11.2.0.4.0...668669Patching component oracle.ordim.jai, 11.2.0.4.0...670671Patching component oracle.ordim.server, 11.2.0.4.0...672Applying sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0/db'673ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.674675Patching component oracle.ldap.rsf, 11.2.0.4.0...676677Patching component oracle.oracore.rsf, 11.2.0.4.0...678679Patching component oracle.rdbms, 11.2.0.4.0...680681Patching component oracle.rdbms.rsf, 11.2.0.4.0...682683Patching component oracle.rdbms.rman, 11.2.0.4.0...684Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/db'685686Patching component oracle.oracore.rsf, 11.2.0.4.0...687688Patching component oracle.rdbms, 11.2.0.4.0...689Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0/db'690ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.691692Patching component oracle.network.rsf, 11.2.0.4.0...693694Patching component oracle.ldap.client, 11.2.0.4.0...695696Patching component oracle.sysman.agent, 10.2.0.4.5...697698Patching component oracle.xdk, 11.2.0.4.0...699700Patching component oracle.rdbms, 11.2.0.4.0...701702Patching component oracle.network.listener, 11.2.0.4.0...703704Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...705706Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...707708Patching component oracle.xdk.parser.java, 11.2.0.4.0...709710Patching component oracle.xdk.rsf, 11.2.0.4.0...711712Patching component oracle.rdbms.rsf, 11.2.0.4.0...713714Patching component oracle.rdbms.rman, 11.2.0.4.0...715Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0/db'716717Patching component oracle.rdbms, 11.2.0.4.0...718719Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...720721Patching component oracle.rdbms.rman, 11.2.0.4.0...722723Patching component oracle.rdbms.rsf, 11.2.0.4.0...724Applying sub-patch '27338049' to OH '/u01/app/oracle/product/11.2.0/db'725726Patching component oracle.assistants.server, 11.2.0.4.0...727728Patching component oracle.rdbms.rsf, 11.2.0.4.0...729730Patching component oracle.rdbms, 11.2.0.4.0...731732Patching component oracle.rdbms.rman, 11.2.0.4.0...733734Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...735Applying sub-patch '27734982' to OH '/u01/app/oracle/product/11.2.0/db'736737Patching component oracle.ctx, 11.2.0.4.0...738739Patching component oracle.rdbms.rsf, 11.2.0.4.0...740741Patching component oracle.ctx.rsf, 11.2.0.4.0...742743Patching component oracle.rdbms, 11.2.0.4.0...744745Patching component oracle.rdbms.rman, 11.2.0.4.0...746Applying sub-patch '28204707' to OH '/u01/app/oracle/product/11.2.0/db'747Applying changes to emctl script on the home: /u01/app/oracle/product/11.2.0/db ...748749Patching component oracle.rdbms, 11.2.0.4.0...750751Patching component oracle.oracore.rsf, 11.2.0.4.0...752753Patching component oracle.rdbms.rsf, 11.2.0.4.0...754755Patching component oracle.ldap.rsf, 11.2.0.4.0...756757Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...758759Patching component oracle.network.rsf, 11.2.0.4.0...760761Patching component oracle.sysman.agent, 10.2.0.4.5...762763Patching component oracle.sysman.console.db, 11.2.0.4.0...764765Patching component oracle.ldap.security.osdt, 11.2.0.4.0...766767Patching component oracle.ldap.owm, 11.2.0.4.0...768769Patching component oracle.sqlplus.rsf, 11.2.0.4.0...770771Patching component oracle.ctx, 11.2.0.4.0...772Applying sub-patch '28729262' to OH '/u01/app/oracle/product/11.2.0/db'773INFO: Script isn't applicable to this port!774775Patching component oracle.rdbms, 11.2.0.4.0...776777Patching component oracle.rdbms.rsf, 11.2.0.4.0...778779Patching component oracle.rdbms.util, 11.2.0.4.0...780781Patching component oracle.ldap.rsf, 11.2.0.4.0...782783Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...784785Patching component oracle.network.rsf, 11.2.0.4.0...786787Patching component oracle.rdbms.rman, 11.2.0.4.0...788789Patching component oracle.ctx, 11.2.0.4.0...790Applying sub-patch '29141056' to OH '/u01/app/oracle/product/11.2.0/db'791792Patching component oracle.rdbms, 11.2.0.4.0...793794Patching component oracle.rdbms.rman, 11.2.0.4.0...795796Patching component oracle.oracore.rsf, 11.2.0.4.0...797798Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...799800Patching component oracle.rdbms.rsf, 11.2.0.4.0...801Applying sub-patch '29497421' to OH '/u01/app/oracle/product/11.2.0/db'802803Patching component oracle.rdbms, 11.2.0.4.0...804805Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...806807Patching component oracle.rdbms.rman, 11.2.0.4.0...808809Patching component oracle.rdbms.rsf, 11.2.0.4.0...810811Patching component oracle.ldap.rsf, 11.2.0.4.0...812813Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...814815Patching component oracle.oracore.rsf, 11.2.0.4.0...816817Patching component oracle.ctx, 11.2.0.4.0...818Applying sub-patch '29913194' to OH '/u01/app/oracle/product/11.2.0/db'819820Patching component oracle.rdbms, 11.2.0.4.0...821822Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...823824Patching component oracle.rdbms.rsf, 11.2.0.4.0...825826Patching component oracle.network.rsf, 11.2.0.4.0...827828Patching component oracle.ldap.rsf, 11.2.0.4.0...829830Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...831832Patching component oracle.rdbms.util, 11.2.0.4.0...833Applying sub-patch '30298532' to OH '/u01/app/oracle/product/11.2.0/db'834ApplySession: 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.835836Patching component oracle.rdbms.rsf, 11.2.0.4.0...837838Patching component oracle.rdbms, 11.2.0.4.0...839840Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...841842Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...843844Patching component oracle.ldap.rsf, 11.2.0.4.0...845846Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...847Applying sub-patch '30670774' to OH '/u01/app/oracle/product/11.2.0/db'848849Patching component oracle.rdbms.rsf, 11.2.0.4.0...850851Patching component oracle.rdbms, 11.2.0.4.0...852853Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...854855Patching component oracle.network.rsf, 11.2.0.4.0...856857Patching component oracle.ldap.rsf, 11.2.0.4.0...858859Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...860861Patching component oracle.swd.oui, 11.2.0.4.0...862863Patching component oracle.ctx, 11.2.0.4.0...864Applying sub-patch '31103343' to OH '/u01/app/oracle/product/11.2.0/db'865866Patching component oracle.rdbms, 11.2.0.4.0...867868Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...869870Patching component oracle.rdbms.rsf, 11.2.0.4.0...871Applying sub-patch '31537677' to OH '/u01/app/oracle/product/11.2.0/db'872873Patching component oracle.rdbms, 11.2.0.4.0...874875Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...876877Patching component oracle.rdbms.rsf, 11.2.0.4.0...878879Patching component oracle.rdbms.dv, 11.2.0.4.0...880881Patching component oracle.rdbms.rman, 11.2.0.4.0...882883Patching component oracle.ldap.rsf, 11.2.0.4.0...884885Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...886887Patching component oracle.oracore.rsf, 11.2.0.4.0...888889Patching component oracle.rdbms.util, 11.2.0.4.0...890891Patching component oracle.dbdev, 11.2.0.4.0...892893Patching component oracle.ctx, 11.2.0.4.0...894895Patching component oracle.buildtools.rsf, 11.2.0.4.0...896Applying sub-patch '31983472' to OH '/u01/app/oracle/product/11.2.0/db'897898Patching component oracle.rdbms.rsf, 11.2.0.4.0...899900Patching component oracle.rdbms, 11.2.0.4.0...901902Patching component oracle.ctx, 11.2.0.4.0...903Applying sub-patch '32328626' to OH '/u01/app/oracle/product/11.2.0/db'904905Patching component oracle.rdbms, 11.2.0.4.0...906907Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...908909Patching component oracle.rdbms.rsf, 11.2.0.4.0...910911Patching component oracle.rdbms.dv, 11.2.0.4.0...912913Patching component oracle.rdbms.rman, 11.2.0.4.0...914915Patching component oracle.ldap.rsf, 11.2.0.4.0...916917Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...918Applying sub-patch '32758711' to OH '/u01/app/oracle/product/11.2.0/db'919920Patching component oracle.rdbms, 11.2.0.4.0...921922Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...923924Patching component oracle.ctx, 11.2.0.4.0...925926Patching component oracle.network.rsf, 11.2.0.4.0...927Applying sub-patch '33128584' to OH '/u01/app/oracle/product/11.2.0/db'928929Patching component oracle.rdbms, 11.2.0.4.0...930931Patching component oracle.rdbms.rsf, 11.2.0.4.0...932933Patching component oracle.ctx, 11.2.0.4.0...934Applying sub-patch '33477185' to OH '/u01/app/oracle/product/11.2.0/db'935936Patching component oracle.rdbms, 11.2.0.4.0...937938Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...939940Patching component oracle.rdbms.rsf, 11.2.0.4.0...941942Patching component oracle.network.rsf, 11.2.0.4.0...943944Patching component oracle.rdbms.dv, 11.2.0.4.0...945Applying sub-patch '33711103' to OH '/u01/app/oracle/product/11.2.0/db'946ApplySession: 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.947948Patching component oracle.rdbms.rsf, 11.2.0.4.0...949950Patching component oracle.rdbms, 11.2.0.4.0...951952Patching component oracle.rdbms.rsf, 11.2.0.4.0...953954Patching component oracle.network.rsf, 11.2.0.4.0...955956Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...957958Patching component oracle.rdbms.hs_common, 11.2.0.4.0...959960Patching component oracle.buildtools.rsf, 11.2.0.4.0...961962Patching component oracle.buildtools.rsf, 11.2.0.4.0...963Applying sub-patch '34057724' to OH '/u01/app/oracle/product/11.2.0/db'964ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.965966Patching component oracle.rdbms, 11.2.0.4.0...967968Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...969970Patching component oracle.rdbms.rsf, 11.2.0.4.0...971972Patching component oracle.network.rsf, 11.2.0.4.0...973974Patching component oracle.ldap.rsf, 11.2.0.4.0...975976Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...977978Patching component oracle.swd.oui.core, 11.2.0.4.0...979Applying sub-patch '34386237' to OH '/u01/app/oracle/product/11.2.0/db'980ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.981982Patching component oracle.rdbms, 11.2.0.4.0...983984Patching component oracle.rdbms.rsf, 11.2.0.4.0...985986Patching component oracle.network.rsf, 11.2.0.4.0...987988Patching component oracle.swd.oui.core, 11.2.0.4.0...989990Patching component oracle.ctx, 11.2.0.4.0...991Applying sub-patch '34677698' to OH '/u01/app/oracle/product/11.2.0/db'992ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.993994Patching component oracle.rdbms, 11.2.0.4.0...995996Patching component oracle.rdbms.rsf, 11.2.0.4.0...997998Patching component oracle.javavm.containers, 11.2.0.4.0...999Applying sub-patch '34998337' to OH '/u01/app/oracle/product/11.2.0/db'1000ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.10011002Patching component oracle.rdbms, 11.2.0.4.0...10031004Patching component oracle.rdbms.rsf, 11.2.0.4.0...1005Applying sub-patch '35269283' to OH '/u01/app/oracle/product/11.2.0/db'1006ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.10071008Patching component oracle.rdbms, 11.2.0.4.0...10091010Patching component oracle.network.rsf, 11.2.0.4.0...10111012Patching component oracle.rdbms.rsf, 11.2.0.4.0...10131014Patching component oracle.dbdev, 11.2.0.4.0...1015Applying sub-patch '35574075' to OH '/u01/app/oracle/product/11.2.0/db'1016ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.10171018Patching component oracle.rdbms, 11.2.0.4.0...10191020Patching component oracle.rdbms.rsf, 11.2.0.4.0...10211022Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10231024Patching component oracle.network.rsf, 11.2.0.4.0...10251026Patching component oracle.rdbms.rsf, 11.2.0.4.0...10271028Patching component oracle.sysman.oms.core, 10.2.0.4.5...10291030Patching component oracle.marvel, 11.2.0.4.0...10311032Patching component oracle.javavm.containers, 11.2.0.4.0...10331034Patching component oracle.dbjava.ucp, 11.2.0.4.0...10351036Patching component oracle.owb.rsf, 11.2.0.4.0...10371038Patching component oracle.sysman.ccr, 10.3.8.1.0...10391040Patching component oracle.sysman.ccr.client, 10.3.2.1.0...10411042Patching component oracle.sysman.common, 10.2.0.4.5...10431044Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10451046Patching component oracle.javavm.containers, 11.2.0.4.0...1047Composite patch 35574075 successfully applied.1048Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_13-41-26PM_1.log10491050OPatch succeeded.10511052#==============================================================# 1053Oracle 软件安装补丁 33991024 1054#==============================================================# 10551056Oracle Interim Patch Installer version 11.2.0.3.441057Copyright (c) 2024, Oracle Corporation. All rights reserved.10581059PREREQ session10601061Oracle Home : /u01/app/oracle/product/11.2.0/db1062Central Inventory : /u01/app/oraInventory1063 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1064OPatch version : 11.2.0.3.441065OUI version : 11.2.0.4.01066Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_13-50-26PM_1.log10671068Invoking prereq "checkconflictagainstohwithdetail"10691070Prereq "checkConflictAgainstOHWithDetail" passed.10711072OPatch succeeded.1073Oracle Interim Patch Installer version 11.2.0.3.441074Copyright (c) 2024, Oracle Corporation. All rights reserved.107510761077Oracle Home : /u01/app/oracle/product/11.2.0/db1078Central Inventory : /u01/app/oraInventory1079 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1080OPatch version : 11.2.0.3.441081OUI version : 11.2.0.4.01082Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_13-50-29PM_1.log10831084Verifying environment and performing prerequisite checks...1085OPatch continues with these patches: 33991024 10861087Do you want to proceed? [y|n]1088Y (auto-answered by -silent)1089User Responded with: Y1090All checks passed.10911092Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1093(Oracle Home = '/u01/app/oracle/product/11.2.0/db')109410951096Is the local system ready for patching? [y|n]1097Y (auto-answered by -silent)1098User Responded with: Y1099Backing up files...1100Applying interim patch '33991024' to OH '/u01/app/oracle/product/11.2.0/db'11011102Patching component oracle.rdbms.rsf, 11.2.0.4.0...11031104Patching component oracle.buildtools.rsf, 11.2.0.4.0...11051106Patching component oracle.has.db, 11.2.0.4.0...1107Patch 33991024 successfully applied.1108Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_13-50-29PM_1.log11091110OPatch succeeded.11111112#==============================================================# 1113Oracle 执行 relink 1114#==============================================================# 11151116writing relink log to: /u01/app/oracle/product/11.2.0/db/install/relink.log11171118#==============================================================# 1119OJVM 补丁安装 1120#==============================================================# 11211122Oracle Interim Patch Installer version 11.2.0.3.441123Copyright (c) 2024, Oracle Corporation. All rights reserved.11241125PREREQ session11261127Oracle Home : /u01/app/oracle/product/11.2.0/db1128Central Inventory : /u01/app/oraInventory1129 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1130OPatch version : 11.2.0.3.441131OUI version : 11.2.0.4.01132Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_13-51-26PM_1.log11331134Invoking prereq "checkconflictagainstohwithdetail"11351136Prereq "checkConflictAgainstOHWithDetail" passed.11371138OPatch succeeded.1139Oracle Interim Patch Installer version 11.2.0.3.441140Copyright (c) 2024, Oracle Corporation. All rights reserved.114111421143Oracle Home : /u01/app/oracle/product/11.2.0/db1144Central Inventory : /u01/app/oraInventory1145 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1146OPatch version : 11.2.0.3.441147OUI version : 11.2.0.4.01148Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_13-51-29PM_1.log11491150Verifying environment and performing prerequisite checks...1151OPatch continues with these patches: 35685663 11521153Do you want to proceed? [y|n]1154Y (auto-answered by -silent)1155User Responded with: Y1156All checks passed.11571158Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1159(Oracle Home = '/u01/app/oracle/product/11.2.0/db')116011611162Is the local system ready for patching? [y|n]1163Y (auto-answered by -silent)1164User Responded with: Y1165Backing up files...1166Applying interim patch '35685663' to OH '/u01/app/oracle/product/11.2.0/db'1167ApplySession: 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.11681169Patching component oracle.javavm.server, 11.2.0.4.0...11701171Patching component oracle.precomp.common, 11.2.0.4.0...11721173Patching component oracle.rdbms, 11.2.0.4.0...11741175Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...11761177Patching component oracle.javavm.client, 11.2.0.4.0...11781179Patching component oracle.dbjava.jdbc, 11.2.0.4.0...11801181Patching component oracle.dbjava.ic, 11.2.0.4.0...1182Patch 35685663 successfully applied.1183Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_13-51-29PM_1.log11841185OPatch succeeded.11861187#==============================================================# 1188Oracle 软件版本 1189#==============================================================# 119011911192SQL*Plus: Release 11.2.0.4.0 Production119311941195#==============================================================# 1196Oracle 补丁信息 1197#==============================================================# 1198119935685663;OJVM PATCH SET UPDATE 11.2.0.4.231017120033991024;11204CERT ON OL8: LINKING ERRORS DURING 11204 FOR DB INSTALL ON OL8.2120135574075;Database Patch Set Update : 11.2.0.4.231017 (35574075)12021203OPatch succeeded.120412051206#==============================================================# 1207配置监听 1208#==============================================================# 120912101211Parsing command line arguments:1212 Parameter "silent" = true1213 Parameter "responsefile" = /u01/app/oracle/product/11.2.0/db/assistants/netca/netca.rsp1214Done parsing command line arguments.1215Oracle Net Services Configuration:1216Profile configuration complete.1217Oracle Net Listener Startup:1218 Running Listener Control: 1219 /u01/app/oracle/product/11.2.0/db/bin/lsnrctl start LISTENER1220 Listener Control complete.1221 Listener started successfully.1222Listener configuration complete.1223Oracle Net Services configuration successful. The exit code is 012241225检查监听状态： 122612271228LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 26-FEB-2024 13:52:0112291230Copyright (c) 1991, 2013, Oracle. All rights reserved.12311232Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))1233STATUS of the LISTENER1234------------------------1235Alias LISTENER1236Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production1237Start Date 26-FEB-2024 13:52:001238Uptime 0 days 0 hr. 0 min. 0 sec1239Trace Level off1240Security ON: Local OS Authentication1241SNMP OFF1242Listener Parameter File /u01/app/oracle/product/11.2.0/db/network/admin/listener.ora1243Listener Log File /u01/app/oracle/diag/tnslsnr/kylin/listener/alert/log.xml1244Listening Endpoints Summary...1245 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))1246 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kylin)(PORT=1521)))1247The listener supports no services1248The command completed successfully12491250#==============================================================# 1251静默建库命令 1252#==============================================================# 12531254dbca -silent -createDatabase \1255-templateName General_Purpose.dbc \1256-responseFile NO_VALUE \1257-gdbname lucifer \1258-sid lucifer \1259-sysPassword welcome1 \1260-systemPassword welcome1 \1261-redoLogFileSize 100 \1262-datafileDestination /oradata \1263-storageType FS \1264-characterSet AL32UTF8 \1265-nationalCharacterSet AL16UTF16 \1266-emConfiguration NONE \1267-automaticMemoryManagement false \1268-totalMemory 3342 \1269-databaseType OLTP 12701271#==============================================================# 1272创建数据库 1273#==============================================================# 12741275Copying database files12761% complete12773% complete127811% complete127918% complete128026% complete128137% complete1282Creating and starting Oracle instance128340% complete128445% complete128550% complete128655% complete128756% complete128860% complete128962% complete1290Completing Database Creation129166% complete129270% complete129373% complete129474% complete129575% complete129676% complete129777% complete129878% complete129979% complete130080% complete130192% complete1302100% complete1303Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.13041305#==============================================================# 1306配置在线重做日志 1307#==============================================================# 13081309数据库在线重做日志文件： 131013111312 THREAD# GROUP# MEMBER size(M)1313---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------1314 1 1 /oradata/lucifer/redo01.log 1001315 1 2 /oradata/lucifer/redo02.log 1001316 1 3 /oradata/lucifer/redo03.log 1001317 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_lxrbctj0_.log 1001318 1 11 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_11_lxrbctlc_.log 1001319 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_lxrbcto3_.log 1001320 1 12 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_12_lxrbctqg_.log 1001321 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_lxrbctsl_.log 1001322 1 13 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_13_lxrbctvx_.log 1001323 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_lxrbctyb_.log 1001324 1 14 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_14_lxrbcvb4_.log 1001325 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_lxrbcvnh_.log 1001326 1 15 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_15_lxrbcw59_.log 10013271328#==============================================================# 1329配置 RMAN 备份任务 1330#==============================================================# 13311332## OracleBegin133300 02 * * * /home/oracle/scripts/del_arch.sh1334#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh1335#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh13361337#==============================================================# 1338配置 glogin.sql 1339#==============================================================# 13401341define _editor=vi1342set serveroutput on size 10000001343set pagesize 99991344set long 999991345set trimspool on1346col name format a801347set termout off1348define gname=idle1349column global_name new_value gname1350select 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 );1351ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';1352set sqlprompt '&gname _DATE> '1353set termout on13541355#==============================================================# 1356优化数据库参数 1357#==============================================================# 13581359数据库参数： 136013611362NAME SID SPVALUE VALUE1363-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------1364_b_tree_bitmap_plans * FALSE FALSE1365_datafile_write_errors_crash_instance * FALSE FALSE1366audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump1367audit_trail * NONE DB1368compatible * 11.2.0.4.0 11.2.0.4.01369control_file_record_keep_time * 31 311370db_block_size * 8192 81921371db_create_file_dest * /oradata /oradata1372db_file_multiblock_read_count * 1281373db_files * 5000 2001374db_name * lucifer lucifer1375db_recovery_file_dest * /u01/app/oracle/fast_recovery_area /u01/app/oracle/fast_recovery_area1376db_recovery_file_dest_size * 4857004032 48570040321377db_writer_processes * 11378deferred_segment_creation * FALSE FALSE1379diagnostic_dest * /u01/app/oracle /u01/app/oracle1380dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)1381enable_ddl_logging * TRUE FALSE1382event * 10949 trace name context forever,level 11383event * 28401 trace name context forever,level 11384fast_start_parallel_rollback * LOW1385log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog1386log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf1387max_dump_file_size * unlimited1388open_cursors * 1000 3001389optimizer_index_caching * 01390optimizer_mode * ALL_ROWS1391parallel_force_local * FALSE1392parallel_max_servers * 64 641393pga_aggregate_target * 1120927744 7004487681394processes * 2000 1501395remote_login_passwordfile * EXCLUSIVE EXCLUSIVE1396resource_limit * TRUE FALSE1397resource_manager_plan * force:1398sec_case_sensitive_logon * FALSE TRUE1399session_cached_cursors * 300 501400sessions * 2481401sga_max_size * 4485808128 28185722881402sga_target * 4485808128 28185722881403spfile * /u01/app/oracle/product/11.2.0/db/dbs/spfilelucifer.ora1404statistics_level * TYPICAL1405undo_retention * 10800 90014061407恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N]重启数据库后，连接数据库：
1[oracle@kylin:/home/oracle]$ sas23SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 26 14:03:35 202445Copyright (c) 1982, 2013, Oracle. All rights reserved.678Connected to:9Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production10With the Partitioning, OLAP, Data Mining and Real Application Testing options1112sys@LUCIFER 2024-02-26 14:03:35> show parameter name1314NAME TYPE VALUE15------------------------------------ ----------- ------------------------------16cell_offloadgroup_name string17db_file_name_convert string18db_name string lucifer19db_unique_name string lucifer20global_names boolean FALSE21instance_name string lucifer22lock_name_space string23log_file_name_convert string24processor_group_name string25service_names string lucifer查看补丁版本：
1[oracle@kylin:/home/oracle]$ opatch lspatches235685663;OJVM PATCH SET UPDATE 11.2.0.4.231017333991024;11204CERT ON OL8: LINKING ERRORS DURING 11204 FOR DB INSTALL ON OL8.2435574075;Database Patch Set Update : 11.2.0.4.231017 (35574075)56OPatch succeeded.