Oracle11.2.0.4单实例打PSU,OJVMPSU补丁快速参考
写在前面:
1.Oracel打每个补丁的操作有时存在差异,所以不管多熟悉,都应该在打任何补丁之前阅读新补丁中附带的readme。
2.Oracle每季度都会更新一个最新的PSU,本文最新指的是当前最新(即0719发布的PSU)。
3.之前整理的?完整记录一则Oracle11.2.0.4单实例打PSU补丁的过程由于旨在体验打补丁的整个过程,粘贴了所有过程输出,篇幅很长,不利于快速参考,本次旨在可以用来快速参考,并增加了OJVMPSU的修补部分。如果对本文的简要命令有疑问,可以反过来参考之前的文章做对比。
本次环境:RHEL6.5+Oracle11.2.0.4单实例
目前最新的PSU:补丁程序23054359:DATABASEPATCHSETUPDATE11.2.0.4.160719
目前最新的OJVMPSU:补丁程序23177551:OJVMPATCHSETUPDATE11.2.0.4.160719
1.OPatch更新
2.应用PSU补丁
3.应用OJVMPSU补丁
4.检查补丁应用情况
1.OPatch更新
打补丁一定要确保OPatch的版本符合readme中的要求,一般下载对应数据库版本最新的OPath覆盖即可。
此环节主要命令如下:
echo$ORACLE_HOME
cd$ORACLE_HOME
mvOPatchOPatch_bak
unzip/your_patch_dir/p6880880_112000_Linux-x86-64.zip
$ORACLE_HOME/OPatch/opatchversion
Tips:your_patch_dir这里是代指你补丁介质存放的绝对目录.
2.应用PSU补丁
2.1数据库软件应用补丁:
此环节主要命令如下:
cd/your_patch_dir
unzipp23054359_112040_Linux-x86-64.zip
cd23054359
exportPATH=$ORACLE_HOME/OPatch:$PATH
opatchprereqCheckConflictAgainstOHWithDetail-ph./
--关闭监听和数据库等相关服务
lsnrctlstop
SQL>shutdownimmediate
opatchapply
2.2数据库应用补丁:
此环节主要命令如下:
cd$ORACLE_HOME/rdbms/admin
sqlplus/nolog
SQL>CONNECT/ASSYSDBA
SQL>STARTUP
SQL>@catbundle.sqlpsuapply
SQL>QUIT
3.应用OJVMPSU补丁
3.1数据库软件应用补丁:
此环节主要命令如下:
unzip-dp23177551_11204_.zip
cd/23177551
opatchprereqCheckConflictAgainstOHWithDetail-ph./
--关闭数据库
SQL>shutdownimmediate
cd/23177551
opatchapply
opatchlsinventory
3.2数据库应用补丁:
此环节主要命令如下:
--加载改动的SQL文件到数据库
cd$ORACLE_HOME/sqlpatch/23177551
sqlplus/nolog
SQL>CONNECT/ASSYSDBA
SQL>startupupgrade
SQL>@postinstall.sql
SQL>shutdown
SQL>startup
--重新编辑无效对象
cd$ORACLE_HOME/rdbms/admin
sqlplus/nolog
SQL>CONNECT/ASSYSDBA
SQL>@utlrp.sql
--最后启动监听
lsnrctlstart
SQL>altersystemregister;
4.检查补丁应用情况
4.1opatch检查
$ORACLE_HOME/OPatch/opatchlspatches;
$ORACLE_HOME/OPatch/opatchlsinventory;
正常输出如下:
$$ORACLE_HOME/OPatch/opatchlspatches;
23177551;OJVMPATCHSETUPDATE11.2.0.4.160719
23054359;DatabasePatchSetUpdate:11.2.0.4.160719(23054359)
OPatchsucceeded.
$$ORACLE_HOME/OPatch/opatchlsinventory;
Oracle中间补丁程序安装程序版本11.2.0.3.14
版权所有(c)2016,OracleCorporation。保留所有权利。
OracleHome:/u01/app/oracle/product/11.2.0/dbhome_1
CentralInventory:/u01/app/oraInventory
from:/u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatchversion:11.2.0.3.14
OUIversion:11.2.0.4.0
Logfilelocation:/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/www.hunanwang.net/opatch/opatch2016-09-22_10-41-49上午_1.log
LsinventoryOutputfilelocation:/u01/app/oracle/product/11.2.0/dbhome_1/www.visa158.com/cfgtoollogs/opatch/lsinv/lsinventory2016-09-22_10-41-49上午.txt
--------------------------------------------------------------------------------
LocalMachineInformation::
Hostname:langchao01
ARUplatformid:226
ARUplatformdescription::Linuxx86-64
已安装的顶级产品(1):
OracleDatabase11g11.2.0.4.0
此Oracle主目录中已安装1个产品。
中间补丁程序(2):
Patch23177551:appliedonThuSep2209:51:13CST2016
UniquePatchID:20351577
Patchdescription:"OJVMPATCHSETUPDATE11.2.0.4.160719"
Createdon27Jun2016,12:28:29hrsPST8PDT
Bugsfixed:
23727132,18933818,19176885,17201047,14774730,19153980,21911849
18166577,17056813,21811517,19909862,22675136,19895326,22253904
17804361,19231857,17528315,19058059,19554117,19007266,17285560
22670385,18458318,19187988,23265914,19006757,19374518,19223010
22118835,19852360,20408829,21047766,21566944
Patch23054359:appliedonThuSep2209:37:04CST2016
UniquePatchID:20226193
Patchdescription:"DatabasePatchSetUpdate:11.2.0.4.160719(23054359)"
Createdon15Jun2016,16:08:35hrsPST8PDT
Sub-patch22502456;"DatabasePatchSetUpdate:11.2.0.4.160419(22502456)"
Sub-patch21948347;"DatabasePatchSetUpdate:11.2.0.4.160119(21948347)"
Sub-patch21352635;"DatabasePatchSetUpdate:11.2.0.4.8(21352635)"
Sub-patch20760982;"DatabasePatchSetUpdate:11.2.0.4.7(20760982)"
Sub-patch20299013;"DatabasePatchSetUpdate:11.2.0.4.6(20299013)"
Sub-patch19769489;"DatabasePatchSetUpdate:11.2.0.4.5(19769489)"
Sub-patch19121551;"DatabasePatchSetUpdate:11.2.0.4.4(19121551)"
Sub-patch18522509;"DatabasePatchSetUpdate:11.2.0.4.3(18522509)"
Sub-patch18031668;"DatabasePatchSetUpdate:11.2.0.4.2(18031668)"
Sub-patch17478514;"DatabasePatchSetUpdate:11.2.0.4.1(17478514)"
Bugsfixed:
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
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
22092979,22321756,17040527,17811438,18641461,14657740,13364795
21387964,17588480,17346671,18235390,17889549,19309466,16472716
20596234,18331850,18641451,17344412,21179898,17546761,18203835
18964939,18203838,18203837,17313525,22195457,18139690,22296366
14106803,16837842,17842825,21352646,20657441,16360112,22195441
17389192,14565184,17205719,14354737,22195448,14764829,13944971
16571443,21868720,17186905,17080436,18673342,17027426,19972569
19972568,19972566,17282229,19972564,16870214,19615136,17390431
18762750,16613964,18098207,17957017,18471685,19730508,21538485
18264060,17323222,17754782,17600719,18317531,17852463,17596908
17655634,20074391,16228604,19972570,18996843,19854503,16042673
17835627,20334344,20861693,18000422,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,17786518
18315328,18334586,12747740,19032867,18096714,17390160,17232014
16422541,18673325,18155762,14015842,19827973,22683225,17726838
18554871,23177648,18051556,20803583,18282562,17922254,15990359
21972320,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,18554763,16901385,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,17237521,16863422,18244962,19544839
17156148,18973907,17877323,17449815,18180390,17088068,17037130
20004087,19466309,11733603,21051858,18084625,18674024,21051852
18091059,18306996,16306373,19915271,18193833,17787259,20631274
16344544,14692762,18614015,17346091,18228645,17721717,18436307
11883252,21756677,17891943,22353199,16384983,19121551,12816846
17982555,17761775,17265217,17071721,16721594,21756661,18262334
15913355,17891946,17672719,17602269,17239687,17042658,17238511
17811456,17284817,17752121,17394950,16579084,17011832,22195465
14602788,18325460,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,17705023
17614227,22195485,14084247,13645875,16777840,19727057,14852021
18744139,18674047,17716305,18482502,19289642,17622427,22195492
14458214,18723434,17767676,19258504,17786278,17082983,21351877
13498382,18331812,16065166,18031668,22893153,16943711,21517440
17649265,13866822,18094246,14245531,17783588,17082359,20448824
18280813,23330119,16268425,17302277,18018515,17215560,19271443
17016369,20777150,23330124,20441797,19769489,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.
$
4.2SQL>selectfromdba_registry_history;
SQL>selectfromdba_registry_history;
SQL>setlinesize1000
SQL>r
1selectfromdba_registry_history
ACTION_TIMEACTIONNAMESPACEVERSIONIDBUNDLE_SERIESCOMMENTS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
24-AUG-1312.03.45.119862PMAPPLYSERVER11.2.0.40PSUPatchset11.2.0.2.0
22-JUL-1604.04.17.767881PMAPPLYSERVER11.2.0.40PSUPatchset11.2.0.2.0
22-SEP-1609.41.41.199208AMAPPLYSERVER11.2.0.4160719PSUPSU11.2.0.4.160719
22-SEP-1609.55.50.902876AMjvmpsu.sqlSERVER11.2.0.4.160719OJVMPSU0RANjvmpsu.sql
22-SEP-1609.55.50.941558AMAPPLYSERVER11.2.0.4.160719OJVMPSU0OJVMPSUpost-install
22-SEP-1609.55.50.943907AMAPPLY23177551Patch23177551applied
6rowsselected.
至此,Oracle11.2.0.4单实例打PSU,OJVMPSU补丁(160719)已完成。
|
|