开发者社区> 技术小胖子> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

Oracle 11g RAC自动打GI PSU补丁(11.2.0.4.8)

简介:
+关注继续查看

一、准备工作

1,数据库环境

操作系统版本   : Redhat 6.5 x64   
数据库版本     : Oracle 11.2.0.4 x64 RAC    
Grid           : 11.2.0.4     
Oracle database: 11.2.0.4

本文出自:http://koumm.blog.51cto.com/

2,准备内容

GI PSU : p21523375_112040_Linux-x86-64.zip    
OPatch : p6880880_112000_Linux-x86-64.zip    
DB PSU : p21352635_112040_Linux-x86-64.zip 仅单实例使用。

OPatch下载地址:   
https://updates.oracle.com/download/6880880.html

说明:GI PSU包括DB PSU,CPU。

二、更新OPatch版本,必须要更新

说明:分别在两个节点更新OPatch版本。

1. 更新OPatch版本,需要更新到11.2.0.3.11,OPatch直接压缩替换就可以了。

(1) 上传p6880880_112000_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限,也可以采用/tmp目录。   
(2) root用户下将原OPatch目录改名。

mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatchbk   
mv /u01/app/oracle/product/11.2.0/db_1/OPatch /u01/app/oracle/product/11.2.0/db_1/OPatchBK

2. grid目录OPatch替换

(1) root用户   
cd /u01/software/;chown grid:oinstall p6880880_112000_Linux-x86-64.zip

(2) grid用户

su - grid   
cd /u01/software/    
unzip p6880880_112000_Linux-x86-64.zip

(3) root用户

cd /u01/software/   
mv OPatch /u01/app/11.2.0/grid/

(4) grid用户测试

su - grid   
/u01/app/11.2.0/grid/OPatch/opatch version

OPatch Version: 11.2.0.3.11   
OPatch succeeded.

3. oracle目录OPatch替换

(1) root用户

cd /u01/software/;chown oracle:oinstall p6880880_112000_Linux-x86-64.zip

(2) oracle用户

su - oracle   
cd /u01/software/    
unzip p6880880_112000_Linux-x86-64.zip

(3) root用户

cd /u01/software/   
mv OPatch /u01/app/oracle/product/11.2.0/db_1/

(4) oracle用户测试

su - oracle

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version

OPatch Version: 11.2.0.3.11   
OPatch succeeded.

三、分别在节点1和节点2分别生成ocm.rsp文件。

# su - oracle

$ cd  /u01/software   
$ /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp    
$ ls

ocm.rsp


四、开始升级GI PSU软件包

说明:一定要按照顺序一个一个节点的打。

1. grid用户下解决GI PSU补丁包

(1) root用户操作

cd /u01/software/;chown grid:oinstall p21523375_112040_Linux-x86-64.zip

(2) grid用户操作

su  - grid   
cd /u01/software/    
unzip p21523375_112040_Linux-x86-64.zip


2. 测试兼容性

su - grid

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/21523375/21352649 -oh $ORACLE_HOME    
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/21523375/21352642 -oh $ORACLE_HOME     
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/21523375/21352635 -oh $ORACLE_HOME

过程略过…

3、开始升级GRID

root用户依次节点1,节点2上执行。

# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/software/21523375 -oh /u01/app/11.2.0/grid/ -ocmrf /u01/software/ocm.rsp

Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn 21523375 -oh /u01/app/11.2.0/grid/ -ocmrf /u01/software/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-12-25_10-09-05.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:   
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-12-25_10-09-05.report.log

2015-12-25 10:09:05: Starting Clusterware Patch Setup   
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS...   
Stopped CRS successfully

patch /u01/software/21523375/21352635  apply successful for home  /u01/app/11.2.0/grid    
patch /u01/software/21523375/21352649  apply successful for home  /u01/app/11.2.0/grid     
patch /u01/software/21523375/21352642  apply successful for home  /u01/app/11.2.0/grid

Starting CRS...   
Installing Trace File Analyzer    
CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.


4. 检查升级情况

# su - grid

$ /u01/app/11.2.0/grid/OPatch/opatch lsinv    
                                                     
Oracle Interim Patch Installer version 11.2.0.3.11    
Copyright (c) 2015, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/11.2.0/grid    
Central Inventory : /u01/app/oraInventory    
   from           : /u01/app/11.2.0/grid/oraInst.loc    
OPatch version    : 11.2.0.3.11    
OUI version       : 11.2.0.4.0    
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-12-25_10-31-49AM_1.log

Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2015-12-25_10-31-49AM.txt

--------------------------------------------------------------------------------   
Local Machine Information::    
Hostname: db1    
ARU platform id: 226    
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 11g                                       11.2.0.4.0   
There are 1 products installed in this Oracle Home.


