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

截止，升级完成。