Oracle 11.2.0.4单机数据库,由于漏扫出现较多CVE等漏洞,需要安装SPU补丁。由于Oracle 11.2.0.4停止支持,能下载到的最后补丁是2020年10月的补丁:SPU 31834759
参考补丁中的readme文件,要求opatch版本至少为optch 11.2.0.3.15,需要先下载opatch,下载链接:
https://updates.oracle.com/download/6880880.html,选好相应的数据库版本和操作系统平台
按readme中描述,大致步骤为:
1、更新opatch
2、停止监听
3、停止数据库
4、更新SPU
5、启动数据库
6、刷数据字典
7、编译失效对象
8、启动监听
以下为实际的安装补丁步骤:
- 更新opatch
不赘述,解压opatch包至$ORACLE_HOME下即可
- 停止监听
[oracle@ywdata ~]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 11-MAY-2023 21:19:09
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=ywdata)(PORT=1521))
The command completed successfully
- 停止数据库
[oracle@ywdata ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu May 11 21:19:16 2023
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
YWDATA READ WRITE PRIMARY
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ywdata ~]$ ps -ef | grep smon
oracle 146626 139336 0 21:20 pts/4 00:00:00 grep --color=auto smon
- 安装补丁
[oracle@ywdata ~]$ cd $ORACLE_HOME/OPatch
[oracle@ywdata OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.40
OPatch succeeded.
[oracle@ywdata OPatch]$ ./opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.40
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.40
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2023-05-11_21-21-17PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2023-05-11_21-21-17PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ywdata
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@ywdata ~]$ unzip p31834759_112040_Linux-x86-64.zip
[oracle@ywdata ~]$ cd 31834759
[oracle@ywdata 31834759]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply
[oracle@ywdata 31834759]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply
Oracle Interim Patch Installer version 11.2.0.3.40
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.40
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2023-05-11_21-23-16PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17811429 17811438 17811447 18203835 19463893 19544839 19972564 19972568 20142975 21051833 21051840 21051858 21051862 21179898 21538558 22195441 22195465 22195477 22195492 22321741 22321756 22683225 22893153 23330124 24476265 24476274 24528741 25505371 25505382 25505394 25505407 26030218 26667023 28100487 29033139 30275351 30275359 30562891 30562907 30562909 30562923 30562936 31022191 31492144 31492164 31492176 31834759 31883489 31884535 31885179 31885190 31885201 31885213 31885223 31885230
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '17811429' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '17811438' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '17811447' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.sdo, 11.2.0.4.0...
Patching component oracle.sdo.locator, 11.2.0.4.0...
Applying interim patch '18203835' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying interim patch '19463893' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '19544839' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Applying interim patch '19972564' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.util, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '19972568' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.oraolap, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '20142975' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying interim patch '21051833' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '21051840' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '21051858' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '21051862' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Applying interim patch '21179898' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '21538558' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '22195441' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '22195465' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '22195477' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.sysman.agent, 10.2.0.4.5...
Applying interim patch '22195492' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.ovm, 11.2.0.4.0...
Applying interim patch '22321741' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.sysman.agent, 10.2.0.4.5...
Applying interim patch '22321756' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.sysman.agent, 10.2.0.4.5...
Applying interim patch '22683225' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.olap, 11.2.0.4.0...
Patching component oracle.oraolap, 11.2.0.4.0...
Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...
Applying interim patch '22893153' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '23330124' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying interim patch '24476265' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying interim patch '24476274' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.sqlplus, 11.2.0.4.0...
Patching component oracle.sqlplus.ic, 11.2.0.4.0...
Applying interim patch '24528741' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying interim patch '25505371' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '25505382' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '25505394' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.sqlplus, 11.2.0.4.0...
Patching component oracle.sqlplus.ic, 11.2.0.4.0...
Applying interim patch '25505407' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.ordim.client, 11.2.0.4.0...
Patching component oracle.ordim.jai, 11.2.0.4.0...
Patching component oracle.ordim.server, 11.2.0.4.0...
Applying interim patch '26030218' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '26667023' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Applying interim patch '28100487' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying interim patch '29033139' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
--------------------------------------------------------------------------------
The patch has more than one Archive Action but there is no Make Action.
--------------------------------------------------------------------------------
Applying interim patch '30275351' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying interim patch '30275359' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.util, 11.2.0.4.0...
Applying interim patch '30562891' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '30562907' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
ApplySession: 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.
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...
Applying interim patch '30562909' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying interim patch '30562923' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '30562936' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.swd.oui, 11.2.0.4.0...
Applying interim patch '31022191' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying interim patch '31492144' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying interim patch '31492164' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying interim patch '31492176' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '31834759' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying interim patch '31883489' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Applying interim patch '31884535' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying interim patch '31885179' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying interim patch '31885190' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Applying interim patch '31885201' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.util, 11.2.0.4.0...
Applying interim patch '31885213' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.ctx, 11.2.0.4.0...
Applying interim patch '31885223' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.dbdev, 11.2.0.4.0...
Applying interim patch '31885230' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning: overriding recipe for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old recipe for target `nmosudo'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding recipe for target `nmosudo'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old recipe for target `nmosudo'
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning: overriding recipe for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old recipe for target `nmosudo'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding recipe for target `nmosudo'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old recipe for target `nmosudo'
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
Patches 17811429,17811438,17811447,18203835,19463893,19544839,19972564,19972568,20142975,21051833,21051840,21051858,21051862,21179898,21538558,22195441,22195465,22195477,22195492,22321741,22321756,22683225,22893153,23330124,24476265,24476274,24528741,25505371,25505382,25505394,25505407,26030218,26667023,28100487,29033139,30275351,30275359,30562891,30562907,30562909,30562923,30562936,31022191,31492144,31492164,31492176,31834759,31883489,31884535,31885179,31885190,31885201,31885213,31885223,31885230 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2023-05-11_21-23-16PM_1.log
OPatch completed with warnings.
[oracle@ywdata 31834759]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/
[oracle@ywdata lib]$ make -f ins_emagent.mk e2eme
ins_emagent.mk:113: warning: overriding recipe for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old recipe for target `nmosudo'
make -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk relink_exe EXENAME=e2eme
make[1]: Entering directory `/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding recipe for target `nmosudo'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old recipe for target `nmosudo'
gcc -o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/e2eme -L/u01/app/oracle/product/11.2.0/dbhome_1/lib/ -L/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/11.2.0/dbhome_1/lib -lm `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/11.2.0/dbhome_1/lib /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/nmaj.o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/nmajclbk.o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/nmajrules.o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/nmajutl.o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/nmajout.o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/nmajsm.o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/snmajutl.o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/snmajmn.o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/snmajpt.o /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ssnmajed.o -lnmadbg -lnmadm -lnmalk -lnmarl -lnmasf -lnmastk -lxml11 -lcore11 -lnls11 -lunls11 -lclntsh -Wl,-rpath,/u01/app/oracle/product/11.2.0/dbhome_1/lib `cat /u01/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -ldl -lm -ln11
mv -f /u01/app/oracle/product/11.2.0/dbhome_1/bin/e2eme /u01/app/oracle/product/11.2.0/dbhome_1/bin/e2eme0
mv /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/e2eme /u01/app/oracle/product/11.2.0/dbhome_1/bin/
make[1]: Leaving directory `/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib'
[oracle@ywdata ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.40
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.40
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2023-05-11_21-27-31PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2023-05-11_21-27-31PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ywdata
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (55) :
Patch 31885230 : applied on Thu May 11 21:25:31 CST 2023
Unique Patch ID: 23831993
Created on 25 Sep 2020, 07:54:35 hrs PST8PDT
Bugs fixed:
31885230, 30387666, 18641461, 25654936, 19972566, 21756677, 25947799
18203837, 17716305, 26667015, 22683212, 21756699, 22195448, 21756661
18641451
Patch 31885223 : applied on Thu May 11 21:25:30 CST 2023
Unique Patch ID: 23831993
Created on 25 Sep 2020, 00:22:02 hrs PST8PDT
Bugs fixed:
31885223
Patch 31885213 : applied on Thu May 11 21:25:25 CST 2023
Unique Patch ID: 23831993
Created on 24 Sep 2020, 09:15:32 hrs PST8PDT
Bugs fixed:
31885213, 31194264, 26667032, 30215130, 26039623, 31022281
Patch 31885201 : applied on Thu May 11 21:25:22 CST 2023
Unique Patch ID: 23831993
Created on 24 Sep 2020, 09:10:49 hrs PST8PDT
Bugs fixed:
31885201, 22468255
Patch 31885190 : applied on Thu May 11 21:25:21 CST 2023
Unique Patch ID: 23831993
Created on 28 Sep 2020, 02:13:46 hrs PST8PDT
Bugs fixed:
31885190, 26318200, 31885162, 13854364, 31885173, 25205368, 30200680
17865671, 18203838
Patch 31885179 : applied on Thu May 11 21:25:20 CST 2023
Unique Patch ID: 23831993
Created on 27 Sep 2020, 22:55:22 hrs PST8PDT
Bugs fixed:
31885179, 25115178, 23536835, 22296366
Patch 31884535 : applied on Thu May 11 21:25:19 CST 2023
Unique Patch ID: 23831993
Created on 27 Sep 2020, 23:07:20 hrs PST8PDT
Bugs fixed:
31884535, 31668061, 21538567, 20441797
Patch 31883489 : applied on Thu May 11 21:25:18 CST 2023
Unique Patch ID: 23831993
Created on 24 Sep 2020, 09:09:21 hrs PST8PDT
Bugs fixed:
31883489, 30578221
Patch 31834759 : applied on Thu May 11 21:25:17 CST 2023
Unique Patch ID: 23831993
Created on 25 Sep 2020, 01:57:59 hrs PST8PDT
Bugs fixed:
31834759, 31338362, 31010960, 30559616, 30237239, 28790634, 28364007
27870645, 26474853, 25879656, 25369547, 24433711, 23177648, 22502493
21972320, 21352646, 20803583, 20299015, 19271443, 18681862, 18139690
17551709, 17343514, 19727057, 19854503
Patch 31492176 : applied on Thu May 11 21:25:15 CST 2023
Unique Patch ID: 23688550
Created on 9 Jul 2020, 05:02:06 hrs UTC
Bugs fixed:
31492176, 30624864
Patch 31492164 : applied on Thu May 11 21:25:14 CST 2023
Unique Patch ID: 23688550
Created on 9 Jul 2020, 05:00:40 hrs UTC
Bugs fixed:
31492164, 31031715
Patch 31492144 : applied on Thu May 11 21:25:13 CST 2023
Unique Patch ID: 23688550
Created on 9 Jul 2020, 05:05:30 hrs UTC
Bugs fixed:
31492144, 31001455
Patch 31022191 : applied on Thu May 11 21:25:11 CST 2023
Unique Patch ID: 23480381
Created on 2 Apr 2020, 05:48:00 hrs PST8PDT
Bugs fixed:
30305880, 31022191
Patch 30562936 : applied on Thu May 11 21:25:10 CST 2023
Unique Patch ID: 23480381
Created on 2 Apr 2020, 04:12:19 hrs PST8PDT
Bugs fixed:
30562936, 29621961
Patch 30562923 : applied on Thu May 11 21:25:09 CST 2023
Unique Patch ID: 23268193
Created on 13 Dec 2019, 11:48:33 hrs PST8PDT
Bugs fixed:
30562923, 29483771
Patch 30562909 : applied on Thu May 11 21:25:08 CST 2023
Unique Patch ID: 23268193
Created on 13 Dec 2019, 11:23:42 hrs PST8PDT
Bugs fixed:
30252098, 30562909
Patch 30562907 : applied on Thu May 11 21:25:07 CST 2023
Unique Patch ID: 23268193
Created on 13 Dec 2019, 11:20:39 hrs PST8PDT
Bugs fixed:
30562907, 29944660
Patch 30562891 : applied on Thu May 11 21:25:06 CST 2023
Unique Patch ID: 23268193
Created on 13 Dec 2019, 12:01:53 hrs PST8PDT
Bugs fixed:
29962939, 30365745, 30562891, 29962927
Patch 30275359 : applied on Thu May 11 21:25:04 CST 2023
Unique Patch ID: 23109964
Created on 11 Sep 2019, 12:03:02 hrs PST8PDT
Bugs fixed:
29483723, 30275359
Patch 30275351 : applied on Thu May 11 21:25:03 CST 2023
Unique Patch ID: 23109964
Created on 11 Sep 2019, 12:02:25 hrs PST8PDT
Bugs fixed:
29483672, 30275351
Patch 29033139 : applied on Thu May 11 21:25:02 CST 2023
Unique Patch ID: 22629113
Created on 14 Dec 2018, 08:50:49 hrs PST8PDT
Bugs fixed:
29033139, 27097854
Patch 28100487 : applied on Thu May 11 21:25:01 CST 2023
Unique Patch ID: 22229821
Created on 31 May 2018, 04:23:25 hrs PST8PDT
Bugs fixed:
27534509, 28100487
Patch 26667023 : applied on Thu May 11 21:24:59 CST 2023
Unique Patch ID: 21673297
Created on 27 Oct 2017, 16:55:11 hrs PST8PDT
Bugs fixed:
20506699, 19358317, 21787056, 19972570, 17655240, 17762296, 24652769
19197175, 26667023, 25489607, 24719736, 23713236, 22195457
Patch 26030218 : applied on Thu May 11 21:24:57 CST 2023
Unique Patch ID: 21282737
Created on 18 May 2017, 10:26:02 hrs PST8PDT
Bugs fixed:
26030218, 25423453
Patch 25505407 : applied on Thu May 11 21:24:56 CST 2023
Unique Patch ID: 21038510
Created on 21 Feb 2017, 10:08:06 hrs PST8PDT
Bugs fixed:
18262334, 25093656, 25505407, 19584068
Patch 25505394 : applied on Thu May 11 21:24:55 CST 2023
Unique Patch ID: 21038510
Created on 10 Feb 2017, 07:48:22 hrs PST8PDT
Bugs fixed:
25505394, 18440095
Patch 25505382 : applied on Thu May 11 21:24:54 CST 2023
Unique Patch ID: 21038510
Created on 10 Feb 2017, 07:47:58 hrs PST8PDT
Bugs fixed:
24411921, 21526048, 22195485, 25505382
Patch 25505371 : applied on Thu May 11 21:24:53 CST 2023
Unique Patch ID: 21038510
Created on 21 Feb 2017, 10:34:29 hrs PST8PDT
Bugs fixed:
25505371, 22905130
Patch 24528741 : applied on Thu May 11 21:24:51 CST 2023
Unique Patch ID: 20562571
Created on 2 Sep 2016, 10:40:57 hrs PST8PDT
Bugs fixed:
20331945, 21051852, 22148226, 24528741
Patch 24476274 : applied on Thu May 11 21:24:50 CST 2023
Unique Patch ID: 20562571
Created on 6 Sep 2016, 11:35:32 hrs PST8PDT
Bugs fixed:
24476274, 6599380
Patch 24476265 : applied on Thu May 11 21:24:49 CST 2023
Unique Patch ID: 20562571
Created on 2 Sep 2016, 11:53:55 hrs PST8PDT
Bugs fixed:
23330119, 24476265, 19049453, 16450169, 22657942, 17786278, 22507210
18744139, 18096714, 20506715, 18061914, 22507234, 19915271, 17006570
17811456, 18554871
Patch 23330124 : applied on Thu May 11 21:24:48 CST 2023
Unique Patch ID: 20326592
Created on 20 Jun 2016, 08:08:50 hrs PST8PDT
Bugs fixed:
22380919, 23330124
Patch 22893153 : applied on Thu May 11 21:24:47 CST 2023
Unique Patch ID: 19947279
Created on 13 Mar 2016, 05:50:29 hrs PST8PDT
Bugs fixed:
19554106, 19458377, 19466309, 22893153, 20296213, 17600719, 20631274
16524926, 18093615
Patch 22683225 : applied on Thu May 11 21:24:45 CST 2023
Unique Patch ID: 19947279
Created on 3 Apr 2016, 19:01:38 hrs PST8PDT
Bugs fixed:
22683225, 20596234
Patch 22321756 : applied on Thu May 11 21:24:43 CST 2023
Unique Patch ID: 19644603
Created on 7 Dec 2015, 07:04:43 hrs PST8PDT
Bugs fixed:
21453153, 22321756
Patch 22321741 : applied on Thu May 11 21:24:42 CST 2023
Unique Patch ID: 19644603
Created on 7 Dec 2015, 06:59:50 hrs PST8PDT
Bugs fixed:
22321741, 21168487
Patch 22195492 : applied on Thu May 11 21:24:41 CST 2023
Unique Patch ID: 19644603
Created on 7 Dec 2015, 10:51:01 hrs PST8PDT
Bugs fixed:
19972569, 22195492, 19006849, 19032867
Patch 22195477 : applied on Thu May 11 21:24:40 CST 2023
Unique Patch ID: 19644603
Created on 7 Dec 2015, 07:09:53 hrs PST8PDT
Bugs fixed:
21351877, 21538485, 22195477, 21343897, 20448824, 21330264, 21343838
21343775
Patch 22195465 : applied on Thu May 11 21:24:39 CST 2023
Unique Patch ID: 19644603
Created on 30 Nov 2015, 08:34:09 hrs PST8PDT
Bugs fixed:
17551063, 22195465
Patch 22195441 : applied on Thu May 11 21:24:38 CST 2023
Unique Patch ID: 19644603
Created on 7 Dec 2015, 08:29:29 hrs PST8PDT
Bugs fixed:
20861693, 22195441
Patch 21538558 : applied on Thu May 11 21:24:33 CST 2023
Unique Patch ID: 19281142
Created on 14 Aug 2015, 11:06:18 hrs PST8PDT
Bugs fixed:
21538558, 20925795
Patch 21179898 : applied on Thu May 11 21:24:31 CST 2023
Unique Patch ID: 18970187
Created on 4 Jun 2015, 11:58:09 hrs PST8PDT
Bugs fixed:
21179898, 19699191
Patch 21051862 : applied on Thu May 11 21:24:30 CST 2023
Unique Patch ID: 18970187
Created on 22 May 2015, 10:38:06 hrs PST8PDT
Bugs fixed:
20004021, 20004087, 21051862
Patch 21051858 : applied on Thu May 11 21:24:17 CST 2023
Unique Patch ID: 18970187
Created on 22 May 2015, 10:37:23 hrs PST8PDT
Bugs fixed:
20334344, 21051858
Patch 21051840 : applied on Thu May 11 21:24:09 CST 2023
Unique Patch ID: 18970187
Created on 22 May 2015, 10:36:14 hrs PST8PDT
Bugs fixed:
20558005, 21051840
Patch 21051833 : applied on Thu May 11 21:24:08 CST 2023
Unique Patch ID: 18970187
Created on 22 May 2015, 11:39:55 hrs PST8PDT
Bugs fixed:
21051833, 20657441
Patch 20142975 : applied on Thu May 11 21:24:07 CST 2023
Unique Patch ID: 18406185
Created on 22 Dec 2014, 00:47:05 hrs PST8PDT
Bugs fixed:
19827973, 19463897, 19289642, 20142975
Patch 19972568 : applied on Thu May 11 21:24:06 CST 2023
Unique Patch ID: 18406185
Created on 22 Dec 2014, 00:13:36 hrs PST8PDT
Bugs fixed:
19972568, 19309466
Patch 19972564 : applied on Thu May 11 21:24:05 CST 2023
Unique Patch ID: 18406185
Created on 21 Dec 2014, 23:54:58 hrs PST8PDT
Bugs fixed:
19972564, 18436647
Patch 19544839 : applied on Thu May 11 21:24:04 CST 2023
Unique Patch ID: 18084194
Created on 11 Oct 2014, 01:43:34 hrs PST8PDT
Bugs fixed:
18673325, 19544839, 19211724, 18673304
Patch 19463893 : applied on Thu May 11 21:23:56 CST 2023
Unique Patch ID: 18084194
Created on 24 Sep 2014, 06:28:06 hrs PST8PDT
Bugs fixed:
19463893, 18641419
Patch 18203835 : applied on Thu May 11 21:23:54 CST 2023
Unique Patch ID: 17351342
Created on 26 Feb 2014, 23:43:04 hrs PST8PDT
Bugs fixed:
17721717, 18203835
Patch 17811447 : applied on Thu May 11 21:23:53 CST 2023
Unique Patch ID: 17066906
Created on 11 Dec 2013, 02:20:51 hrs PST8PDT
Bugs fixed:
17811447, 17088068
Patch 17811438 : applied on Thu May 11 21:23:52 CST 2023
Unique Patch ID: 17066906
Created on 11 Dec 2013, 02:37:11 hrs PST8PDT
Bugs fixed:
17811438, 16721594
Patch 17811429 : applied on Thu May 11 21:23:51 CST 2023
Unique Patch ID: 17066906
Created on 11 Dec 2013, 02:36:54 hrs PST8PDT
Bugs fixed:
17811429, 13944971
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@ywdata ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch lspatches
31885230;
31885223;
31885213;
31885201;
31885190;
31885179;
31884535;
31883489;
31834759;
31492176;
31492164;
31492144;
31022191;
30562936;
30562923;
30562909;
30562907;
30562891;
30275359;
30275351;
29033139;
28100487;
26667023;
26030218;
25505407;
25505394;
25505382;
25505371;
24528741;
24476274;
24476265;
23330124;
22893153;
22683225;
22321756;
22321741;
22195492;
22195477;
22195465;
22195441;
21538558;
21179898;
21051862;
21051858;
21051840;
21051833;
20142975;
19972568;
19972564;
19544839;
19463893;
18203835;
17811447;
17811438;
17811429;
OPatch succeeded.
打完补丁会出现
ins_emagent.mk:113: warning: overriding recipe for target nmosudo' ins_emagent.mk:52: warning: ignoring old recipe for target
nmosudo’告警,readme中有指引,参考我的另一篇博客的处理方法:https://mp.csdn.net/mp_blog/creation/success/130631835
- 启动数据库
[oracle@ywdata ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu May 11 21:28:38 2023
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2.1379E+10 bytes
Fixed Size 2262656 bytes
Variable Size 4160752000 bytes
Database Buffers 1.7113E+10 bytes
Redo Buffers 103182336 bytes
Database mounted.
Database opened.
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
YWDATA READ WRITE PRIMARY
- 刷数据字典
SQL> @?/rdbms/admin/catbundle.sql cpu apply
...
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> ALTER SESSION SET current_schema = SYS;
Session altered.
SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
2 (action_time, action,
3 namespace, version, id,
4 bundle_series, comments)
5 VALUES
6 (SYSTIMESTAMP, 'APPLY',
7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
8 '11.2.0.4',
9 201020,
10 'CPU',
11 'CPUOCT2020');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_CPU_YWDATA_APPLY_2023May11_21_31_06.log
数据字典刷完,会有日志记录,需要检查日志,有没有报错和告警等。
- 编译失效对象
SQL> @?/rdbms/admin/utlrp.sql
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2023-05-11 21:32:25
1 row selected.
DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time is proportional to the
DOC> number of invalid objects in the database, so this command may take
DOC> a long time to execute on a database with a large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track recompilation progress:
DOC>
DOC> 1. Query returning the number of invalid objects remaining. This
DOC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or parallel recompilation
DOC> based on the number of CPUs available (parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC> recompilation. Jobs are created without instance affinity so that they
DOC> can migrate across RAC nodes. Use the following queries to verify
DOC> whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC> 1. Query showing jobs created by UTL_RECOMP
DOC> SELECT job_name FROM dba_scheduler_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC> 2. Query showing UTL_RECOMP jobs that are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
PL/SQL procedure successfully completed.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2023-05-11 21:33:12
1 row selected.
DOC> The following query reports the number of objects that have compiled
DOC> with errors.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
OBJECTS WITH ERRORS
-------------------
0
1 row selected.
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#
ERRORS DURING RECOMPILATION
---------------------------
0
1 row selected.
Function created.
PL/SQL procedure successfully completed.
Function dropped.
PL/SQL procedure successfully completed.
- 启动监听
[oracle@ywdata ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 11-MAY-2023 21:28:23
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/ywdata/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ywdata)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=ywdata)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 11-MAY-2023 21:28:23
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/ywdata/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ywdata)(PORT=1521)))
Services Summary...
Service "ywdata" has 1 instance(s).
Instance "ywdata", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
至此,补丁安装完成!