Interim patches (3) :

Patch  21352642     : applied on Fri Dec 25 10:22:50 CST 2015   
Unique Patch ID:  19203841    
Patch description:  "ACFS Patch Set Update : 11.2.0.4.8 (21352642)"    
   Created on 3 Sep 2015, 00:03:11 hrs PST8PDT    
   Bugs fixed:    
     17510275, 21369858, 17172303, 16318126, 19690653, 18610307, 17503605    
     17376318, 17203009, 20140148, 17721778, 17611362, 17164243, 19053182    
     17696547, 17699423, 17488768, 18915417, 18155334, 19919907, 18321597    
     18185024, 18168684, 17363999, 17636008, 18143006, 17428148, 20681968    
     17070158, 17475946

Patch  21352649     : applied on Fri Dec 25 10:19:11 CST 2015   
Unique Patch ID:  19203841    
Patch description:  "OCW Patch Set Update : 11.2.0.4.8 (21352649)"    
   Created on 2 Sep 2015, 23:43:49 hrs PST8PDT    
   Bugs fixed:    
     19270660, 18328800, 18508710, 18691572, 21251192, 20365005, 17750548    
     17387214, 17617807, 14497275, 20219458, 17733927, 18180541, 18962892    
     17292250, 17378618, 16759171, 20110156, 17843489, 17065496, 13991403    
     17273020, 17155238, 21245437, 18261183, 18053580, 20218012, 20995001    
     17039197, 17947785, 16317771, 10052729, 20340620, 20317221, 15917869    
     18199185, 18399991, 20186278, 17374271, 18024089, 16849642, 20746251    
     20246071, 14270845, 18882642, 18414137, 17001914, 17927970, 14378120    
     16346413, 15986647, 18068871, 21222147, 18143836, 16206997, 19168690    
     20235511, 18343490, 16613232, 19276791, 17722664, 20440643, 12928658    
     18952577, 18520351, 16249829, 18226143, 18265482, 18229842, 17172091    
     20676340, 17818075, 20091753, 18231837, 14373486, 17483479, 18120545    
     18729166, 13843841, 21225209, 17405302, 18709496, 18330979, 18744838    
     17087371, 20531190, 14525998, 18187697, 20598625, 14385860, 18348155    
     19479503, 12928592, 17516024, 18370031, 17764053, 19272663, 17551223    
     14671408, 18272135, 14207615, 17500165, 18875012, 18464784, 19558324    
     18848125, 19241857, 14851828, 17955615, 20315294, 14693336, 16284825    
     17352230, 20014326, 17238586, 17089344, 17405605, 17531342, 17159489    
     17640316, 13823394, 16543190, 17983675, 17598201, 17481314, 16281493    
     18346135, 15986311, 19601468, 17208793, 18700935, 18999857, 14076173    
     18428146, 18352845, 17435488, 18352846, 17391726, 17387779, 14777968    
     15851860, 16206882, 20141091, 20175174, 17305100, 15832129, 19885321    
     16901346, 17985714, 18536826, 17780903, 18752378, 18946768, 16876500    
     16875342, 17769597, 19955755, 16429265, 18336452, 17273003, 17209968    
     16988311, 20094984, 19319357, 17059927, 17046460, 18053631, 16867761    
     18774591, 21442094, 20235486, 19359787, 15869775, 19642566, 17447588    
     16798862, 15920201

