linux os升级版本rac用停,rhel7下oracle11g rac升级psu补丁集

操作系统版本   : Redhat 6.5 x64

数据库版本     : Oracle 11.2.0.4 x64 RAC

Grid           : 11.2.0.4

Oracle database: 11.2.0.4

GI PSU : p21523375_112040_Linux-x86-64.zip

OPatch : p6880880_112000_Linux-x86-64.zip

该文档以redhat6下面写的，但是在rhel7上的oracle11g升级grid和database步骤完全一致，亲测可用。

更新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

打grid时候：更改为grid:oinstall

打oracle时候：更改为oracle：oinstall

开始升级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  注意停DB 不停CRS

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

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>