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用户测试

/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

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

三、分别在节点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

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

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

Patch description: "OCW Patch Set Update : 11.2.0.4.8 (21352649)"

Created on 2 Sep 2015, 23:43:49 hrs PST8PDT

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)"

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

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

$ /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)

五、打database PSU补丁

1. 准备工作

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

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

2. Oracle用户下检查兼容性

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

示例：

PREREQ session

Oracle Home : /u01/app/11.2.0/grid

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

/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

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

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

Patch 21352635 : applied on Fri Dec 18 17:38:24 CST 2015

...

$ /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)

六、升级数据库数据字典

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

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 25 11:26:02 2015

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> @?/rdbms/admin/catbundle.sql psu apply

执行完后我们可以查到PSU更新信息：

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;

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

一、准备工作

1，数据库环境

2，准备内容

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

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

2. grid目录OPatch替换

3. oracle目录OPatch替换

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

四、开始升级GI PSU软件包

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

2. 测试兼容性

3、开始升级GRID

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

4. 检查升级情况

五、打database PSU补丁

1. 准备工作

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

六、升级数据库数据字典

继续阅读

快速删除ORACLE重复记录

oracle海量数据表删除重复记录

[引]在Oracle中如何利用Rowid查找和删除表中的重复记录

oralce与mysql中，如何删除重复记录

查询表中重复记录

ORACLE 表压缩

oracle中的start with connect by用法

使用JDeveloper Remote debug PLSQL程序

LoadRunner 的多种Vuser类型

性能测试（并发负载压力）测试分析－简要篇

赋予用户dba权限--解释以上：

Oracle的基本操作

为什么要选择UniDAC

windows不能在本地计算机上运行oracleDbConsoleorcl

SQL语言基础：常用的数据查询语句

Oracle 批量查询传入List 返回List