Patch  21352635     : applied on Fri Dec 25 10:16:29 CST 2015   
Unique Patch ID:  19227862    
Patch description:  "Database Patch Set Update : 11.2.0.4.8 (21352635)"    
   Created on 1 Sep 2015, 07:49:44 hrs     
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:    
     17288409, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699    
     17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817    
     16992075, 17446237, 14015842, 19972569, 21538558, 20925795, 17449815    
     17375354, 19463897, 17982555, 17235750, 13866822, 18317531, 17478514    
     18235390, 14338435, 20803583, 13944971, 20142975, 17811789, 16929165    
     18704244, 20506706, 17546973, 20334344, 14054676, 17088068, 18264060    
     17346091, 17343514, 21538567, 19680952, 18471685, 19211724, 13951456    
     16315398, 18744139, 16850630, 19049453, 18673304, 17883081, 19915271    
     18641419, 18262334, 17006183, 16065166, 18277454, 16833527, 10136473    
     18051556, 17865671, 17852463, 18554871, 17853498, 18334586, 17588480    
     17551709, 19827973, 17842825, 17344412, 18828868, 17025461, 11883252    
     13609098, 17239687, 17602269, 19197175, 18316692, 17313525, 12611721    
     19544839, 18964939, 17600719, 18191164, 19393542, 17571306, 18482502    
     20777150, 19466309, 17040527, 17165204, 18098207, 16785708, 17174582    
     16180763, 17465741, 16777840, 12982566, 19463893, 12816846, 16875449    
     17237521, 19358317, 17811438, 17811447, 17945983, 18762750, 17184721    
     16912439, 18061914, 17282229, 18331850, 18202441, 17082359, 18723434    
     19554106, 14034426, 18339044, 19458377, 17752995, 20448824, 17891943    
     17258090, 17767676, 16668584, 18384391, 17040764, 17381384, 15913355    
     18356166, 14084247, 20506715, 13853126, 18203837, 14245531, 16043574    
     17848897, 17877323, 17468141, 17786518, 17912217, 17037130, 18155762    
     16956380, 17478145, 17394950, 18189036, 18641461, 18619917, 17027426    
     21352646, 16268425, 19584068, 18436307, 17265217, 17634921, 13498382    
     20004087, 17443671, 18000422, 20004021, 17571039, 21067387, 16344544    
     18009564, 14354737, 18135678, 18614015, 20441797, 18362222, 17835048    
     16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 17761775    
     16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359    
     18203835, 17297939, 17811456, 16731148, 17215560, 13829543, 14133975    
     17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634    
     18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614    
     17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317    
     19289642, 14764829, 18328509, 17622427, 16943711, 14368995, 17346671    
     18996843, 17783588, 16618694, 17672719, 18856999, 18783224, 17851160    
     17546761, 17798953, 18273830, 19972566, 16384983, 17726838, 17360606    
     13645875, 18199537, 16542886, 17889549, 14565184, 17071721, 20299015    
     17610798, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058    
     18641451, 12747740, 18430495, 17042658, 17016369, 14602788, 19972568    
     18508861, 19788842, 14657740, 17332800, 13837378, 19972564, 17186905    
     18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024    
     17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551    
     19854503, 19309466, 18681862, 18554763, 20558005, 17390160, 18456514    
     16306373, 13955826, 18139690, 17501491, 17299889, 17752121, 17889583    
     18673325, 18293054, 17242746, 17951233, 17649265, 18094246, 19615136    
     17011832, 16870214, 17477958, 18522509, 20631274, 16091637, 17323222    
     16595641, 16524926, 18228645, 18282562, 17596908, 17156148, 18031668    
     16494615, 17545847, 17614134, 13558557, 17341326, 17891946, 17716305    
     16392068, 19271443, 18092127, 18440047, 17614227, 14106803, 16903536    
     18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717    
     17570240, 17390431, 16863422, 18325460, 19727057, 16422541, 19972570    
     17267114, 18244962, 21538485, 18765602, 18203838, 16198143, 17246576    
     14829250, 17835627, 18247991, 14458214, 21051862, 16692232, 17786278    
     17227277, 16042673, 16314254, 16228604, 16837842, 17393683, 17787259    
     20331945, 20074391, 15861775, 16399083, 18018515, 18260550, 21051858    
     17036973, 16613964, 17080436, 16579084, 18384537, 18280813, 20296213    
     16901385, 15979965, 18441944, 16450169, 9756271, 17892268, 11733603    
     16285691, 17587063, 16538760, 18180390, 18193833, 21051833, 17238511    
     17824637, 16571443, 18306996, 14852021, 18674047, 17853456, 12364061

 

Rac system comprising of multiple nodes   
  Local node = db1    
  Remote node = db2

--------------------------------------------------------------------------------

OPatch succeeded.

$ /u01/app/11.2.0/grid/OPatch/opatch lspatches

21352642;ACFS Patch Set Update : 11.2.0.4.8 (21352642)   
21352649;OCW Patch Set Update : 11.2.0.4.8 (21352649)    
21352635;Database Patch Set Update : 11.2.0.4.8 (21352635)

OPatch succeeded.


五、打database PSU补丁

1. 准备工作

(1) Root用户下,重新给PSU补丁包赋予权限

cd /u01/software/;chown oracle:oinstall p21523375_112040_Linux-x86-64.zip


(2) oracle用户

su - oracle   
cd /u01/software/    
unzip p21523375_112040_Linux-x86-64.zip


2. Oracle用户下检查兼容性

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/21523375/21352635 -oh $ORACLE_HOME

----------------------------------------------------   
示例:    
Oracle Interim Patch Installer version 11.2.0.3.11    
Copyright (c) 2015, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/11.2.0/grid   
Central Inventory : /u01/app/oraInventory    
   from           : /u01/app/11.2.0/grid/oraInst.loc    
OPatch version    : 11.2.0.3.11    
OUI version       : 11.2.0.4.0    
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-12-18_16-21-46PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.   
OPatch succeeded.    
----------------------------------------------------


