Oracle 11.2.0.4安装SPU

最新推荐文章于 2023-11-29 23:23:49 发布

挠背小能手

最新推荐文章于 2023-11-29 23:23:49 发布

阅读量728

点赞数

分类专栏： Oracle日常运维文章标签： oracle 数据库服务器

本文链接：https://blog.csdn.net/m0_37625564/article/details/130631594

版权

Oracle日常运维专栏收录该内容

129 篇文章 16 订阅

订阅专栏

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

至此，补丁安装完成！