什么是OJVM PSU?
CPU: Critical Patch Update Oracle对于其产品每个季度发行一次的安全补丁包,通常是为了修复产品中的安全隐患。
PSU: Patch Set Updates Oracle对于其产品每个季度发行一次的补丁包,包含了bug的修复。
Oracle选取被用户下载数量多的,并且被验证过具有较低风险的补丁放入到每个季度的PSU中。
在每个PSU中不但包含Bug的修复而且还包含了最新的CPU。
OJVM PSU主要是针对oracle java VM 从2014年10月开始Oracle Java VM组件作为一个单独的部分来进行安装。
之前是包含在oracle rdbms psu中。
只要oracle db中安装jvm组件,就需要安装对应版本的oracle JavaVM PSU。
如果只是打了rdbms的PSU,安全漏洞检查就会检查出jvm的安全漏洞。
“Oracle JavaVM Component Database PSU” (OJVM PSU) Patches (文档 ID 1929745.1 ) 单实例安装
上传并解压补丁包
[oracle@oracle ~]$ ls p31668908_112040_Linux-x86-64.zip
p31668908_112040_Linux-x86-64.zip
[oracle@oracle ~]$ pwd
/home/oracle
[oracle@oracle ~]$ ll 31668908
total 56
drwxr-x--- 3 oracle oinstall 20 Sep 8 2020 etc
drwxr-x--- 9 oracle oinstall 96 Sep 8 2020 files
-rw-rw-r-- 1 oracle oinstall 51108 Oct 19 16:08 README.html
-rw-r--r-- 1 oracle oinstall 21 Sep 8 2020 README.txt
验证与当前环境是否有冲突
[oracle@oracle ~]$ cd 31668908
[oracle@oracle 31668908]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2021, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /opt/oracle/product/11.2.0/dbhome_1
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.25
OUI version : 11.2.0.4.0
Log file location : /opt/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2021-03-31_16-56-46PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
停库停监听
SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
[oracle@oracle 31668908]$ lsnrctl stop
安装
[oracle@oracle 31668908]$ $ORACLE_HOME/OPatch/opatch napply -local /home/oracle/31668908/ -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/product/11.2.0/dbhome_1
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.25
OUI version : 11.2.0.4.0
Log file location : /opt/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2021-03-31_17-02-01PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 31668908
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 = '/opt/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 '31668908' to OH '/opt/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.javavm.server, 11.2.0.4.0...
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.javavm.client, 11.2.0.4.0...
Patching component oracle.dbjava.jdbc, 11.2.0.4.0...
Patching component oracle.dbjava.ic, 11.2.0.4.0...
Patch 31668908 successfully applied.
Log file location: /opt/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2021-03-31_17-02-01PM_1.log
OPatch succeeded.
[oracle@oracle 31668908]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/product/11.2.0/dbhome_1
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.25
OUI version : 11.2.0.4.0
Log file location : /opt/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2021-03-31_17-11-06PM_1.log
Lsinventory Output file location : /opt/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2021-03-31_17-11-06PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oracle.node.com
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 (2) :
Patch 31668908 : applied on Wed Mar 31 17:02:23 CST 2021
Unique Patch ID: 23800881
Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.201020"
Created on 8 Sep 2020, 03:18:03 hrs PST8PDT
Bugs fixed:
23727132, 19554117, 19006757, 14774730, 18933818, 18458318, 18166577
19231857, 19153980, 19058059, 19007266, 17285560, 17201047, 17056813
19223010, 19852360, 19909862, 19895326, 19374518, 20408829, 21047766
21566944, 19176885, 17804361, 17528315, 21811517, 22253904, 19187988
21911849, 22118835, 22670385, 23265914, 22675136, 24448240, 25067795
24534298, 25076732, 25494379, 26023002, 19699946, 26637592, 27000663
25649873, 27461842, 27952577, 27642235, 28502128, 28915933, 29254615
29774367, 29992392, 29448234, 30160639, 30534664, 30855121, 31306274
30772207, 31476032, 30561292, 28394726, 26716835, 24817447, 23082876
31668867
Patch 31537677 : applied on Mon Mar 29 17:52:08 CST 2021
Unique Patch ID: 23828543
Patch description: "Database Patch Set Update : 11.2.0.4.201020 (31537677)"
Created on 24 Sep 2020, 06:02:11 hrs PST8PDT
Sub-patch 31103343; "Database Patch Set Update : 11.2.0.4.200714 (31103343)"
Sub-patch 30670774; "Database Patch Set Update : 11.2.0.4.200414 (30670774)"
Sub-patch 30298532; "Database Patch Set Update : 11.2.0.4.200114 (30298532)"
Sub-patch 29913194; "Database Patch Set Update : 11.2.0.4.191015 (29913194)"
Sub-patch 29497421; "Database Patch Set Update : 11.2.0.4.190716 (29497421)"
Sub-patch 29141056; "Database Patch Set Update : 11.2.0.4.190416 (29141056)"
Sub-patch 28729262; "Database Patch Set Update : 11.2.0.4.190115 (28729262)"
Sub-patch 28204707; "Database Patch Set Update : 11.2.0.4.181016 (28204707)"
Sub-patch 27734982; "Database Patch Set Update : 11.2.0.4.180717 (27734982)"
Sub-patch 27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"
Sub-patch 26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"
Sub-patch 26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
Sub-patch 26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
Sub-patch 25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
Sub-patch 24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