3. 开启自动打补丁 root用户依次节点1,节点2上人执行。

# /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto /u01/software/21523375 -oh /u01/app/oracle/product/11.2.0/db_1/ -ocmrf /u01/software/ocm.rsp

Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn 21523375 -oh /u01/app/oracle/product/11.2.0/db_1/ -ocmrf /u01/software/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-12-25_10-43-07.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:   
/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-12-25_10-43-07.report.log

2015-12-25 10:43:07: Starting Clusterware Patch Setup   
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...   
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch /u01/software/21523375/21352635  apply successful for home  /u01/app/oracle/product/11.2.0/db_1    
patch /u01/software/21523375/21352649/custom/server/21352649  apply successful for home  /u01/app/oracle/product/11.2.0/db_1

Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...   
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.


4. 检查升级情况

$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv    
                                                     
Patch  21352635     : applied on Fri Dec 18 17:38:24 CST 2015    
Unique Patch ID:  19227862    
Patch description:  "Database Patch Set Update : 11.2.0.4.8 (21352635)"    
   Created on 1 Sep 2015, 07:49:44 hrs     
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:    
...

$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches

21352635;Database Patch Set Update : 11.2.0.4.8 (21352635)   
21352642;ACFS Patch Set Update : 11.2.0.4.8 (21352642)    
21352649;OCW Patch Set Update : 11.2.0.4.8 (21352649)    
OPatch succeeded.

六、升级数据库数据字典

数据库启动,并加载修改SQL Files到数据库

$ sqlplus / as sysdba   
  
SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 25 11:26:02 2015

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, Real Application Clusters, Automatic Storage Management, OLAP,    
Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE   
--------------------    
READ WRITE

SQL>    
SQL>

SQL> @?/rdbms/admin/catbundle.sql psu apply

SQL>    
执行完后我们可以查到PSU更新信息:    
SQL>

set line 150   
col ACTION_TIME for a30    
col ACTION for a8    
col NAMESPACE for a8    
col VERSION for a10    
col BUNDLE_SERIES for a5    
col COMMENTS for a20    
select * from dba_registry_history;    
 

ACTION_TIME                    ACTION   NAMESPAC VERSION            ID BUNDL COMMENTS   
------------------------------ -------- -------- ---------- ---------- ----- --------------------    
24-AUG-13 12.03.45.119862 PM   APPLY    SERVER   11.2.0.4            0 PSU   Patchset 11.2.0.2.0    
22-DEC-15 03.53.27.330912 PM   APPLY    SERVER   11.2.0.4            0 PSU   Patchset 11.2.0.2.0    
25-DEC-15 11.54.19.486765 AM   APPLY    SERVER   11.2.0.4            8 PSU   PSU 11.2.0.4.8

3 rows selected.

SQL>    
小节:自动打还是比较顺利的,没有出现手动打出现的问题,在此记录。




本文转自 koumm 51CTO博客,原文链接:http://blog.51cto.com/koumm/1728426,如需转载请自行联系原作者


版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
Oracle数据库常用十一大操作指令(五)
DBA们每天会用到大大小小很多指令,本文对这些指令做了归纳总结,希望可以帮助大家查阅翻看。
41 0
Oracle数据库常用十一大操作指令(四)
DBA们每天会用到大大小小很多指令,本文对这些指令做了归纳总结,希望可以帮助大家查阅翻看。
44 0
Oracle数据库常用十一大操作指令(二)
DBA们每天会用到大大小小很多指令,本文对这些指令做了归纳总结,希望可以帮助大家查阅翻看。
50 0
Oracle数据库常用十一大操作指令(一)
DBA们每天会用到大大小小很多指令,本文对这些指令做了归纳总结,希望可以帮助大家查阅翻看。
67 0
oracle数据库命令总结——后篇
oracle数据库命令总结——后篇
41 0
Oracle 数据库性能优化3日实战(企业培训)
课程名称一: Oracle性能优化及调整 课程时长 1天 课程深度: 高级 上机实验: 10%-30% 授课对象: Oracle开发人员、Oracle数据库管理人员,应用程序开发人员 课程描述: 本课程讲述Oracle数据库物理层规划,系统性能的监控,数据库性能参数调整,统计信息的收集,使用自动化调试工具优化数据库,I/O子系统的配置与设计以及性能优化方法论等。
1753 0
oracle 判断列是否在数据库中存在
select count('列名') from cols  where table_name=upper('表名') and column_name=upper('列名')其存在与否的结果与oracle 判断某个表是否存在一样,都是返回1或者0
693 0
21114
文章
0
问答
文章排行榜
最热
最新
相关电子书
更多
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
冬季实战营第三期:MySQL数据库进阶实战
立即下载