Oracle11.2.0.4升级到11.2.0.4.18详细步骤
11.2.0.4单机安装完成后升级到11.2.0.4.18的详细步骤：
步骤：
1、 先下载psu补丁包：
https://support.oracle.com/epmos/faces/documentdisplay?id=1454618.1&displayindex=3#aref_section230
2、 确认补丁包的版本和适配
在readme 中
3、 安装
安装记录：
1、 下载补丁包，确认版本
[oracle@dg1bao]$ ll
total203780
-rw-r--r--1 oracle oinstall 110236755 may 25 23:35 p24732075_112040_linux-x86-64.zip
-rw-r--r--1 oracle oinstall 98352086 may 27 09:37p6880880_112000_linux-x86-64.zip
2、 升级opath
[oracle@dg1opatch]$ pwd
/oracle/app/oracle/product/11.2.0/dbhome_4/opatch
(1)先确认版本：
[oracle@dg1opatch]$ ./opatch version
opatchversion: 11.2.0.3
opatchsucceeded.
(2)备份opath
[oracle@bsplinuxoracle]$ tar zcvf opatch_bk.tar opatch
(3)解压覆盖(其实可以把原opath删掉再解压)
unzip p6880880_112000_linux-x86-64.zip –d $oracle_home
(4)验证
[oracle@dg1opatch]$ ./opatch version
opatchversion: 11.2.0.3.15
opatchsucceeded.
3、 升级database
(1)解压
[oracle@dg1bao]$ unzip p24732075_112040_linux-x86-64.zip -d /oracle/app/oracle/product/11.2.0/dbhome_4/
(2)收集升级前信息
升级之前：
[oracle@dg1opatch]$ ./opatch lsinventory
oracleinterim patch installer version 11.2.0.3.15
copyright(c) 2017, oracle corporation. all rightsreserved.
oraclehome :/oracle/app/oracle/product/11.2.0/dbhome_4
centralinventory : /oracle/orainventory
from :/oracle/app/oracle/product/11.2.0/dbhome_4/orainst.loc
opatchversion : 11.2.0.3.15
ouiversion : 11.2.0.4.0
log filelocation :/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/opatch2017-05-27_10-21-35am_1.log
lsinventoryoutput file location :/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/lsinv/lsinventory2017-05-27_10-21-35am.txt
--------------------------------------------------------------------------------
localmachine information::
hostname:dg1
aruplatform id: 226
aruplatform description:: linux x86-64
installedtop-level products (1):
oracledatabase 11g 11.2.0.4.0
thereare 1 products installed in this oracle home.
thereare no interim patches installed in this oracle home.
-------------------------------------------------------------------------------
opatchsucceeded.
[oracle@dg1opatch]$ ./opatch lspatches
thereare no interim patches installed in this oracle home"/oracle/app/oracle/product/11.2.0/dbhome_4".
opatchsucceeded.
sql>select version, id, bundle_series, comments from dba_registry_history;
version id bundle_series comments
----------------------- ------------------------------ -------------------------
8289601 viewinvalidation
11.2.0.4.0 upgraded from 11.2.0.1.0
11.2.0.4 0 psu patchset 11.2.0.2.0
(3)关闭和监听
sql> shutdown immediate ;
[oracle@dg1bao]$ lsnrctl stop
(4)在补丁包目录下使用$oracle_home下opath打补丁
[oracle@dg1dbhome_4]$ pwd
/oracle/app/oracle/product/11.2.0/dbhome_4/24732075
检查：
[oracle@dg124732075]$ opatch prereq checkconflictagainstohwithdetail -ph ./
-bash:opatch: command not found
[oracle@dg124732075]$ /oracle/app/oracle/product/11.2.0/dbhome_4/opatch/opatch prereqcheckconflictagainstohwithdetail -ph ./
oracleinterim patch installer version 11.2.0.3.15
copyright(c) 2017, oracle corporation. all rightsreserved.
prereqsession
oraclehome :/oracle/app/oracle/product/11.2.0/dbhome_4
centralinventory : /oracle/orainventory
from :/oracle/app/oracle/product/11.2.0/dbhome_4/orainst.loc
opatchversion : 11.2.0.3.15
ouiversion : 11.2.0.4.0
log filelocation :/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/opatch2017-05-27_10-35-36am_1.log
invokingprereq "checkconflictagainstohwithdetail"
prereq"checkconflictagainstohwithdetail" passed.
opatchsucceeded.
开始应用:
[oracle@dg124732075]$/oracle/app/oracle/product/11.2.0/dbhome_4/opatch/opatch apply
oracleinterim patch installer version 11.2.0.3.15
copyright(c) 2017, oracle corporation. all rightsreserved.
oraclehome :/oracle/app/oracle/product/11.2.0/dbhome_4
centralinventory : /oracle/orainventory
from :/oracle/app/oracle/product/11.2.0/dbhome_4/orainst.loc
opatchversion : 11.2.0.3.15
ouiversion : 11.2.0.4.0
log filelocation :/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/opatch2017-05-27_10-36-05am_1.log
verifyingenvironment and performing prerequisite checks...
prerequisitecheck "checkactivefilesandexecutables" failed.
thedetails are:
followingexecutables are active :
/oracle/app/oracle/product/11.2.0/dbhome_4/bin/oracle
/oracle/app/oracle/product/11.2.0/dbhome_4/lib/libclntsh.so.11.1
prerequisitecheck "checkactivefilesandexecutables" failed.
thedetails are:
followingexecutables are active :
/oracle/app/oracle/product/11.2.0/dbhome_4/lib/libsqlplus.so
utilsessionfailed: prerequisite check "checkactivefilesandexecutables"failed.prerequisite check "checkactivefilesandexecutables" failed.
log filelocation:/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/opatch2017-05-27_10-36-05am_1.log
opatchfailed with error code 73
[oracle@dg124732075]$ pwd
/oracle/app/oracle/product/11.2.0/dbhome_4/24732075
[oracle@dg124732075]$ /oracle/app/oracle/product/11.2.0/dbhome_4/opatch/opatch apply
oracleinterim patch installer version 11.2.0.3.15
copyright(c) 2017, oracle corporation. all rightsreserved.
oraclehome :/oracle/app/oracle/product/11.2.0/dbhome_4
centralinventory : /oracle/orainventory
from :/oracle/app/oracle/product/11.2.0/dbhome_4/orainst.loc
opatchversion : 11.2.0.3.15
oui version : 11.2.0.4.0
log filelocation :/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/opatch2017-05-27_10-42-04am_1.log
verifyingenvironment and performing prerequisite checks...
opatchcontinues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075
do youwant to proceed? [y|n]
y
userresponded with: y
allchecks passed.
problemwith accessing response file of "/oracle/app/oracle/product/11.2.0/dbhome_4/ccr/bin/setupccr".
pleaseshutdown oracle instances running out of this oracle_home on the local system.
(oraclehome = '/oracle/app/oracle/product/11.2.0/dbhome_4')
is thelocal system ready for patching? [y|n]
y
userresponded with: y
backingup files...
applyingsub-patch '17478514' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.sdo, 11.2.0.4.0...
patchingcomponent oracle.sysman.agent, 10.2.0.4.5...
patchingcomponent oracle.xdk, 11.2.0.4.0...
patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...
patchingcomponent oracle.sdo.locator, 11.2.0.4.0...
patchingcomponent oracle.nlsrtl.rsf, 11.2.0.4.0...
patchingcomponent oracle.xdk.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...
applyingsub-patch '18031668' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.ldap.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms.crs, 11.2.0.4.0...
patchingcomponent oracle.precomp.common, 11.2.0.4.0...
patchingcomponent oracle.ldap.rsf.ic, 11.2.0.4.0...
patchingcomponent oracle.rdbms.deconfig, 11.2.0.4.0...
patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...
applyingsub-patch '18522509' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.precomp.common, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...
patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...
patchingcomponent oracle.rdbms.deconfig, 11.2.0.4.0...
applyingsub-patch '19121551' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
patchingcomponent oracle.precomp.common, 11.2.0.4.0...
patchingcomponent oracle.sysman.console.db, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...
patchingcomponent oracle.ordim.client, 11.2.0.4.0...
patchingcomponent oracle.ordim.jai, 11.2.0.4.0...
applyingsub-patch '19769489' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
applysession:optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the oracle home or a higherversion is found.
patchingcomponent oracle.precomp.common, 11.2.0.4.0...
patchingcomponent oracle.ovm, 11.2.0.4.0...
patchingcomponent oracle.xdk, 11.2.0.4.0...
patchingcomponent oracle.rdbms.util, 11.2.0.4.0...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...
patchingcomponent oracle.xdk.parser.java, 11.2.0.4.0...
patchingcomponent oracle.oraolap, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.xdk.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...
patchingcomponent oracle.rdbms.deconfig, 11.2.0.4.0...
applyingsub-patch '20299013' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
patchingcomponent oracle.rdbms.dv, 11.2.0.4.0...
patchingcomponent oracle.rdbms.oci, 11.2.0.4.0...
patchingcomponent oracle.precomp.common, 11.2.0.4.0...
patchingcomponent oracle.sysman.agent, 10.2.0.4.5...
patchingcomponent oracle.xdk, 11.2.0.4.0...
patchingcomponent oracle.sysman.common, 10.2.0.4.5...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...
patchingcomponent oracle.xdk.parser.java, 11.2.0.4.0...
patchingcomponent oracle.sysman.console.db, 11.2.0.4.0...
patchingcomponent oracle.xdk.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.sysman.common.core, 10.2.0.4.5...
patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...
patchingcomponent oracle.rdbms.deconfig, 11.2.0.4.0...
applyingsub-patch '20760982' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
patchingcomponent oracle.sysman.console.db, 11.2.0.4.0...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
applyingsub-patch '21352635' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
patchingcomponent oracle.sysman.agent, 10.2.0.4.5...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
applyingsub-patch '21948347' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
applysession:optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the oracle home or a higherversion is found.
patchingcomponent oracle.sysman.agent, 10.2.0.4.5...
patchingcomponent oracle.ovm, 11.2.0.4.0...
patchingcomponent oracle.xdk, 11.2.0.4.0...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.nlsrtl.rsf, 11.2.0.4.0...
patchingcomponent oracle.xdk.parser.java, 11.2.0.4.0...
patchingcomponent oracle.sysman.console.db, 11.2.0.4.0...
patchingcomponent oracle.xdk.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.sysman.oms.core, 10.2.0.4.5...
applyingsub-patch '22502456' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
applysession:optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the oracle home or a higherversion is found.
patchingcomponent oracle.precomp.common, 11.2.0.4.0...
patchingcomponent oracle.oraolap.dbscripts, 11.2.0.4.0...
patchingcomponent oracle.rdbms.olap, 11.2.0.4.0...
patchingcomponent oracle.oraolap, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...
applyingsub-patch '23054359' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
patchingcomponent oracle.rdbms.dv, 11.2.0.4.0...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
applyingsub-patch '24006111' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
patchingcomponent oracle.sqlplus.ic, 11.2.0.4.0...
patchingcomponent oracle.sqlplus, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...
applyingsub-patch '24732075' to oh '/oracle/app/oracle/product/11.2.0/dbhome_4'
patchingcomponent oracle.precomp.common, 11.2.0.4.0...
patchingcomponent oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...
patchingcomponent oracle.sqlplus.ic, 11.2.0.4.0...
patchingcomponent oracle.sqlplus, 11.2.0.4.0...
patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
patchingcomponent oracle.rdbms, 11.2.0.4.0...
patchingcomponent oracle.rdbms.util, 11.2.0.4.0...
patchingcomponent oracle.ordim.client, 11.2.0.4.0...
patchingcomponent oracle.ordim.jai, 11.2.0.4.0...
patchingcomponent oracle.ordim.server, 11.2.0.4.0...
compositepatch 24732075 successfully applied.
log filelocation:/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/opatch2017-05-27_10-42-04am_1.log
opatchsucceeded.
完成
(5)检查更新
升级后：
[oracle@dg124732075]$ /oracle/app/oracle/product/11.2.0/dbhome_4/opatch/opatch lsinventory
oracleinterim patch installer version 11.2.0.3.15
copyright(c) 2017, oracle corporation. all rightsreserved.
oraclehome : /oracle/app/oracle/product/11.2.0/dbhome_4
centralinventory : /oracle/orainventory
from :/oracle/app/oracle/product/11.2.0/dbhome_4/orainst.loc
opatchversion : 11.2.0.3.15
ouiversion : 11.2.0.4.0
log filelocation : /oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/opatch2017-05-27_10-54-42am_1.log
lsinventoryoutput file location :/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/lsinv/lsinventory2017-05-27_10-54-42am.txt
--------------------------------------------------------------------------------
localmachine information::
hostname:dg1
aruplatform id: 226
aruplatform description:: linux x86-64
installedtop-level products (1):
oracledatabase 11g 11.2.0.4.0
thereare 1 products installed in this oracle home.
interimpatches (1) :
patch 24732075 : applied on sat may 27 10:47:53 cst 2017
uniquepatch id: 21176096
patchdescription: "database patch setupdate : 11.2.0.4.170418 (24732075)"
created on 22 feb 2017, 21:40:49 hrs pst8pdt
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:
17184721, 21538558, 16091637, 18092127,17381384, 15979965, 18441944
13837378, 16314254, 16731148, 17835048,13558557, 17201159, 17853498
17246576, 18356166, 18440047, 18681862,16875449, 19788842, 17296856
21330264, 14010183, 17648596, 17551063,17025461, 17267114, 22507210
17912217, 17889583, 18202441, 17040764,16524926, 17478145, 19358317
22148226, 18747196, 18641419, 17036973,17811789, 14285317, 16542886
18009564, 16618694, 8322815, 16692232,18247991, 22507234, 17570240
17848897, 17441661, 14034426, 17465741,16596890, 17437634, 20506706
21343897, 21453153, 18339044, 22321741,17951233, 18430495, 21787056
22380919, 20506715, 17811429, 19721304,18230522, 19554106, 19458377
17612828, 6599380, 22092979, 22321756,17040527, 17811438, 18641461
14657740, 13364795, 21387964, 17346671,17588480, 18235390, 17889549
19309466, 16472716, 20596234, 18331850,18641451, 17344412, 21179898
24842886, 17546761, 18203835, 18964939,18203838, 18203837, 17313525
22195457, 18139690, 16837842, 22296366,14106803, 17842825, 22657942
21352646, 20657441, 16360112, 22195441,17389192, 14565184, 17205719
18440095, 22195448, 14354737, 14764829,13944971, 16571443, 21868720
17186905, 17080436, 18673342, 22905130,17027426, 19972569, 19972568
19972566, 17282229, 19972564, 16870214,19615136, 17390431, 18762750
16613964, 18098207, 17957017, 18471685,19730508, 21538485, 18264060
17323222, 17754782, 17600719, 18317531,17852463, 17596908, 17655634
16228604, 20074391, 19972570, 18996843,19854503, 16042673, 17835627
20334344, 18000422, 20861693, 17393683,17551709, 20506699, 19006849
18456514, 18277454, 17258090, 17174582,17242746, 16399083, 17824637
17762296, 17397545, 16450169, 12364061,20067212, 18856999, 19211724
19463893, 21343775, 19463897, 17853456,18673304, 20004021, 21668627
16194160, 17477958, 16538760, 12982566,20296213, 18293054, 17610798
19699191, 18135678, 17311728, 16785708,10136473, 24560906, 17786518
18315328, 18334586, 12747740, 19032867,18096714, 17390160, 17232014
16422541, 18673325, 18155762, 14015842,19827973, 22683225, 17726838
18554871, 23177648, 18051556, 20803583,17922254, 15990359, 21972320
18282562, 16855292, 16668584, 21343838,20299015, 17446237, 18093615
17694209, 17288409, 17274537, 13955826,16934803, 17634921, 17501491
16315398, 22683212, 17006183, 13829543,18191164, 17655240, 19393542
18384391, 21538567, 16198143, 21847223,17892268, 20142975, 19584068
17165204, 18508861, 21756699, 16901385,18554763, 18189036, 17443671
17385178, 17936109, 14829250, 20925795,17478514, 16850630, 13951456
16595641, 15861775, 14054676, 16912439,17299889, 17297939, 18619917
16833527, 17798953, 17816865, 18607546,17571306, 21286665, 17341326
17851160, 20558005, 17586955, 19049453,21051840, 17587063, 16956380
18328509, 14133975, 18061914, 21051833,18522509, 18765602, 18199537
17332800, 13609098, 18384537, 22502493,14338435, 17945983, 21067387
16392068, 17752995, 21051862, 25505382,17237521, 16863422, 18244962
19544839, 24433711, 17156148, 18973907,17877323, 17449815, 18180390
17088068, 17037130, 20004087, 19466309,25505371, 11733603, 18084625
21051858, 18674024, 21051852, 18091059,25369547, 16306373, 18306996
19915271, 18193833, 17787259, 20631274,16344544, 14692762, 18614015
17346091, 18228645, 17721717, 18436307,21756677, 11883252, 17891943
22353199, 16384983, 19121551, 12816846,17982555, 17761775, 22243719
25505394, 17265217, 17071721, 16721594,21756661, 18262334, 15913355
17891946, 17672719, 17602269, 17239687,17042658, 17238511, 17811456
17284817, 17752121, 17394950, 16579084,17011832, 22195465, 14602788
18325460, 24476265, 24476274, 12611721,16903536, 17006570, 16043574
18783224, 16494615, 21526048, 19197175,16069901, 17811447, 17308789
22195477, 17865671, 19013183, 17343514,18316692, 17325413, 16180763
17348614, 14368995, 21983325, 17393915,16285691, 20331945, 17883081
24316947, 17705023, 17614227, 22195485,14084247, 13645875, 16777840
19727057, 14852021, 18744139, 18674047,17716305, 18482502, 17622427
19289642, 22195492, 14458214, 18723434,17767676, 25505407, 19258504
17786278, 17082983, 21351877, 13498382,18331812, 16065166, 18031668
22893153, 16943711, 21517440, 17649265,13866822, 18094246, 24528741
14245531, 17783588, 17082359, 20448824,18280813, 23330119, 16268425
17302277, 18018515, 17215560, 24411921,19271443, 17016369, 20777150
23330124, 20441797, 19769489, 25093656,17545847, 18260550, 13853126
23536835, 17227277, 9756271, 18868646,17614134, 17546973, 19680952
18704244, 18828868, 18273830, 17050888,17360606, 16992075, 17375354
12905058, 18362222, 17571039, 17468141,18436647, 17235750, 21168487
16220077, 16929165
--------------------------------------------------------------------------------
opatchsucceeded.
[oracle@dg124732075]$
[oracle@dg124732075]$ /oracle/app/oracle/product/11.2.0/dbhome_4/opatch/opatch lspatches
24732075;databasepatch set update : 11.2.0.4.170418 (24732075)
opatchsucceeded.
sql>select version, id, bundle_series, comments from dba_registry_history;
version id bundle_series comments
------------------------- ------------------------------ ------------------------------
8289601 viewinvalidation
11.2.0.4.0 upgraded from 11.2.0.1.0
11.2.0.4 0 psu patchset 11.2.0.2.0
(6)启动数据库
sql> conn / as sysdba
sql> startup
升级数据字典
sql> @?/rdbms/admin/catbundle.sql psu apply 会有一会儿。
(7)确定补丁成功
最后我们需要确定补丁安装成功。对小补丁的升级来说，我们是不能够v$version视图中看到的。
sql>select * from v$version;
banner
--------------------------------------------------------------------------------
oracledatabase 11g enterprise edition release 11.2.0.4.0 - 64bit production
pl/sqlrelease 11.2.0.4.0 - production
core 11.2.0.4.0 production
tns forlinux: version 11.2.0.4.0 - production
nlsrtlversion 11.2.0.4.0 - production
通过opatch的信息库记录，可以看到补丁信息。见第五步中信息检查。
在dba_registry_history中，我们也可以看到记录。
sql>select version, id, bundle_series, comments from dba_registry_history;
version id bundle_series comments
--------------- ----------------- ------------- ----------------------------------------
8289601 viewinvalidation
11.2.0.4.0 upgraded from 11.2.0.1.0
11.2.0.4 0 psu patchset 11.2.0.2.0
11.2.0.4 170418 psu psu 11.2.0.4.170418
截止，升级完成。
下一篇： Oracle小练习