oracle gi脚本,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

2，准备内容

GI PSU : p21523375_112040_Linux-x86-64.zip

OPatch : p6880880_112000_Linux-x86-64.zip

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

说明：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>

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