在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 龙蜥 Anolis OS 8.8 一键安装 Oracle 11GR2（231017）单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oraclesh
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
Oracle 一键安装脚本，演示 龙蜥 Anolis OS 8.8 一键安装 Oracle 11GR2（231017）单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
✨ 偷懒可以直接下载本文安装包合集：龙蜥 Anolis OS 8.8 一键安装 Oracle 11GR2（231017）单机版安装包合集（包含补丁！！！）
1# 主机版本2[root@anolis8 soft]# cat /etc/anolis-release3Anolis OS release 8.845# 网络信息6[root@anolis8 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:c3:5e:e1 brd ff:ff:ff:ff:ff:ff9 altname enp2s110 inet 192.168.6.137/24 brd 192.168.6.255 scope global noprefixroute ens3311 valid_lft forever preferred_lft forever12 inet6 fe80::20c:29ff:fec3:5ee1/64 scope link noprefixroute 13 valid_lft forever preferred_lft forever1415# 挂载本地 ISO 镜像16[root@anolis8 soft]# mount | grep iso | grep -v "/run/media"17/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)18[root@anolis8 soft]# df -h|grep /mnt19/dev/sr0 15G 15G 0 100% /mnt2021# 安装包存放在 /soft 目录下22[root@anolis8 soft]# ll23-rwxr-xr-x 1 root root 163320 Mar 25 11:18 OracleShellInstall24-rwx------ 1 root root 1395582860 Mar 25 13:17 p13390677_112040_Linux-x86-64_1of7.zip25-rwx------ 1 root root 1151304589 Mar 25 13:16 p13390677_112040_Linux-x86-64_2of7.zip26-rwx------ 1 root root 8684 Mar 25 13:16 p33991024_11204220118_Generic.zip27-rwx------ 1 root root 562188912 Mar 25 13:16 p35574075_112040_Linux-x86-64.zip28-rwx------ 1 root root 86183099 Mar 25 13:16 p35685663_112040_Linux-x86-64.zip29-rwx------ 1 root root 128433424 Mar 25 13:17 p6880880_112000_Linux-x86-64.zip30-rwx------ 1 root root 321590 Mar 25 11:15 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf ens33 `# local ip ifname`\3-n anolis8 `# 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#==============================================================# 2223[BaseOS]24name=BaseOS25baseurl=file:///mnt/BaseOS26enabled=127gpgcheck=028[AppStream]29name=AppStream30baseurl=file:///mnt/AppStream31enabled=132gpgcheck=03334#==============================================================# 35禁用防火墙 36#==============================================================# 3738● firewalld.service - firewalld - dynamic firewall daemon39 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)40 Active: inactive (dead) since Mon 2024-03-25 13:21:48 CST; 61ms ago41 Docs: man:firewalld(1)42 Process: 1061 ExecStart=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS (code=exited, status=0/SUCCESS)43 Main PID: 1061 (code=exited, status=0/SUCCESS)4445Mar 25 11:12:31 anolis8 systemd[1]: Starting firewalld - dynamic firewall daemon...46Mar 25 11:12:33 anolis8 systemd[1]: Started firewalld - dynamic firewall daemon.47Mar 25 11:12:33 anolis8 firewalld[1061]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.48Mar 25 13:21:47 anolis8 systemd[1]: Stopping firewalld - dynamic firewall daemon...49Mar 25 13:21:48 anolis8 systemd[1]: firewalld.service: Succeeded.50Mar 25 13:21:48 anolis8 systemd[1]: Stopped firewalld - dynamic firewall daemon.5152#==============================================================# 53禁用 SELinux 54#==============================================================# 5556SELinux status: disabled5758#==============================================================# 59YUM 静默安装依赖包 60#==============================================================# 6162bc-1.07.1-5.0.1.an8.x86_6463binutils-2.30-117.0.1.an8.x86_6464package compat-libcap1 is not installed65gcc-8.5.0-10.1.0.3.an8.x86_6466gcc-c++-8.5.0-10.1.0.3.an8.x86_6467elfutils-libelf-0.187-4.0.1.an8.x86_6468elfutils-libelf-devel-0.187-4.0.1.an8.x86_6469glibc-2.28-189.5.0.2.an8_6.x86_6470glibc-devel-2.28-189.5.0.2.an8_6.x86_6471libaio-0.3.112-1.0.1.an8.x86_6472libaio-devel-0.3.112-1.0.1.an8.x86_6473libgcc-8.5.0-10.1.0.3.an8.x86_6474libstdc++-8.5.0-10.1.0.3.an8.x86_6475libstdc++-devel-8.5.0-10.1.0.3.an8.x86_6476libxcb-1.13.1-1.el8.x86_6477libX11-1.7.0-7.an8.x86_6478libXau-1.0.9-8.an8.x86_6479libXi-1.7.10-1.an8.x86_6480libXrender-0.9.10-7.el8.x86_6481make-4.2.1-11.0.1.an8.x86_6482net-tools-2.0-0.52.20160912git.an8.x86_6483smartmontools-7.1-1.0.2.an8.x86_6484sysstat-11.7.3-7.0.1.an8.x86_6485e2fsprogs-1.46.0-1.0.1.an8.x86_6486e2fsprogs-libs-1.46.0-1.0.1.an8.x86_6487unzip-6.0-46.0.1.an8.x86_6488openssh-clients-8.0p1-13.0.1.an8.x86_6489readline-7.0-10.0.1.an8.x86_6490readline-devel-7.0-10.0.1.an8.x86_6491psmisc-23.1-5.0.1.an8.x86_6492ksh-20120801-257.0.1.an8.x86_6493nfs-utils-2.3.3-51.0.3.an8.x86_6494tar-1.30-6.0.1.an8.x86_6495device-mapper-multipath-0.8.4-28.0.1.an8_6.2.x86_6496avahi-0.7-20.an8.x86_6497package ntp is not installed98chrony-4.2-1.0.1.an8.x86_6499libXtst-1.2.3-7.el8.x86_64100libXrender-devel-0.9.10-7.el8.x86_64101fontconfig-devel-2.13.1-4.an8.x86_64102policycoreutils-2.9-20.an8.x86_64103package policycoreutils-python is not installed104librdmacm-37.2-1.0.3.an8.x86_64105package libnsl* is not installed106libibverbs-37.2-1.0.3.an8.x86_64107compat-openssl10-1.0.2o-4.0.1.an8_6.x86_64108policycoreutils-python-utils-2.9-20.an8.noarch109package elfutils* is not installed110glibc-2.28-189.5.0.2.an8_6.x86_64111112#==============================================================# 113配置主机名 114#==============================================================# 115116anolis8117118#==============================================================# 119配置 /etc/hosts 文件 120#==============================================================# 121122127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4123::1 localhost localhost.localdomain localhost6 localhost6.localdomain6124125## OracleBegin126## Public IP127192.168.6.137 anolis8128129#==============================================================# 130创建用户和组 131#==============================================================# 132133oracle 用户： 134135uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)136137138#==============================================================# 139配置 Avahi-daemon 服务 140#==============================================================# 141142● avahi-daemon.service - Avahi mDNS/DNS-SD Stack143 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)144 Active: inactive (dead)145146Mar 25 11:12:36 anolis8 avahi-daemon[910]: New relevant interface virbr0.IPv4 for mDNS.147Mar 25 11:12:36 anolis8 avahi-daemon[910]: Registering new address record for 192.168.122.1 on virbr0.IPv4.148Mar 25 13:22:53 anolis8 avahi-daemon[910]: Got SIGTERM, quitting.149Mar 25 13:22:53 anolis8 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...150Mar 25 13:22:53 anolis8 avahi-daemon[910]: Leaving mDNS multicast group on interface virbr0.IPv4 with address 192.168.122.1.151Mar 25 13:22:53 anolis8 avahi-daemon[910]: Leaving mDNS multicast group on interface ens33.IPv6 with address fe80::20c:29ff:fec3:5ee1.152Mar 25 13:22:53 anolis8 avahi-daemon[910]: Leaving mDNS multicast group on interface ens33.IPv4 with address 192.168.6.137.153Mar 25 13:22:53 anolis8 avahi-daemon[910]: avahi-daemon 0.7 exiting.154Mar 25 13:22:53 anolis8 systemd[1]: avahi-daemon.service: Succeeded.155Mar 25 13:22:53 anolis8 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.156157#==============================================================# 158配置透明大页 && NUMA && 磁盘 IO 调度器 159#==============================================================# 160161args="ro resume=/dev/mapper/ao-swap rd.lvm.lv=ao/root rd.lvm.lv=ao/swap rhgb quiet $tuned_params cgroup.memory=nokmem crashkernel=0M-2G:0M,2G-8G:192M,8G-:256M numa=off transparent_hugepage=never elevator=deadline"162-resume=/dev/mapper/ao-swap163-args="ro164args="ro resume=/dev/mapper/ao-swap rd.lvm.lv=ao/root rd.lvm.lv=ao/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"165-elevator=deadline"166-transparent_hugepage=never167168#==============================================================# 169配置 sysctl.conf 170#==============================================================# 171172fs.aio-max-nr = 1048576173fs.file-max = 6815744174kernel.shmall = 2097152175kernel.shmmax = 8126386175176kernel.shmmni = 4096177kernel.sem = 250 32000 100 128178net.ipv4.ip_local_port_range = 9000 65500179net.core.rmem_default = 262144180net.core.rmem_max = 4194304181net.core.wmem_default = 262144182net.core.wmem_max = 1048576183vm.min_free_kbytes = 31743184net.ipv4.conf.ens33.rp_filter = 1185vm.swappiness = 10186kernel.panic_on_oops = 1187kernel.randomize_va_space = 2188kernel.numa_balancing = 0189190#==============================================================# 191配置 nsysctl.conf 192#==============================================================# 193194NOZEROCONF=yes195196#==============================================================# 197配置 RemoveIPC 198#==============================================================# 199200[Login]201RemoveIPC=no202203#==============================================================# 204配置 /etc/security/limits.conf 和 /etc/pam.d/login 205#==============================================================# 206207查看 /etc/security/limits.conf： 208209oracle soft nofile 1024210oracle hard nofile 65536211oracle soft stack 10240212oracle hard stack 32768213oracle soft nproc 2047214oracle hard nproc 16384215oracle hard memlock unlimited216oracle soft memlock unlimited217218查看 /etc/pam.d/login 文件： 219220auth substack system-auth221auth include postlogin222account required pam_nologin.so223account include system-auth224password include system-auth225session required pam_selinux.so close226session required pam_loginuid.so227session optional pam_console.so228session required pam_selinux.so open229session required pam_namespace.so230session optional pam_keyinit.so force revoke231session include system-auth232session include postlogin233-session optional pam_ck_connector.so234session required pam_limits.so235session required /lib64/security/pam_limits.so236237#==============================================================# 238配置 /dev/shm 239#==============================================================# 240241/dev/mapper/ao-root / xfs defaults 0 0242UUID=5b4f444b-7f7f-4cf1-9e1b-474e447b8075 /boot xfs defaults 0 0243/dev/mapper/ao-swap none swap defaults 0 0244tmpfs /dev/shm tmpfs size=7935924k 0 0245246#==============================================================# 247安装 rlwrap 插件 248#==============================================================# 249250成功安装 rlwrap： rlwrap 0.44 251252#==============================================================# 253Root 用户环境变量 254#==============================================================# 255256if [ -f ~/.bashrc ]; then257 . ~/.bashrc258fi259PATH=$PATH:$HOME/bin260export PATH261alias so='su - oracle'262export PS1="[`whoami`@`hostname`:"'$PWD]$ '263264#==============================================================# 265Oracle 用户环境变量 266#==============================================================# 267268if [ -f ~/.bashrc ]; then269 . ~/.bashrc270fi271umask 022272export TMP=/tmp273export TMPDIR=$TMP274export NLS_LANG=AMERICAN_AMERICA.AL32UTF8275export ORACLE_BASE=/u01/app/oracle276export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db277export ORACLE_TERM=xterm278export TNS_ADMIN=$ORACLE_HOME/network/admin279export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib280export ORACLE_SID=lucifer281export PATH=/usr/sbin:$PATH282export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH283export PERL5LIB=$ORACLE_HOME/perl/lib284alias sas='sqlplus / as sysdba'285alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'286alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'287alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'288export PS1="[`whoami`@`hostname`:"'$PWD]$ '289export CV_ASSUME_DISTID=OL7290alias sqlplus='rlwrap sqlplus'291alias rman='rlwrap rman'292alias adrci='rlwrap adrci'293294#==============================================================# 295静默解压 Oracle 软件包 296#==============================================================# 297298正在静默解压缩 Oracle 软件包，请稍等： 299300.---- -. -. . . . .301( .',----- - - ' ' ' __302 \_/ ;--:- __--------------------___ ____=========_||___303__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|304c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |305,_\___________'_|,L______],|______________________|_i,!________________!_i306/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)307""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""308309静默解压 Oracle 软件安装包： /soft/p13390677_112040_Linux-x86-64_1of7.zip,/soft/p13390677_112040_Linux-x86-64_2of7.zip 310311静默解压 Oracle 软件补丁包： /soft/p35574075*.zip 312313静默解压 Oracle 软件补丁包：/soft/p33991024_11204220118_Generic.zip 314315静默解压 OJVM 软件补丁包： /soft/p35685663*.zip 316317#==============================================================# 318Oracle 安装静默文件 319#==============================================================# 320321oracle.install.option=INSTALL_DB_SWONLY322UNIX_GROUP_NAME=oinstall323INVENTORY_LOCATION=/u01/app/oraInventory324ORACLE_BASE=/u01/app/oracle325oracle.install.db.InstallEdition=EE326oracle.install.db.DBA_GROUP=dba327oracle.install.db.OPER_GROUP=oper328oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0329SELECTED_LANGUAGES=en,zh_CN330ORACLE_HOME=/u01/app/oracle/product/11.2.0/db331DECLINE_SECURITY_UPDATES=true332oracle.installer.autoupdates.option=SKIP_UPDATES333334#==============================================================# 335静默安装数据库软件 336#==============================================================# 337338Starting Oracle Universal Installer...339340Checking Temp space: must be greater than 120 MB. Actual 79351 MB Passed341Checking swap space: must be greater than 150 MB. Actual 8183 MB Passed342Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-03-25_01-24-07PM. Please wait ...You can find the log of this install session at:343 /u01/app/oraInventory/logs/installActions2024-03-25_01-24-07PM.log344345Prepare in progress.346.................................................. 9% Done.347348Prepare successful.349350Copy files in progress.351.................................................. 14% Done.352.................................................. 20% Done.353.................................................. 26% Done.354.................................................. 31% Done.355.................................................. 36% Done.356.................................................. 41% Done.357.................................................. 47% Done.358.................................................. 52% Done.359.................................................. 57% Done.360.................................................. 63% Done.361.................................................. 68% Done.362.................................................. 73% Done.363.................................................. 78% Done.364.................................................. 83% Done.365..............................366Copy files successful.367368Link binaries in progress.369..........370Link binaries successful.371372Setup files in progress.373.................................................. 88% Done.374.................................................. 94% Done.375376Setup files successful.377The installation of Oracle Database 11g was successful.378Please check '/u01/app/oraInventory/logs/silentInstall2024-03-25_01-24-07PM.log' for more details.379380Execute Root Scripts in progress.381382As a root user, execute the following script(s):383 1. /u01/app/oraInventory/orainstRoot.sh384 2. /u01/app/oracle/product/11.2.0/db/root.sh385386387.................................................. 100% Done.388389Execute Root Scripts successful.390Successfully Setup Software.391392#==============================================================# 393执行 root 脚本 394#==============================================================# 395396Changing permissions of /u01/app/oraInventory.397Adding read,write permissions for group.398Removing read,write,execute permissions for world.399400Changing groupname of /u01/app/oraInventory to oinstall.401The execution of the script is complete.402Check /u01/app/oracle/product/11.2.0/db/install/root_anolis8_2024-03-25_13-27-34.log for the output of root script403404#==============================================================# 405Oracle 软件安装补丁 406#==============================================================# 407408Oracle Interim Patch Installer version 11.2.0.3.44409Copyright (c) 2024, Oracle Corporation. All rights reserved.410411PREREQ session412413Oracle Home : /u01/app/oracle/product/11.2.0/db414Central Inventory : /u01/app/oraInventory415 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc416OPatch version : 11.2.0.3.44417OUI version : 11.2.0.4.0418Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-25_13-27-39PM_1.log419420Invoking prereq "checkconflictagainstohwithdetail"421422Prereq "checkConflictAgainstOHWithDetail" passed.423424OPatch succeeded.425Oracle Interim Patch Installer version 11.2.0.3.44426Copyright (c) 2024, Oracle Corporation. All rights reserved.427428429Oracle Home : /u01/app/oracle/product/11.2.0/db430Central Inventory : /u01/app/oraInventory431 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc432OPatch version : 11.2.0.3.44433OUI version : 11.2.0.4.0434Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-25_13-27-42PM_1.log435436Verifying environment and performing prerequisite checks...437OPatch 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 438439Do you want to proceed? [y|n]440Y (auto-answered by -silent)441User Responded with: Y442All checks passed.443444Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.445(Oracle Home = '/u01/app/oracle/product/11.2.0/db')446447448Is the local system ready for patching? [y|n]449Y (auto-answered by -silent)450User Responded with: Y451Backing up files...452Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db'453454Patching component oracle.rdbms, 11.2.0.4.0...455456Patching component oracle.rdbms.rsf, 11.2.0.4.0...457458Patching component oracle.sdo, 11.2.0.4.0...459460Patching component oracle.sysman.agent, 10.2.0.4.5...461462Patching component oracle.xdk, 11.2.0.4.0...463464Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...465466Patching component oracle.sdo.locator, 11.2.0.4.0...467468Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...469470Patching component oracle.xdk.rsf, 11.2.0.4.0...471472Patching component oracle.rdbms.rman, 11.2.0.4.0...473Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/db'474475Patching component oracle.rdbms, 11.2.0.4.0...476477Patching component oracle.rdbms.rsf, 11.2.0.4.0...478479Patching component oracle.ldap.rsf, 11.2.0.4.0...480481Patching component oracle.rdbms.crs, 11.2.0.4.0...482483Patching component oracle.precomp.common, 11.2.0.4.0...484485Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...486487Patching component oracle.rdbms.deconfig, 11.2.0.4.0...488489Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...490491Patching component oracle.rdbms.rman, 11.2.0.4.0...492Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/db'493494Patching component oracle.rdbms.rsf, 11.2.0.4.0...495496Patching component oracle.rdbms, 11.2.0.4.0...497498Patching component oracle.precomp.common, 11.2.0.4.0...499500Patching component oracle.rdbms.rman, 11.2.0.4.0...501502Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...503504Patching component oracle.rdbms.deconfig, 11.2.0.4.0...505Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/db'506507Patching component oracle.precomp.common, 11.2.0.4.0...508509Patching component oracle.sysman.console.db, 11.2.0.4.0...510511Patching component oracle.rdbms.rsf, 11.2.0.4.0...512513Patching component oracle.rdbms.rman, 11.2.0.4.0...514515Patching component oracle.rdbms, 11.2.0.4.0...516517Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...518519Patching component oracle.ordim.client, 11.2.0.4.0...520521Patching component oracle.ordim.jai, 11.2.0.4.0...522Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/db'523ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.524525Patching component oracle.precomp.common, 11.2.0.4.0...526527Patching component oracle.ovm, 11.2.0.4.0...528529Patching component oracle.xdk, 11.2.0.4.0...530531Patching component oracle.rdbms.util, 11.2.0.4.0...532533Patching component oracle.rdbms, 11.2.0.4.0...534535Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...536537Patching component oracle.xdk.parser.java, 11.2.0.4.0...538539Patching component oracle.oraolap, 11.2.0.4.0...540541Patching component oracle.rdbms.rsf, 11.2.0.4.0...542543Patching component oracle.xdk.rsf, 11.2.0.4.0...544545Patching component oracle.rdbms.rman, 11.2.0.4.0...546547Patching component oracle.rdbms.deconfig, 11.2.0.4.0...548Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/db'549550Patching component oracle.rdbms.dv, 11.2.0.4.0...551552Patching component oracle.rdbms.oci, 11.2.0.4.0...553554Patching component oracle.precomp.common, 11.2.0.4.0...555556Patching component oracle.sysman.agent, 10.2.0.4.5...557558Patching component oracle.xdk, 11.2.0.4.0...559560Patching component oracle.sysman.common, 10.2.0.4.5...561562Patching component oracle.rdbms, 11.2.0.4.0...563564Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...565566Patching component oracle.xdk.parser.java, 11.2.0.4.0...567568Patching component oracle.sysman.console.db, 11.2.0.4.0...569570Patching component oracle.xdk.rsf, 11.2.0.4.0...571572Patching component oracle.rdbms.rsf, 11.2.0.4.0...573574Patching component oracle.sysman.common.core, 10.2.0.4.5...575576Patching component oracle.rdbms.rman, 11.2.0.4.0...577578Patching component oracle.rdbms.deconfig, 11.2.0.4.0...579Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0/db'580581Patching component oracle.sysman.console.db, 11.2.0.4.0...582583Patching component oracle.rdbms, 11.2.0.4.0...584585Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...586587Patching component oracle.rdbms.rsf, 11.2.0.4.0...588Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0/db'589590Patching component oracle.sysman.agent, 10.2.0.4.5...591592Patching component oracle.rdbms.rsf, 11.2.0.4.0...593594Patching component oracle.rdbms.rman, 11.2.0.4.0...595596Patching component oracle.rdbms, 11.2.0.4.0...597Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0/db'598ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.599600Patching component oracle.sysman.agent, 10.2.0.4.5...601602Patching component oracle.ovm, 11.2.0.4.0...603604Patching component oracle.xdk, 11.2.0.4.0...605606Patching component oracle.rdbms, 11.2.0.4.0...607608Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...609610Patching component oracle.xdk.parser.java, 11.2.0.4.0...611612Patching component oracle.sysman.console.db, 11.2.0.4.0...613614Patching component oracle.xdk.rsf, 11.2.0.4.0...615616Patching component oracle.rdbms.rsf, 11.2.0.4.0...617618Patching component oracle.sysman.oms.core, 10.2.0.4.5...619Applying sub-patch '22502456' to OH '/u01/app/oracle/product/11.2.0/db'620ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.621622Patching component oracle.precomp.common, 11.2.0.4.0...623624Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...625626Patching component oracle.rdbms.olap, 11.2.0.4.0...627628Patching component oracle.oraolap, 11.2.0.4.0...629630Patching component oracle.rdbms.rsf, 11.2.0.4.0...631632Patching component oracle.rdbms.rman, 11.2.0.4.0...633634Patching component oracle.rdbms, 11.2.0.4.0...635636Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...637Applying sub-patch '23054359' to OH '/u01/app/oracle/product/11.2.0/db'638639Patching component oracle.rdbms.dv, 11.2.0.4.0...640641Patching component oracle.rdbms, 11.2.0.4.0...642643Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...644645Patching component oracle.rdbms.rsf, 11.2.0.4.0...646Applying sub-patch '24006111' to OH '/u01/app/oracle/product/11.2.0/db'647648Patching component oracle.sqlplus.ic, 11.2.0.4.0...649650Patching component oracle.sqlplus, 11.2.0.4.0...651652Patching component oracle.rdbms.rsf, 11.2.0.4.0...653654Patching component oracle.rdbms, 11.2.0.4.0...655656Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...657Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0/db'658659Patching component oracle.precomp.common, 11.2.0.4.0...660661Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...662663Patching component oracle.sqlplus.ic, 11.2.0.4.0...664665Patching component oracle.sqlplus, 11.2.0.4.0...666667Patching component oracle.rdbms.rsf, 11.2.0.4.0...668669Patching component oracle.rdbms, 11.2.0.4.0...670671Patching component oracle.rdbms.util, 11.2.0.4.0...672673Patching component oracle.ordim.client, 11.2.0.4.0...674675Patching component oracle.ordim.jai, 11.2.0.4.0...676677Patching component oracle.ordim.server, 11.2.0.4.0...678Applying sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0/db'679ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.680681Patching component oracle.ldap.rsf, 11.2.0.4.0...682683Patching component oracle.oracore.rsf, 11.2.0.4.0...684685Patching component oracle.rdbms, 11.2.0.4.0...686687Patching component oracle.rdbms.rsf, 11.2.0.4.0...688689Patching component oracle.rdbms.rman, 11.2.0.4.0...690Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/db'691692Patching component oracle.oracore.rsf, 11.2.0.4.0...693694Patching component oracle.rdbms, 11.2.0.4.0...695Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0/db'696ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.697698Patching component oracle.network.rsf, 11.2.0.4.0...699700Patching component oracle.ldap.client, 11.2.0.4.0...701702Patching component oracle.sysman.agent, 10.2.0.4.5...703704Patching component oracle.xdk, 11.2.0.4.0...705706Patching component oracle.rdbms, 11.2.0.4.0...707708Patching component oracle.network.listener, 11.2.0.4.0...709710Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...711712Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...713714Patching component oracle.xdk.parser.java, 11.2.0.4.0...715716Patching component oracle.xdk.rsf, 11.2.0.4.0...717718Patching component oracle.rdbms.rsf, 11.2.0.4.0...719720Patching component oracle.rdbms.rman, 11.2.0.4.0...721Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0/db'722723Patching component oracle.rdbms, 11.2.0.4.0...724725Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...726727Patching component oracle.rdbms.rman, 11.2.0.4.0...728729Patching component oracle.rdbms.rsf, 11.2.0.4.0...730Applying sub-patch '27338049' to OH '/u01/app/oracle/product/11.2.0/db'731732Patching component oracle.assistants.server, 11.2.0.4.0...733734Patching component oracle.rdbms.rsf, 11.2.0.4.0...735736Patching component oracle.rdbms, 11.2.0.4.0...737738Patching component oracle.rdbms.rman, 11.2.0.4.0...739740Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...741Applying sub-patch '27734982' to OH '/u01/app/oracle/product/11.2.0/db'742743Patching component oracle.ctx, 11.2.0.4.0...744745Patching component oracle.rdbms.rsf, 11.2.0.4.0...746747Patching component oracle.ctx.rsf, 11.2.0.4.0...748749Patching component oracle.rdbms, 11.2.0.4.0...750751Patching component oracle.rdbms.rman, 11.2.0.4.0...752Applying sub-patch '28204707' to OH '/u01/app/oracle/product/11.2.0/db'753Applying changes to emctl script on the home: /u01/app/oracle/product/11.2.0/db ...754755Patching component oracle.rdbms, 11.2.0.4.0...756757Patching component oracle.oracore.rsf, 11.2.0.4.0...758759Patching component oracle.rdbms.rsf, 11.2.0.4.0...760761Patching component oracle.ldap.rsf, 11.2.0.4.0...762763Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...764765Patching component oracle.network.rsf, 11.2.0.4.0...766767Patching component oracle.sysman.agent, 10.2.0.4.5...768769Patching component oracle.sysman.console.db, 11.2.0.4.0...770771Patching component oracle.ldap.security.osdt, 11.2.0.4.0...772773Patching component oracle.ldap.owm, 11.2.0.4.0...774775Patching component oracle.sqlplus.rsf, 11.2.0.4.0...776777Patching component oracle.ctx, 11.2.0.4.0...778Applying sub-patch '28729262' to OH '/u01/app/oracle/product/11.2.0/db'779INFO: Script isn't applicable to this port!780781Patching component oracle.rdbms, 11.2.0.4.0...782783Patching component oracle.rdbms.rsf, 11.2.0.4.0...784785Patching component oracle.rdbms.util, 11.2.0.4.0...786787Patching component oracle.ldap.rsf, 11.2.0.4.0...788789Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...790791Patching component oracle.network.rsf, 11.2.0.4.0...792793Patching component oracle.rdbms.rman, 11.2.0.4.0...794795Patching component oracle.ctx, 11.2.0.4.0...796Applying sub-patch '29141056' to OH '/u01/app/oracle/product/11.2.0/db'797798Patching component oracle.rdbms, 11.2.0.4.0...799800Patching component oracle.rdbms.rman, 11.2.0.4.0...801802Patching component oracle.oracore.rsf, 11.2.0.4.0...803804Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...805806Patching component oracle.rdbms.rsf, 11.2.0.4.0...807Applying sub-patch '29497421' to OH '/u01/app/oracle/product/11.2.0/db'808809Patching component oracle.rdbms, 11.2.0.4.0...810811Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...812813Patching component oracle.rdbms.rman, 11.2.0.4.0...814815Patching component oracle.rdbms.rsf, 11.2.0.4.0...816817Patching component oracle.ldap.rsf, 11.2.0.4.0...818819Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...820821Patching component oracle.oracore.rsf, 11.2.0.4.0...822823Patching component oracle.ctx, 11.2.0.4.0...824Applying sub-patch '29913194' to OH '/u01/app/oracle/product/11.2.0/db'825826Patching component oracle.rdbms, 11.2.0.4.0...827828Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...829830Patching component oracle.rdbms.rsf, 11.2.0.4.0...831832Patching component oracle.network.rsf, 11.2.0.4.0...833834Patching component oracle.ldap.rsf, 11.2.0.4.0...835836Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...837838Patching component oracle.rdbms.util, 11.2.0.4.0...839Applying sub-patch '30298532' to OH '/u01/app/oracle/product/11.2.0/db'840ApplySession: 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.841842Patching component oracle.rdbms.rsf, 11.2.0.4.0...843844Patching component oracle.rdbms, 11.2.0.4.0...845846Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...847848Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...849850Patching component oracle.ldap.rsf, 11.2.0.4.0...851852Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...853Applying sub-patch '30670774' to OH '/u01/app/oracle/product/11.2.0/db'854855Patching component oracle.rdbms.rsf, 11.2.0.4.0...856857Patching component oracle.rdbms, 11.2.0.4.0...858859Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...860861Patching component oracle.network.rsf, 11.2.0.4.0...862863Patching component oracle.ldap.rsf, 11.2.0.4.0...864865Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...866867Patching component oracle.swd.oui, 11.2.0.4.0...868869Patching component oracle.ctx, 11.2.0.4.0...870Applying sub-patch '31103343' to OH '/u01/app/oracle/product/11.2.0/db'871872Patching component oracle.rdbms, 11.2.0.4.0...873874Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...875876Patching component oracle.rdbms.rsf, 11.2.0.4.0...877Applying sub-patch '31537677' to OH '/u01/app/oracle/product/11.2.0/db'878879Patching component oracle.rdbms, 11.2.0.4.0...880881Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...882883Patching component oracle.rdbms.rsf, 11.2.0.4.0...884885Patching component oracle.rdbms.dv, 11.2.0.4.0...886887Patching component oracle.rdbms.rman, 11.2.0.4.0...888889Patching component oracle.ldap.rsf, 11.2.0.4.0...890891Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...892893Patching component oracle.oracore.rsf, 11.2.0.4.0...894895Patching component oracle.rdbms.util, 11.2.0.4.0...896897Patching component oracle.dbdev, 11.2.0.4.0...898899Patching component oracle.ctx, 11.2.0.4.0...900901Patching component oracle.buildtools.rsf, 11.2.0.4.0...902Applying sub-patch '31983472' to OH '/u01/app/oracle/product/11.2.0/db'903904Patching component oracle.rdbms.rsf, 11.2.0.4.0...905906Patching component oracle.rdbms, 11.2.0.4.0...907908Patching component oracle.ctx, 11.2.0.4.0...909Applying sub-patch '32328626' to OH '/u01/app/oracle/product/11.2.0/db'910911Patching component oracle.rdbms, 11.2.0.4.0...912913Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...914915Patching component oracle.rdbms.rsf, 11.2.0.4.0...916917Patching component oracle.rdbms.dv, 11.2.0.4.0...918919Patching component oracle.rdbms.rman, 11.2.0.4.0...920921Patching component oracle.ldap.rsf, 11.2.0.4.0...922923Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...924Applying sub-patch '32758711' to OH '/u01/app/oracle/product/11.2.0/db'925926Patching component oracle.rdbms, 11.2.0.4.0...927928Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...929930Patching component oracle.ctx, 11.2.0.4.0...931932Patching component oracle.network.rsf, 11.2.0.4.0...933Applying sub-patch '33128584' to OH '/u01/app/oracle/product/11.2.0/db'934935Patching component oracle.rdbms, 11.2.0.4.0...936937Patching component oracle.rdbms.rsf, 11.2.0.4.0...938939Patching component oracle.ctx, 11.2.0.4.0...940Applying sub-patch '33477185' to OH '/u01/app/oracle/product/11.2.0/db'941942Patching component oracle.rdbms, 11.2.0.4.0...943944Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...945946Patching component oracle.rdbms.rsf, 11.2.0.4.0...947948Patching component oracle.network.rsf, 11.2.0.4.0...949950Patching component oracle.rdbms.dv, 11.2.0.4.0...951Applying sub-patch '33711103' to OH '/u01/app/oracle/product/11.2.0/db'952ApplySession: 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.953954Patching component oracle.rdbms.rsf, 11.2.0.4.0...955956Patching component oracle.rdbms, 11.2.0.4.0...957958Patching component oracle.rdbms.rsf, 11.2.0.4.0...959960Patching component oracle.network.rsf, 11.2.0.4.0...961962Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...963964Patching component oracle.rdbms.hs_common, 11.2.0.4.0...965966Patching component oracle.buildtools.rsf, 11.2.0.4.0...967968Patching component oracle.buildtools.rsf, 11.2.0.4.0...969Applying sub-patch '34057724' to OH '/u01/app/oracle/product/11.2.0/db'970ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.971972Patching component oracle.rdbms, 11.2.0.4.0...973974Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...975976Patching component oracle.rdbms.rsf, 11.2.0.4.0...977978Patching component oracle.network.rsf, 11.2.0.4.0...979980Patching component oracle.ldap.rsf, 11.2.0.4.0...981982Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...983984Patching component oracle.swd.oui.core, 11.2.0.4.0...985Applying sub-patch '34386237' to OH '/u01/app/oracle/product/11.2.0/db'986ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.987988Patching component oracle.rdbms, 11.2.0.4.0...989990Patching component oracle.rdbms.rsf, 11.2.0.4.0...991992Patching component oracle.network.rsf, 11.2.0.4.0...993994Patching component oracle.swd.oui.core, 11.2.0.4.0...995996Patching component oracle.ctx, 11.2.0.4.0...997Applying sub-patch '34677698' to OH '/u01/app/oracle/product/11.2.0/db'998ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.9991000Patching component oracle.rdbms, 11.2.0.4.0...10011002Patching component oracle.rdbms.rsf, 11.2.0.4.0...10031004Patching component oracle.javavm.containers, 11.2.0.4.0...1005Applying sub-patch '34998337' 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.rdbms.rsf, 11.2.0.4.0...1011Applying sub-patch '35269283' to OH '/u01/app/oracle/product/11.2.0/db'1012ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.10131014Patching component oracle.rdbms, 11.2.0.4.0...10151016Patching component oracle.network.rsf, 11.2.0.4.0...10171018Patching component oracle.rdbms.rsf, 11.2.0.4.0...10191020Patching component oracle.dbdev, 11.2.0.4.0...1021Applying sub-patch '35574075' to OH '/u01/app/oracle/product/11.2.0/db'1022ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.10231024Patching component oracle.rdbms, 11.2.0.4.0...10251026Patching component oracle.rdbms.rsf, 11.2.0.4.0...10271028Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10291030Patching component oracle.network.rsf, 11.2.0.4.0...10311032Patching component oracle.rdbms.rsf, 11.2.0.4.0...10331034Patching component oracle.sysman.oms.core, 10.2.0.4.5...10351036Patching component oracle.marvel, 11.2.0.4.0...10371038Patching component oracle.javavm.containers, 11.2.0.4.0...10391040Patching component oracle.dbjava.ucp, 11.2.0.4.0...10411042Patching component oracle.owb.rsf, 11.2.0.4.0...10431044Patching component oracle.sysman.ccr, 10.3.8.1.0...10451046Patching component oracle.sysman.ccr.client, 10.3.2.1.0...10471048Patching component oracle.sysman.common, 10.2.0.4.5...10491050Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...10511052Patching component oracle.javavm.containers, 11.2.0.4.0...1053Composite patch 35574075 successfully applied.1054Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-25_13-27-42PM_1.log10551056OPatch succeeded.10571058#==============================================================# 1059Oracle 软件安装补丁 33991024 1060#==============================================================# 10611062Oracle Interim Patch Installer version 11.2.0.3.441063Copyright (c) 2024, Oracle Corporation. All rights reserved.10641065PREREQ session10661067Oracle Home : /u01/app/oracle/product/11.2.0/db1068Central Inventory : /u01/app/oraInventory1069 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1070OPatch version : 11.2.0.3.441071OUI version : 11.2.0.4.01072Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-25_13-37-48PM_1.log10731074Invoking prereq "checkconflictagainstohwithdetail"10751076Prereq "checkConflictAgainstOHWithDetail" passed.10771078OPatch succeeded.1079Oracle Interim Patch Installer version 11.2.0.3.441080Copyright (c) 2024, Oracle Corporation. All rights reserved.108110821083Oracle Home : /u01/app/oracle/product/11.2.0/db1084Central Inventory : /u01/app/oraInventory1085 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1086OPatch version : 11.2.0.3.441087OUI version : 11.2.0.4.01088Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-25_13-37-51PM_1.log10891090Verifying environment and performing prerequisite checks...1091OPatch continues with these patches: 33991024 10921093Do you want to proceed? [y|n]1094Y (auto-answered by -silent)1095User Responded with: Y1096All checks passed.10971098Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1099(Oracle Home = '/u01/app/oracle/product/11.2.0/db')110011011102Is the local system ready for patching? [y|n]1103Y (auto-answered by -silent)1104User Responded with: Y1105Backing up files...1106Applying interim patch '33991024' to OH '/u01/app/oracle/product/11.2.0/db'11071108Patching component oracle.rdbms.rsf, 11.2.0.4.0...11091110Patching component oracle.buildtools.rsf, 11.2.0.4.0...11111112Patching component oracle.has.db, 11.2.0.4.0...1113Patch 33991024 successfully applied.1114Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-25_13-37-51PM_1.log11151116OPatch succeeded.11171118#==============================================================# 1119Oracle 执行 relink 1120#==============================================================# 11211122writing relink log to: /u01/app/oracle/product/11.2.0/db/install/relink.log11231124#==============================================================# 1125OJVM 补丁安装 1126#==============================================================# 11271128Oracle Interim Patch Installer version 11.2.0.3.441129Copyright (c) 2024, Oracle Corporation. All rights reserved.11301131PREREQ session11321133Oracle Home : /u01/app/oracle/product/11.2.0/db1134Central Inventory : /u01/app/oraInventory1135 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1136OPatch version : 11.2.0.3.441137OUI version : 11.2.0.4.01138Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-25_13-39-02PM_1.log11391140Invoking prereq "checkconflictagainstohwithdetail"11411142Prereq "checkConflictAgainstOHWithDetail" passed.11431144OPatch succeeded.1145Oracle Interim Patch Installer version 11.2.0.3.441146Copyright (c) 2024, Oracle Corporation. All rights reserved.114711481149Oracle Home : /u01/app/oracle/product/11.2.0/db1150Central Inventory : /u01/app/oraInventory1151 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc1152OPatch version : 11.2.0.3.441153OUI version : 11.2.0.4.01154Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-25_13-39-05PM_1.log11551156Verifying environment and performing prerequisite checks...1157OPatch continues with these patches: 35685663 11581159Do you want to proceed? [y|n]1160Y (auto-answered by -silent)1161User Responded with: Y1162All checks passed.11631164Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.1165(Oracle Home = '/u01/app/oracle/product/11.2.0/db')116611671168Is the local system ready for patching? [y|n]1169Y (auto-answered by -silent)1170User Responded with: Y1171Backing up files...1172Applying interim patch '35685663' to OH '/u01/app/oracle/product/11.2.0/db'1173ApplySession: 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.11741175Patching component oracle.javavm.server, 11.2.0.4.0...11761177Patching component oracle.precomp.common, 11.2.0.4.0...11781179Patching component oracle.rdbms, 11.2.0.4.0...11801181Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...11821183Patching component oracle.javavm.client, 11.2.0.4.0...11841185Patching component oracle.dbjava.jdbc, 11.2.0.4.0...11861187Patching component oracle.dbjava.ic, 11.2.0.4.0...1188Patch 35685663 successfully applied.1189Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2024-03-25_13-39-05PM_1.log11901191OPatch succeeded.11921193#==============================================================# 1194Oracle 软件版本 1195#==============================================================# 119611971198SQL*Plus: Release 11.2.0.4.0 Production119912001201#==============================================================# 1202Oracle 补丁信息 1203#==============================================================# 1204120535685663;OJVM PATCH SET UPDATE 11.2.0.4.231017120633991024;11204CERT ON OL8: LINKING ERRORS DURING 11204 FOR DB INSTALL ON OL8.2120735574075;Database Patch Set Update : 11.2.0.4.231017 (35574075)12081209OPatch succeeded.121012111212#==============================================================# 1213配置监听 1214#==============================================================# 121512161217Parsing command line arguments:1218 Parameter "silent" = true1219 Parameter "responsefile" = /u01/app/oracle/product/11.2.0/db/assistants/netca/netca.rsp1220Done parsing command line arguments.1221Oracle Net Services Configuration:1222Profile configuration complete.1223Oracle Net Listener Startup:1224 Running Listener Control: 1225 /u01/app/oracle/product/11.2.0/db/bin/lsnrctl start LISTENER1226 Listener Control complete.1227 Listener started successfully.1228Listener configuration complete.1229Oracle Net Services configuration successful. The exit code is 012301231检查监听状态： 123212331234LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-MAR-2024 13:39:5712351236Copyright (c) 1991, 2013, Oracle. All rights reserved.12371238Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))1239STATUS of the LISTENER1240------------------------1241Alias LISTENER1242Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production1243Start Date 25-MAR-2024 13:39:471244Uptime 0 days 0 hr. 0 min. 10 sec1245Trace Level off1246Security ON: Local OS Authentication1247SNMP OFF1248Listener Parameter File /u01/app/oracle/product/11.2.0/db/network/admin/listener.ora1249Listener Log File /u01/app/oracle/diag/tnslsnr/anolis8/listener/alert/log.xml1250Listening Endpoints Summary...1251 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))1252 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=anolis8)(PORT=1521)))1253The listener supports no services1254The command completed successfully12551256#==============================================================# 1257静默建库命令 1258#==============================================================# 12591260dbca -silent -createDatabase \1261-templateName General_Purpose.dbc \1262-responseFile NO_VALUE \1263-gdbname lucifer \1264-sid lucifer \1265-sysPassword oracle \1266-systemPassword oracle \1267-redoLogFileSize 100 \1268-datafileDestination /oradata \1269-storageType FS \1270-characterSet AL32UTF8 \1271-nationalCharacterSet AL16UTF16 \1272-emConfiguration NONE \1273-automaticMemoryManagement false \1274-totalMemory 3874 \1275-databaseType OLTP 12761277#==============================================================# 1278创建数据库 1279#==============================================================# 12801281Copying database files12821% complete12833% complete128411% complete128518% complete128626% complete128737% complete1288Creating and starting Oracle instance128940% complete129045% complete129150% complete129255% complete129356% complete129460% complete129562% complete1296Completing Database Creation129766% complete129870% complete129973% complete130074% complete130175% complete130276% complete130377% complete130478% complete130579% complete130680% complete130792% complete1308100% complete1309Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.13101311#==============================================================# 1312配置在线重做日志 1313#==============================================================# 13141315数据库在线重做日志文件： 131613171318 THREAD# GROUP# MEMBER size(M)1319---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------1320 1 1 /oradata/lucifer/redo01.log 1001321 1 2 /oradata/lucifer/redo02.log 1001322 1 3 /oradata/lucifer/redo03.log 1001323 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_m02458gl_.log 1001324 1 11 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_11_m02458m9_.log 1001325 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_m02458px_.log 1001326 1 12 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_12_m02458vx_.log 1001327 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_m024590o_.log 1001328 1 13 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_13_m024594q_.log 1001329 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_m024598d_.log 1001330 1 14 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_14_m02459qm_.log 1001331 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_m0245b4n_.log 1001332 1 15 /u01/app/oracle/fast_recovery_area/LUCIFER/onlinelog/o1_mf_15_m0245btp_.log 10013331334#==============================================================# 1335配置 RMAN 备份任务 1336#==============================================================# 13371338## OracleBegin133900 02 * * * /home/oracle/scripts/del_arch.sh1340#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh1341#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh13421343#==============================================================# 1344配置 glogin.sql 1345#==============================================================# 13461347define _editor=vi1348set serveroutput on size 10000001349set pagesize 99991350set long 999991351set trimspool on1352col name format a801353set termout off1354define gname=idle1355column global_name new_value gname1356select 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 );1357ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';1358set sqlprompt '&gname _DATE> '1359set termout on13601361#==============================================================# 1362优化数据库参数 1363#==============================================================# 13641365数据库参数： 136613671368NAME SID SPVALUE VALUE1369-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------1370_b_tree_bitmap_plans * FALSE FALSE1371_datafile_write_errors_crash_instance * FALSE FALSE1372audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump1373audit_trail * NONE DB1374compatible * 11.2.0.4.0 11.2.0.4.01375control_file_record_keep_time * 31 311376db_block_size * 8192 81921377db_create_file_dest * /oradata /oradata1378db_file_multiblock_read_count * 1281379db_files * 5000 2001380db_name * lucifer lucifer1381db_recovery_file_dest * /u01/app/oracle/fast_recovery_area /u01/app/oracle/fast_recovery_area1382db_recovery_file_dest_size * 4857004032 48570040321383db_writer_processes * 11384deferred_segment_creation * FALSE FALSE1385diagnostic_dest * /u01/app/oracle /u01/app/oracle1386dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)1387enable_ddl_logging * TRUE FALSE1388event * 10949 trace name context forever,level 11389event * 28401 trace name context forever,level 11390fast_start_parallel_rollback * LOW1391log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog1392log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf1393max_dump_file_size * unlimited1394open_cursors * 1000 3001395optimizer_index_caching * 01396optimizer_mode * ALL_ROWS1397parallel_force_local * FALSE1398parallel_max_servers * 64 641399pga_aggregate_target * 1299185664 8115978241400processes * 2000 1501401remote_login_passwordfile * EXCLUSIVE EXCLUSIVE1402resource_limit * TRUE FALSE1403resource_manager_plan * force:1404sec_case_sensitive_logon * FALSE TRUE1405session_cached_cursors * 300 501406sessions * 2481407sga_max_size * 5199888384 32547799041408sga_target * 5199888384 32547799041409spfile * /u01/app/oracle/product/11.2.0/db/dbs/spfilelucifer.ora1410statistics_level * TYPICAL1411undo_retention * 10800 90014121413恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y