| Oracle 11.2.0.4安装SPU | 您所在的位置：网站首页 › 国产鞋子有什么品牌 › Oracle 11.2.0.4安装SPU |
Oracle 11.2.0.4安装SPU
|
Oracle 11.2.0.4单机数据库，由于漏扫出现较多CVE等漏洞，需要安装SPU补丁。由于Oracle 11.2.0.4停止支持，能下载到的最后补丁是2020年10月的补丁：SPU 31834759 不赘述，解压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至此，补丁安装完成！ |
参考补丁中的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、启动监听 以下为实际的安装补丁步骤：【本文地址】
公司简介
联系我们