接着上一篇文章讲,Oracle已经升级到11.2.0.4,上一篇对软件和数据库都进行了升级
但是11.2.0.4也有很多补丁需要安装
如何查找最新的Oracle psu补丁,需要拥有一个mos账号
在里面搜索ID号 2118136.2
然后根据我们的数据库版本进行选择
31537677 这个是我们最新psu补丁
31668908为ojvm最新补丁(主要对java漏洞进行补丁,安全不会扫描出来)
Opatch补丁包我们选择p6880880_112000_Linux-x86-64.zip
为什么要选用最新的Opatch(因为补丁包有要求,不然会报错,要求的最低版本Opatch是什么这个在补丁安装包README.html有要求写的很清楚
You must use the OPatch utility version 11.2.0.3.23 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.
最新Opatch补丁搜索Patch Number : 6880880 选择操作系统如下图
点击search得到
然后下载下来解压替换原来的Opatch
原来的
[oracle@qa-spydb software11G]$ /u01/oracle/product/11.2.0/OPatchbk/opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
现在
[oracle@qa-spydb software11G]$ /u01/oracle/product/11.2.0/OPatch/opatch version
OPatch Version: 11.2.0.3.33
OPatch succeeded.
关闭数据库和监听,对数据库11.2.0.4软件进行升级
先做个冲突检测
[oracle@qa-spydb 31537677]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle 临时补丁程序安装程序版本 11.2.0.3.33
版权所有 (c) 2022, Oracle Corporation。保留所有权利。
PREREQ session
Oracle 主目录 :/u01/oracle/product/11.2.0
主产品清单:/u01/oracle/oraInventory
来自 :/u01/oracle/product/11.2.0/oraInst.loc
OPatch 版本 :11.2.0.3.33
OUI 版本 :11.2.0.4.0
日志文件位置:/u01/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2022-03-02_17-17-51下午_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
先psu升级
关于opatch升级方法原来使用$ORACLE_HOME/OPatch/ocm/bin/emocmrsp这种方案
新的Opatch版本中bin目录下已经没有内容了
mos上有了新的升级方案ID:2161861.1
[oracle@qa-spydb software11G]$ $ORACLE_HOME/OPatch/opatch apply -silent 31537677/
Oracle 临时补丁程序安装程序版本 11.2.0.3.33
版权所有 (c) 2022, Oracle Corporation。保留所有权利。
Oracle 主目录 :/u01/oracle/product/11.2.0
主产品清单:/u01/oracle/oraInventory
来自 :/u01/oracle/product/11.2.0/oraInst.loc
OPatch 版本 :11.2.0.3.33
OUI 版本 :11.2.0.4.0
日志文件位置:/u01/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2022-03-02_17-21-11下午_1.log
Verifying environment and performing prerequisite checks...
9913194 30298532 30670774 31103343 31537677
是否继续? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。
(Oracle 主目录 = '/u01/oracle/product/11.2.0')
本地系统是否已准备打补丁? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.sdo, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁...
正在为组件 oracle.xdk, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.sdo.locator, 11.2.0.4.0 打补丁...
正在为组件 oracle.nlsrtl.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
Applying sub-patch '18031668' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.crs, 11.2.0.4.0 打补丁...
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
Applying sub-patch '18522509' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁...
Applying sub-patch '19121551' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.ordim.client, 11.2.0.4.0 打补丁...
正在为组件 oracle.ordim.jai, 11.2.0.4.0 打补丁...
Applying sub-patch '19769489' to OH '/u01/oracle/product/11.2.0'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.sysman.agent, 11.2.0.4.0 ] , 或找到更高版本。
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.ovm, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.util, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.parser.java, 11.2.0.4.0 打补丁...
正在为组件 oracle.oraolap, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁...
Applying sub-patch '20299013' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms.dv, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.oci, 11.2.0.4.0 打补丁...
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁...
正在为组件 oracle.xdk, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.common, 10.2.0.4.5 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.parser.java, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.common.core, 10.2.0.4.5 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁...
Applying sub-patch '20760982' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
Applying sub-patch '21352635' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
Applying sub-patch '21948347' to OH '/u01/oracle/product/11.2.0'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.tfa, 11.2.0.4.0 ] , 或找到更高版本。
正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁...
正在为组件 oracle.ovm, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.nlsrtl.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.parser.java, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.oms.core, 10.2.0.4.5 打补丁...
Applying sub-patch '22502456' to OH '/u01/oracle/product/11.2.0'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.tfa, 11.2.0.4.0 ] , 或找到更高版本。
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.oraolap.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.olap, 11.2.0.4.0 打补丁...
正在为组件 oracle.oraolap, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
Applying sub-patch '23054359' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms.dv, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
Applying sub-patch '24006111' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.sqlplus.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.sqlplus, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
Applying sub-patch '24732075' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.plugin.db.main.agent, 11.2.0.4.0 打补丁...
正在为组件 oracle.sqlplus.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.sqlplus, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.util, 11.2.0.4.0 打补丁...
正在为组件 oracle.ordim.client, 11.2.0.4.0 打补丁...
正在为组件 oracle.ordim.jai, 11.2.0.4.0 打补丁...
正在为组件 oracle.ordim.server, 11.2.0.4.0 打补丁...
Applying sub-patch '25869727' to OH '/u01/oracle/product/11.2.0'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.oid.client, 11.2.0.4.0 ] , 或找到更高版本。
正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.oracore.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
Applying sub-patch '26609445' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.oracore.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
Applying sub-patch '26392168' to OH '/u01/oracle/product/11.2.0'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.oid.client, 11.2.0.4.0 ] , 或找到更高版本。
正在为组件 oracle.network.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.client, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁...
正在为组件 oracle.xdk, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.network.listener, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.nlsrtl.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.parser.java, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
Applying sub-patch '26925576' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
Applying sub-patch '27338049' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.assistants.server, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
Applying sub-patch '27734982' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.ctx, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ctx.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
Applying sub-patch '28204707' to OH '/u01/oracle/product/11.2.0'
Applying changes to emctl script on the home: /u01/oracle/product/11.2.0 ...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.oracore.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.network.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁...
正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.security.osdt, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.owm, 11.2.0.4.0 打补丁...
正在为组件 oracle.sqlplus.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ctx, 11.2.0.4.0 打补丁...
Applying sub-patch '28729262' to OH '/u01/oracle/product/11.2.0'
INFO: Script isn't applicable to this port!
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.util, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.network.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.ctx, 11.2.0.4.0 打补丁...
Applying sub-patch '29141056' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.oracore.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
Applying sub-patch '29497421' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.oracore.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ctx, 11.2.0.4.0 打补丁...
Applying sub-patch '29913194' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.network.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.util, 11.2.0.4.0 打补丁...
Applying sub-patch '30298532' to OH '/u01/oracle/product/11.2.0'
ApplySession: Oracle 主目录中不存在可选组件 [ 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 ] , 或找到更高版本。
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.hsodbc, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.4.0 打补丁...
Applying sub-patch '30670774' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.network.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.swd.oui, 11.2.0.4.0 打补丁...
正在为组件 oracle.ctx, 11.2.0.4.0 打补丁...
Applying sub-patch '31103343' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
Applying sub-patch '31537677' to OH '/u01/oracle/product/11.2.0'
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dv, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.oracore.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.util, 11.2.0.4.0 打补丁...
正在为组件 oracle.dbdev, 11.2.0.4.0 打补丁...
正在为组件 oracle.ctx, 11.2.0.4.0 打补丁...
正在为组件 oracle.buildtools.rsf, 11.2.0.4.0 打补丁...
Composite patch 31537677 successfully applied.
Log file location: /u01/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2022-03-02_17-21-11下午_1.log
OPatch succeeded.
此时查看补丁升级情况
[oracle@qa-spydb software11G]$ $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep 'PSU|PATCH SET UPDATE'
CERTS ON TOKENS AFTER OCT 18 PSU
28806384 28729262 Wed Mar 02 17:23:33 CST 2022 OCTOBER 2018 PSU BREAKS FIPS 140-1 STANDARD
11.2.0.4.181016GIPSU AS PER BUG 28818855
OF 18121298 IS APPLIED ON PSU 11.2.0.4.181016
17518652 28204707 Wed Mar 02 17:23:28 CST 2022 REMOVE OLD RSA BUILD IN 11.2.0.4 PSU BRANCH
22594718 28204707 Wed Mar 02 17:23:28 CST 2022 MES BUNDLE ON TOP OF RDBMS 11.2.0.4.6 DBPSU
24975421 28204707 Wed Mar 02 17:23:28 CST 2022 MES BUNDLE ON TOP OF RDBMS 11.2.0.4.161018 DB PSU
LDAP_CLIENT11.2.0.4.0DBPSU_LINUX.X64_180625 PORT
DBPSU (26925576)
11204/12101/12102 APR DBPSU/DBBP
APRIL 2016 PSU
JANUARY 2016 PSU
11.2.0.4.6 PSU APPLIED.
20296213 20299013 Wed Mar 02 17:22:01 CST 2022 MAKE JOX_ON FAILS WITH ERROR AFTER PSU 12.1.0.1.5
19769489 19769489 Wed Mar 02 17:21:56 CST 2022 DATABASE PATCH SET UPDATE 11.2.0.4.5 (INCLUDES CPU
20074391 19769489 Wed Mar 02 17:21:56 CST 2022 PSU 11.2.0.3.13 POST-DEINSTALLATION CATBUNDLE
19121551 19121551 Wed Mar 02 17:21:52 CST 2022 DATABASE PATCH SET UPDATE 11.2.0.4.4 (INCLUDES CPU
19727057 19121551 Wed Mar 02 17:21:52 CST 2022 HANDLE JVMPSU.SQL IN CATBUNDLE
18522509 18522509 Wed Mar 02 17:21:36 CST 2022 DATABASE PATCH SET UPDATE 11.2.0.4.3 (INCLUDES CPU
18031668 18031668 Wed Mar 02 17:21:31 CST 2022 DATABASE PATCH SET UPDATE 11.2.0.4.2 (INCLUDES CPU
18180390 18031668 Wed Mar 02 17:21:31 CST 2022 AFTER APPLYING DBPSU 11.2.0.4.1 DB PROCESSES GET
17478514 17478514 Wed Mar 02 17:21:28 CST 2022 DATABASE PATCH SET UPDATE 11.2.0.4.1 (INCLUDES CPU
安装ojvm补丁包
[oracle@qa-spydb software11G]$ $ORACLE_HOME/OPatch/opatch apply -silent 31668908/
Oracle 临时补丁程序安装程序版本 11.2.0.3.33
版权所有 (c) 2022, Oracle Corporation。保留所有权利。
Oracle 主目录 :/u01/oracle/product/11.2.0
主产品清单:/u01/oracle/oraInventory
来自 :/u01/oracle/product/11.2.0/oraInst.loc
OPatch 版本 :11.2.0.3.33
OUI 版本 :11.2.0.4.0
日志文件位置:/u01/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2022-03-02_17-28-44下午_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 31668908
是否继续? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。
(Oracle 主目录 = '/u01/oracle/product/11.2.0')
本地系统是否已准备打补丁? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
正在将临时补丁程序 '31668908' 应用于 OH '/u01/oracle/product/11.2.0'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] , 或找到更高版本。
正在为组件 oracle.javavm.server, 11.2.0.4.0 打补丁...
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.javavm.client, 11.2.0.4.0 打补丁...
正在为组件 oracle.dbjava.jdbc, 11.2.0.4.0 打补丁...
正在为组件 oracle.dbjava.ic, 11.2.0.4.0 打补丁...
Patch 31668908 successfully applied.
Log file location: /u01/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2022-03-02_17-28-44下午_1.log
OPatch succeeded.
[oracle@qa-spydb software11G]$ /u01/oracle/product/11.2.0/OPatch/opatch lsinventory
Oracle 临时补丁程序安装程序版本 11.2.0.3.33
版权所有 (c) 2022, Oracle Corporation。保留所有权利。
Oracle 主目录 :/u01/oracle/product/11.2.0
主产品清单:/u01/oracle/oraInventory
来自 :/u01/oracle/product/11.2.0/oraInst.loc
OPatch 版本 :11.2.0.3.33
OUI 版本 :11.2.0.4.0
日志文件位置:/u01/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2022-03-02_17-29-34下午_1.log
Lsinventory Output file location : /u01/oracle/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2022-03-02_17-29-34下午.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: qa-spydb
ARU platform id: 226
ARU platform description:: Linux x86-64
已安装的顶级产品 (1):
Oracle Database 11g 11.2.0.4.0
此 Oracle 主目录中已安装 1 个产品。
临时补丁程序 (2) :
Patch 31668908 : applied on Wed Mar 02 17:29:01 CST 2022
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 Wed Mar 02 17:24:12 CST 2022
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)"
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, 13854364, 29483723, 19915271
22468255, 19516448, 14458214, 23713236, 23140259, 29434301, 22502493
19540573, 18272672, 16410570, 16494615, 19174430, 21352646, 16901385
16596890, 22243719, 18996843, 21387964, 20334344, 17174582, 22250006
17798953, 24307571, 14015842, 18031668, 15955387, 30758943, 21534893
16832076, 16065166, 16579084, 25427662, 21179898, 24589081, 11786053
15990359, 17982832, 18685892, 20142975, 24835538, 16315398, 20861693
30018017, 17037130, 17284817, 17643573, 18832544, 17891946, 17279227
17588480, 17291347, 16731148, 21097043, 24528741, 22321741, 17165204
26245237, 17891943, 25205368, 17359610, 17265217, 17465741, 29621961
22551446, 31492176, 18191164, 16721594, 18614015, 27825893, 18440095
19769489, 20596234, 25115178, 18482502, 16043574, 20936905, 17360606
22321756, 19211724, 17392698, 19463893, 31492164, 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, 30517516, 22168163, 16091637, 20569094, 31492144, 17468141
30365745, 29962939, 19469538, 29633753, 20598042, 16042673, 23302839
17437634, 24473736, 28734355, 19049453, 16941434, 20387265, 16833527
21343775, 17297939, 16069901, 14285317, 22380919, 18436647, 23065323
31885190, 21983325, 17853498, 24790914, 23571055, 16542886, 21286665
17365043, 17752995, 25914276, 17296856, 18783224, 22353199, 22083366
28305362, 21419850, 16180763, 23294548, 26679352, 13960236, 25328093
25423453, 18339044, 17282229, 28384353, 25600421, 18856999, 31031715
18259031, 28806384, 21354456, 23725036, 18471685, 31885162, 30237239
17258090, 16344544, 17903598, 17011832, 18135678, 18704244, 17786518
19718981, 25655390, 17242746, 20250147, 19197175, 17390431, 17835627
17672719, 31125948, 17393915, 21566639, 18765602, 21425496, 26544823
22228324, 29962927, 18682983, 30179644, 25165496, 12816846, 31885179
18774543, 18747196, 31885173, 17824637, 21834568, 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, 19445860, 26654363, 22977256, 16692232, 30200680
27374796, 21142837, 20869721, 17649265, 24555417, 17847764, 25879656
21756699, 19697993, 28364007, 17787259, 23628685, 30578221, 30252098
23007241, 27351628, 18094246, 18460587, 20031873, 17375354, 21698350
26513067, 21538567, 18232865, 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
19831647, 16613964, 17532245, 18334586, 17288409, 17341326, 31338362
17449815, 15913355, 16399083, 18740837, 20294666, 27404573, 14565184
21517440, 17614134, 19854503, 14245531, 16194160, 18325460, 15979965
30562923, 20671094, 29965888, 27870645, 25093656, 18247991, 16912439
30562936, 17047404, 24433711, 19930276, 22092979, 20506715, 31884535
23003979, 20506706, 13871092, 19272701, 17397545, 16785708, 19461270
21051862, 13829543, 16220077, 17008068, 18061914, 20448824, 30275359
18674024, 29343156, 19689979, 24411921, 30275351, 23184013, 17596908
17036973, 22175564, 22499356, 17612828, 20725343, 31001455, 28199085
23194294, 17630484, 21051858, 20017509, 21051852, 17767676, 17232014
22893153, 12611721, 25555252, 18356166, 17071721, 19315668, 25764020
16863422, 21051840, 17820741, 17267114, 18043064, 21538558, 26243698
20324049, 21612959, 30305880, 16392068, 18744139, 24348685, 26746894
17806696, 18628388, 27072923, 14010183, 16595641, 17080436, 17332800
20777150, 21453153, 20299015, 18413820, 18264060, 16819962, 22465352
21351877, 21051833, 18673342, 30393318, 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, 31885230, 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, 30215130
19393542, 14657740, 17532729, 17393683, 17389192, 17783588, 17852463
19358317, 17441661, 14034426, 28254374, 20631274, 19207117, 26569225
17518652, 24662775, 19475971, 31885201, 18282562, 30421204, 19896336
17348614, 19827973, 31883489, 17346671, 31022281, 19791273, 24476274
22296366, 13853126, 18273830, 17570606, 13558557, 26007010, 20425790
16685417, 31885223, 18180390, 14692762, 18159793, 17027426, 24476265
23177648, 17851160, 16870214, 18202441, 17227073, 20657411, 19006849
22606521, 20506699, 28000269, 23536835, 17761775, 20382309, 16306373
31885213, 17801017, 19680952, 16850630, 17694209, 26667015, 17877323
18230522, 24563422, 17446237, 17889549, 17551674, 16233738, 22730454
17571039, 26667023, 19972570, 18849970, 21532755, 20860659, 22905130
21168487, 17016369, 21263635, 17231779, 17717883, 21343897, 27710072
18522509, 23209741, 17484731, 21972320, 19972569, 19972568, 17716305
21059919, 19972566, 19972564, 26667032, 17394950, 26318200, 20657441
17551699, 17006570, 18051556, 12364061, 18029658, 17546973, 18262334
19699191, 30387666, 17227277, 18018515, 16943711, 18388363, 17982555
20828947, 18098207, 18436307, 19584068, 16898135, 13936038, 19601762
31010960, 14054676, 25505394, 18228645, 19013183, 29782211, 25042823
17721717, 17239687, 25248384, 25634317, 20134113, 20273319, 28501075
30624864, 21063322, 31834759, 17344412, 22507210, 16354467, 21795111
25505371, 16777840, 25879984, 17811456, 19730508, 17385178, 18166013
17484762, 10136473, 6599380, 20717359, 20296213, 27097854, 13955826
18193833, 17545847, 16837842, 18964939, 19871910, 25505382, 14786201
17811447, 18554763, 21132297, 25957038, 20004087, 17889583, 19544839
26631046, 22507234, 24719736, 18868646, 17042658, 20627866, 14106803
13951456, 18139690, 18277454, 13680635, 22750215, 25823754, 18554871
18515268, 20169408, 24908321, 17274537, 17602269, 26575788, 19032867
17762296, 14829250, 16929165, 14602788, 28849751, 21794615, 18899974
29944660, 18441944, 14521218, 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, 22826067, 18886413, 17156148, 17936109, 20509482, 27255377
24717859, 18762750, 21526048, 24560906, 18096714, 17238511, 26078387
27053456, 20144308, 25364628, 18244962, 19433930, 20476175, 19297917
19330795, 21174504, 18280813, 31506720, 28819280, 17614227, 28357401
21911701, 25809524, 17006183, 18092127, 19727057, 17695685, 26039623
22820579, 20856766, 15861775, 17258582, 21668627, 19487147, 20925795
28100487, 22760679, 26482376, 19554106, 21629064, 18199537, 18091059
17299889, 26999139, 21538485, 17546761, 26336977, 25775213, 18155762
30803210, 16956380, 31194264, 19207156, 14705949, 23105538, 26198926
19258504, 16314254, 17890099, 17246576, 17655634, 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, 22666802
17892268, 31668061, 17501491, 20907061, 14354737, 17835048, 21787056
22195485, 22782647, 17082983, 23266217, 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, 31172207, 23115139, 28790634, 21394225
16360112, 22195477, 17726838, 18510194, 17571306, 24766121, 17302277
21842740, 17551709, 26910644, 17634921, 28566241, 25489607, 16538760
--------------------------------------------------------------------------------
OPatch succeeded.
此时在进行opatch筛选
[oracle@qa-spydb software11G]$ $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep 'PSU|PATCH SET UPDATE'
PSU LABEL NAMES
19699946 31668908 Wed Mar 02 17:29:01 CST 2022 REMOVE CHECK FROM JVMPSU.SQL FOR JAVAVM BEING VALI
19852360 31668908 Wed Mar 02 17:29:01 CST 2022 ORACLE JAVAVM COMPONENT 11.2.0.4.1 DATABASE PSU -
19909862 31668908 Wed Mar 02 17:29:01 CST 2022 IMPROVEMENTS NEEDED FOR OJVM PSU
21811517 31668908 Wed Mar 02 17:29:01 CST 2022 UPDATE NEEDED TO VERSION FILES FOR OJVM PSU5
21911849 31668908 Wed Mar 02 17:29:01 CST 2022 ORA-29548 EVEN AFTER OJVM PSU POST-INSTALL IS RUN
PSU - GENERIC JDBC PATCH
AFTER OJVM PSU POST-INSTALL
CERTS ON TOKENS AFTER OCT 18 PSU
28806384 28729262 Wed Mar 02 17:23:33 CST 2022 OCTOBER 2018 PSU BREAKS FIPS 140-1 STANDARD
11.2.0.4.181016GIPSU AS PER BUG 28818855
OF 18121298 IS APPLIED ON PSU 11.2.0.4.181016
17518652 28204707 Wed Mar 02 17:23:28 CST 2022 REMOVE OLD RSA BUILD IN 11.2.0.4 PSU BRANCH
22594718 28204707 Wed Mar 02 17:23:28 CST 2022 MES BUNDLE ON TOP OF RDBMS 11.2.0.4.6 DBPSU
24975421 28204707 Wed Mar 02 17:23:28 CST 2022 MES BUNDLE ON TOP OF RDBMS 11.2.0.4.161018 DB PSU
LDAP_CLIENT11.2.0.4.0DBPSU_LINUX.X64_180625 PORT
DBPSU (26925576)
11204/12101/12102 APR DBPSU/DBBP
APRIL 2016 PSU
JANUARY 2016 PSU
11.2.0.4.6 PSU APPLIED.
20296213 20299013 Wed Mar 02 17:22:01 CST 2022 MAKE JOX_ON FAILS WITH ERROR AFTER PSU 12.1.0.1.5
19769489 19769489 Wed Mar 02 17:21:56 CST 2022 DATABASE PATCH SET UPDATE 11.2.0.4.5 (INCLUDES CPU
20074391 19769489 Wed Mar 02 17:21:56 CST 2022 PSU 11.2.0.3.13 POST-DEINSTALLATION CATBUNDLE
19121551 19121551 Wed Mar 02 17:21:52 CST 2022 DATABASE PATCH SET UPDATE 11.2.0.4.4 (INCLUDES CPU
19727057 19121551 Wed Mar 02 17:21:52 CST 2022 HANDLE JVMPSU.SQL IN CATBUNDLE
18522509 18522509 Wed Mar 02 17:21:36 CST 2022 DATABASE PATCH SET UPDATE 11.2.0.4.3 (INCLUDES CPU
18031668 18031668 Wed Mar 02 17:21:31 CST 2022 DATABASE PATCH SET UPDATE 11.2.0.4.2 (INCLUDES CPU
18180390 18031668 Wed Mar 02 17:21:31 CST 2022 AFTER APPLYING DBPSU 11.2.0.4.1 DB PROCESSES GET
17478514 17478514 Wed Mar 02 17:21:28 CST 2022 DATABASE PATCH SET UPDATE 11.2.0.4.1 (INCLUDES CPU
可以看到java虚拟机补丁安装好了
数据库软件升级好了,接下来我们打开数据库,开启监听
对数据库中的数据字典进行升级
[oracle@qa-spydb admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 2 17:34:13 2022
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> @$ORACLE_HOME/rdbms/admin/catbundle.sql psu apply
SQL> shutdown immediate
SQL> startup
重新编译无效对象
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
打OJVM(Oracle JavaVM Component Database PSU)补丁:
SQL > @$ORACLE_HOME/rdbms/admin/dbmsjdev.sql
SQL> exec dbms_java_dev.disable
PL/SQL procedure successfully completed.
SQL> exec dbms_java_dev.disable
(官方描述中我们如果数据库不适用java相关功能的话,建议关闭,此脚本是通过触发器和grant,roveke实现enable和disable)
至此我们数据库数据字典和软件升级都已完成
数据库验证