Oracle升级2020年4月份的数据库补丁Database Patch Set Update
程序员文章站
2022-06-26 13:50:28
最近有朋友想看打Oracle补丁，今天，她来了！尝试用原始的OPatch：[oracle@localhost db_1]$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tmp/30670774Oracle Interim Patch Installer version 11.2.0.3.4Copyright (c) 2012, Oracle Corporation. All rights reserved.Orac...
最近有朋友想看升级Oracle补丁，今天，她来了！
（文末有你想要的~~~）
尝试用原始的OPatch：
[oracle@localhost db_1]$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tmp/30670774
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-07-17_21-10-50PM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckMinimumOPatchVersion" failed.
The details are:
The OPatch being used has version 11.2.0.3.4 while the following patch(es) require higher versions:
Patch 17478514 requires OPatch version 11.2.0.3.5.
Patch 18031668 requires OPatch version 11.2.0.3.5.
Patch 18522509 requires OPatch version 11.2.0.3.5.
Patch 19121551 requires OPatch version 11.2.0.3.5.
Patch 19769489 requires OPatch version 11.2.0.3.5.
Patch 20299013 requires OPatch version 11.2.0.3.5.
Patch 20760982 requires OPatch version 11.2.0.3.5.
Patch 21352635 requires OPatch version 11.2.0.3.5.
Patch 21948347 requires OPatch version 11.2.0.3.5.
Patch 22502456 requires OPatch version 11.2.0.3.5.
Patch 23054359 requires OPatch version 11.2.0.3.5.
Patch 24006111 requires OPatch version 11.2.0.3.5.
Patch 24732075 requires OPatch version 11.2.0.3.5.
Patch 25869727 requires OPatch version 11.2.0.3.5.
Patch 26392168 requires OPatch version 11.2.0.3.5.
Patch 26609445 requires OPatch version 11.2.0.3.5.
Patch 29141056 requires OPatch version 11.2.0.3.20.
Patch 29497421 requires OPatch version 11.2.0.3.20.
Patch 29913194 requires OPatch version 11.2.0.3.20.
Please download latest OPatch from My Oracle Support.
UtilSession failed: Prerequisite check "CheckMinimumOPatchVersion" failed.
Log file location: /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-07-17_21-10-50PM_1.log
OPatch failed with error code 73
这个官方已有说明：OPatch的版本要大于或等于11.2.0.3.20
You must use the OPatch utility version 11.2.0.3.20 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2, which is available for download from My Oracle Support patch 6880880 by selecting the 11.2.0.0.0 release.
For information about OPatch documentation, including any known issues, see My Oracle Support Document 293369.1 Master Note For OPatch.
但也不能太高：
[oracle@localhost db_1]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/30670774 -oh $ORACLE_HOME
OPatch Version : 12.2.0.1.21
OUI Version : 11.2.0.4.0
The OPatch version is not applicable for current OUI version.
Since OUI Version starts with 11.2, Please go to 'My Oracle Support' and get right OPatch 11.2.*.*.* based on patch 6880880, release version 11.2.0.0.0 and appropriate platform.
OPatch failed with error code 19
[oracle@localhost db_1]$
[oracle@localhost db_1]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.21
OPatch succeeded.
[oracle@localhost db_1]$
空间不够：
[oracle@localhost db_1]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/30670774/ -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.23
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-07-17_21-16-15PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@localhost db_1]$
[oracle@localhost db_1]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.23
OPatch succeeded.
[oracle@localhost db_1]$
[oracle@localhost db_1]$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tmp/30670774
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.23
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-07-17_21-16-40PM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckSystemSpace" failed.
The details are:
Required amount of space(1849.53MB) is not available.
UtilSession failed:
Prerequisite check "CheckSystemSpace" failed.
Log file location: /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-07-17_21-16-40PM_1.log
OPatch failed with error code 73
开始打补丁：
[oracle@localhost ~]$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tmp/30670774
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.23
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-07-17_21-31-58PM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following active executables are not used by opatch process :
/u01/app/oracle/product/11.2.0.4/db_1/bin/oracle
Following active executables are used by opatch process :
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-07-17_21-31-58PM_1.log
OPatch failed with error code 73
[oracle@localhost ~]$
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 17 21:32:15 2020
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> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
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@localhost ~]$
[oracle@localhost ~]$
[oracle@localhost ~]$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tmp/30670774
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.23
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-07-17_21-32-32PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075 25869727 26609445 26392168 26925576 27338049 27734982 28204707 28729262 29141056 29497421 29913194 30298532 30670774
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.4/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sdo, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.sdo.locator, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.crs, 11.2.0.4.0...
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 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.ordim.client, 11.2.0.4.0...
Patching component oracle.ordim.jai, 11.2.0.4.0...
Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.ovm, 11.2.0.4.0...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms.util, 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.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.oraolap, 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.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.rdbms.dv, 11.2.0.4.0...
Patching component oracle.rdbms.oci, 11.2.0.4.0...
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.sysman.common, 10.2.0.4.5...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sysman.common.core, 10.2.0.4.5...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.sysman.console.db, 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.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.ovm, 11.2.0.4.0...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sysman.oms.core, 10.2.0.4.5...
Applying sub-patch '22502456' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.oraolap.dbscripts, 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.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 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 sub-patch '23054359' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.rdbms.dv, 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.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '24006111' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.sqlplus.ic, 11.2.0.4.0...
Patching component oracle.sqlplus, 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.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...
Patching component oracle.sqlplus.ic, 11.2.0.4.0...
Patching component oracle.sqlplus, 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.rdbms.util, 11.2.0.4.0...
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 sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 11.2.0.4.0...
Patching component oracle.ldap.client, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.network.listener, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '27338049' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.assistants.server, 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.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '27734982' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.ctx, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.ctx.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '28204707' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Applying changes to emctl script on the home: /u01/app/oracle/product/11.2.0.4/db_1 ...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
Patching component oracle.network.rsf, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.ldap.security.osdt, 11.2.0.4.0...
Patching component oracle.ldap.owm, 11.2.0.4.0...
Patching component oracle.sqlplus.rsf, 11.2.0.4.0...
Patching component oracle.ctx, 11.2.0.4.0...
Applying sub-patch '28729262' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
INFO: Script isn't applicable to this port!
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.util, 11.2.0.4.0...
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
Patching component oracle.network.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.ctx, 11.2.0.4.0...
Applying sub-patch '29141056' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '29497421' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.ctx, 11.2.0.4.0...
Applying sub-patch '29913194' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.network.rsf, 11.2.0.4.0...
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.util, 11.2.0.4.0...
Applying sub-patch '30298532' to OH '/u01/app/oracle/product/11.2.0.4/db_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.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
Applying sub-patch '30670774' to OH '/u01/app/oracle/product/11.2.0.4/db_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...
Patching component oracle.network.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
Patching component oracle.swd.oui, 11.2.0.4.0...
Patching component oracle.ctx, 11.2.0.4.0...
OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
chmod: changing permissions of `/u01/app/oracle/product/11.2.0.4/db_1/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)
Composite patch 30670774 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-07-17_21-32-32PM_1.log
OPatch completed with warnings.
[oracle@localhost ~]$
升级完检查：
[oracle@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.23
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-07-17_21-38-55PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-07-17_21-38-55PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost
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 (1) :
Patch 30670774 : applied on Fri Jul 17 21:36:42 CST 2020
Unique Patch ID: 23449206
Patch description: "Database Patch Set Update : 11.2.0.4.200414 (30670774)"
Created on 20 Mar 2020, 00:05:18 hrs PST8PDT
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)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
18619917, 19309466, 28876684, 28855981, 18189036, 19781326, 13609098
16285691, 16756406, 18430495, 17323222, 29483723, 19915271, 19516448
14458214, 23713236, 23140259, 29434301, 22502493, 18272672, 16410570
16494615, 19174430, 21352646, 16901385, 16596890, 22243719, 18996843
21387964, 20334344, 17174582, 22250006, 17798953, 14015842, 18031668
15955387, 21534893, 16832076, 16065166, 16579084, 25427662, 21179898
11786053, 15990359, 24589081, 17982832, 18685892, 20142975, 24835538
16315398, 20861693, 17037130, 17284817, 17891946, 17279227, 17588480
17291347, 16731148, 21097043, 24528741, 22321741, 17165204, 26245237
17891943, 17359610, 17265217, 17465741, 29621961, 22551446, 18191164
16721594, 18614015, 27825893, 18440095, 19769489, 20596234, 18482502
16043574, 17360606, 20936905, 22321756, 19211724, 17392698, 19463893
29033139, 17477958, 17040764, 18362222, 19463897, 24624166, 17853456
14521849, 17816865, 19692824, 21868720, 17951233, 25505407, 17040527
31022191, 24975421, 19888853, 18009564, 20882568, 20803583, 23026585
18604692, 17622427, 16903536, 29483771, 17865671, 17883081, 16228604
17325413, 17082359, 12747740, 22168163, 16091637, 20569094, 17468141
30365745, 29962939, 19469538, 29633753, 20598042, 16042673, 23302839
17437634, 28734355, 19049453, 20387265, 16941434, 16833527, 21343775
17297939, 16069901, 14285317, 22380919, 18436647, 23065323, 21983325
17853498, 24790914, 23571055, 16542886, 21286665, 17365043, 17752995
25914276, 17296856, 18783224, 22353199, 22083366, 28305362, 21419850
16180763, 23294548, 26679352, 13960236, 25328093, 25423453, 18339044
17282229, 25600421, 18856999, 18259031, 28806384, 21354456, 23725036
18471685, 30237239, 17258090, 16344544, 17903598, 17011832, 18135678
18704244, 17786518, 19718981, 25655390, 17242746, 20250147, 19197175
17390431, 17835627, 17672719, 17393915, 21566639, 18765602, 21425496
26544823, 22228324, 29962927, 18682983, 30179644, 25165496, 12816846
18774543, 18747196, 17824637, 19429927, 21429602, 16524926, 17343514
19271443, 17019345, 18681862, 17186905, 23330119, 17811438, 26474853
17215560, 16875449, 21380789, 17184721, 18508861, 19466309, 23330124
17811429, 17019356, 25654936, 17754782, 17752121, 22809871, 17201159
18308268, 19777862, 16198143, 29027694, 18828868, 17586955, 28076295
26654363, 22977256, 16692232, 27374796, 21142837, 20869721, 17649265
25879656, 17847764, 21756699, 19697993, 28364007, 17787259, 23628685
30252098, 23007241, 27351628, 18094246, 20031873, 17375354, 21698350
26513067, 21538567, 22683212, 16450169, 17478145, 17311728, 17648596
17308789, 22836801, 21756677, 18674047, 14084247, 19788303, 22683225
27534509, 16833845, 18948177, 17205719, 21756661, 20004021, 17922254
13837378, 18084625, 17912217, 11883252, 24842886, 12982566, 26203182
14176370, 14764829, 21847223, 16875230, 28079127, 22568797, 17237521
29511611, 25635149, 16934803, 17848897, 20441797, 20175161, 16613964
18334586, 17288409, 17341326, 17449815, 15913355, 16399083, 18740837
20294666, 14565184, 21517440, 17614134, 19854503, 14245531, 16194160
18325460, 15979965, 30562923, 20671094, 27870645, 25093656, 18247991
16912439, 30562936, 24433711, 19930276, 22092979, 20506715, 23003979
20506706, 13871092, 19272701, 17397545, 16785708, 19461270, 21051862
13829543, 16220077, 17008068, 18061914, 20448824, 30275359, 18674024
19689979, 24411921, 30275351, 17596908, 17036973, 22175564, 17612828
20725343, 28199085, 23194294, 17630484, 21051858, 20017509, 21051852
17767676, 17232014, 22893153, 12611721, 25555252, 18356166, 17071721
19315668, 25764020, 16863422, 21051840, 17267114, 17820741, 18043064
21538558, 26243698, 20324049, 30305880, 16392068, 18744139, 24348685
26746894, 18628388, 27072923, 14010183, 16595641, 17080436, 17332800
20777150, 21453153, 20299015, 18413820, 18264060, 16819962, 22465352
21351877, 21051833, 18673342, 30562907, 30562909, 29200700, 27441326
16571443, 18328509, 27567477, 18674465, 16422541, 18306996, 19359219
21424824, 17443671, 17478514, 21067387, 16268425, 17381384, 18723434
17235750, 23328639, 22195448, 24570598, 21172913, 17655240, 18384391
16992075, 22195441, 17025461, 30562891, 16472716, 19289642, 21502702
22195457, 20475845, 22148226, 26030218, 18331850, 17945983, 13498382
24652769, 18673304, 17610798, 19891090, 25369547, 18456514, 8322815
22657942, 17313525, 17050888, 18317531, 19835133, 17495022, 11733603
18798250, 19285025, 18260550, 17390160, 18316692, 19458377, 14368995
17551063, 21343838, 12905058, 14735792, 28612674, 16855292, 23315889
13364795, 18235390, 18293054, 18673325, 19393542, 30215130, 14657740
17532729, 17393683, 17389192, 17783588, 17852463, 19358317, 17441661
14034426, 28254374, 20631274, 19207117, 26569225, 17518652, 24662775
19475971, 18282562, 19896336, 17348614, 19827973, 17346671, 31022281
19791273, 24476274, 22296366, 13853126, 18273830, 17570606, 13558557
26007010, 16685417, 18180390, 14692762, 18159793, 17027426, 24476265
23177648, 17851160, 16870214, 18202441, 17227073, 20657411, 19006849
22606521, 20506699, 28000269, 23536835, 17761775, 20382309, 16306373
17801017, 19680952, 16850630, 17694209, 26667015, 17877323, 18230522
24563422, 17446237, 17889549, 17551674, 16233738, 22730454, 17571039
26667023, 19972570, 18849970, 21532755, 20860659, 22905130, 21168487
17016369, 21263635, 17231779, 21343897, 17717883, 27710072, 18522509
23209741, 17484731, 21972320, 19972569, 19972568, 17716305, 21059919
19972566, 19972564, 26667032, 17394950, 20657441, 17551699, 17006570
18051556, 12364061, 18029658, 17546973, 18262334, 19699191, 17227277
18018515, 16943711, 17982555, 20828947, 18098207, 18436307, 19584068
16898135, 13936038, 19601762, 31010960, 14054676, 25505394, 18228645
19013183, 25042823, 17721717, 17239687, 25248384, 25634317, 20134113
20273319, 28501075, 21063322, 17344412, 22507210, 16354467, 21795111
25505371, 16777840, 25879984, 17811456, 19730508, 17385178, 18166013
17484762, 10136473, 6599380, 20717359, 20296213, 27097854, 13955826
18193833, 17545847, 16837842, 18964939, 19871910, 25505382, 17811447
18554763, 21132297, 25957038, 20004087, 17889583, 19544839, 26631046
22507234, 24719736, 18868646, 17042658, 20627866, 14106803, 13951456
18139690, 18277454, 13680635, 25823754, 18554871, 18515268, 20169408
24908321, 17274537, 17602269, 26575788, 19032867, 17762296, 14829250
16929165, 14602788, 28849751, 21794615, 18899974, 29944660, 18441944
17811789, 20074391, 14852021, 17705023, 13645875, 24316947, 16668584
17786278, 25947799, 20879889, 19578350, 28022101, 22594718, 16384983
26439748, 17957017, 19121551, 17570240, 19788842, 18382302, 27086138
21330264, 21197626, 14338435, 13944971, 21656630, 18886413, 17156148
17936109, 20509482, 27255377, 24717859, 18762750, 21526048, 24560906
18096714, 17238511, 26078387, 27053456, 20144308, 25364628, 18244962
19433930, 20476175, 19297917, 21174504, 18280813, 28819280, 17614227
28357401, 21911701, 17006183, 25809524, 18092127, 19727057, 17695685
26039623, 22820579, 20856766, 15861775, 17258582, 21668627, 19487147
20925795, 28100487, 26482376, 19554106, 22760679, 21629064, 18199537
18091059, 17299889, 21538485, 17546761, 26336977, 25775213, 18155762
30803210, 16956380, 19207156, 14705949, 23105538, 26198926, 19258504
16314254, 17246576, 17655634, 17890099, 16989630, 20067212, 19721304
25077278, 19490948, 18203835, 18203838, 18973907, 18203837, 29483672
19615136, 17587063, 18000422, 18641451, 18090142, 21641760, 17019086
30559616, 19373893, 18373438, 21820934, 18641461, 17346091, 21422580
22351572, 18604493, 23008056, 22901797, 18610915, 17892268, 17501491
20907061, 14354737, 17835048, 21787056, 22195485, 22782647, 17082983
18641419, 16618694, 14133975, 22195492, 18331812, 18093615, 24385983
25897615, 20513399, 21281607, 13866822, 18841764, 17600719, 17842825
20558005, 17088068, 9756271, 22195465, 18440047, 19211433, 21515534
20331945, 22686674, 18384537, 18607546, 17254374, 18315328, 23115139
28790634, 21394225, 16360112, 22195477, 17726838, 18510194, 17571306
24766121, 17302277, 21842740, 17551709, 26910644, 17634921, 25489607
16538760
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@localhost ~]$
升级数据字典：
-- 先检查
set linesize 200
col action_time format a30
col COMMENTS format a20
select * from dba_registry_history;
SQL> select * from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------ --------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
15-NOV-17 10.42.23.468173 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
2 rows selected.
SQL> @?/rdbms/admin/catbundle.sql psu apply
-- 再次检查
SQL> select * from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------ --------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
15-NOV-17 10.42.23.468173 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
17-JUL-20 10.04.53.432953 PM APPLY SERVER 11.2.0.4 200414 PSU PSU 11.2.0.4.200414
3 rows selected.
安全传送门：https://download.csdn.net/download/u013012406/12624417
本文地址：https://blog.csdn.net/u013012406/article/details/107417337