Oracle 11.2.0.4 PSU Implementation Documentation

Last Update:2017-03-25 Source: Internet

Author: User

Tags documentation file permissions

Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

1. This service detailed process 1.1 Background Overview

Upgrade database pus, database environment, operating system version: RedHat5.8 x64, database version Oracle 11.2.0.4 x64 RAC

Grid:11.2.0.4,oracle database:11.2.0.4

1.2 Pre-Installation Preparation

-rw-r--r--1 Oracle oinstall 93376160 Mar 11:43 p21948347_112040_linux-x86-64.zip

-rw-r--r--1 Oracle oinstall 687630001 Mar 11:45 p22191577_112040_linux-x86-64.zip

-rw-r--r--1 Oracle oinstall 52733900 Mar 11:45 p6880880_112000_linux-x86-64.zip

(1) Opatch:p6880880_112000_linux-x86-64.zip

(2) GI Psu:p22191577_112040_linux-x86-64.zip

(3) DB Psu:p21948347_112040_linux-x86-64.zip

Note: GI PSU includes DB PSU and CPU, Opatch version:11.2.0.3.12

GI PSU After decompression file description:

Drwxr-xr-x 5 Oracle Oinstall 4096 Nov 16:55 21948355

Drwxr-xr-x 5 Oracle Oinstall 4096 Dec 15:42 21948348

Drwxrwxr-x Oracle Oinstall 4096 Dec 19:33 21948347

-rw-rw-r--1 Oracle oinstall 68836 DEC 05:10 patchsearch.xml

-rw-r--r--1 Oracle Oinstall 549 DEC 13:30 bundle.xml

-rw-r--r--1 Oracle Oinstall 0 DEC 13:31 README.txt

-rw-r--r--1 Oracle oinstall 62889 Jan 23:03 readme.html

(1) 21948355 for ACFS Patch Set

(2) 21948348 for OCW Patch Set

(3) 21948347 for Database Patch Set

1.3 Upgrade Opatch

Drwxr-x---oracle oinstall 4096 opatch

-rw-r--r--1 Oracle oinstall 52733900 Mar 11:45 p6880880_112000_linux-x86-64.zip

After decompression, copy to two nodes $grid_home, $ORACLE _home

Two node grid user Opatch Authentication

[Email protected] opatch]$./opatch version

Opatch version:11.2.0.3.12

Opatch succeeded.

Two nodes Oracle User Opatch authentication

[Email protected] opatch]$./opatch version

Opatch version:11.2.0.3.12

Opatch succeeded.

Note: All two nodes grid,oracle under Opatch need to verify that the upgrade was successful.

1.4 Upgrade GI PSU prep work

(1) Node 1 operation, close CRS

EXECUTE AS Root: Switch to $grid_home directory

/u01/11.2.0/grid/bin/crsctl Stop CRS

(2) Root user execution

EXECUTE AS Root: Switch to $grid_home directory

/u01/11.2.0/grid/crs/install/rootcrs.pl-unlock

(3) Node 2, repeat the above two steps

(4) Node 1, Node 2 operation, test compatibility under grid user

Su-grid

$GRID _home/opatch/opatch prereq Checkconflictagainstohwithdetail-phbasedir/home/grid/325/22191577/21948347-oh $ Grid_home

$GRID _home/opatch/opatch prereq Checkconflictagainstohwithdetail-phbasedir/home/grid/325/22191577/21948348-oh $ Grid_home

$GRID _home/opatch/opatch prereq Checkconflictagainstohwithdetail-phbasedir/home/grid/325/22191577/21948355-oh $ Grid_home

The output results are as follows:

Oracle Interim Patch Installer version 11.2.0.3.12

Prereq session

Oracle Home:/u01/11.2.0/grid

Central Inventory:/u01/app/orainventory

From:/u01/11.2.0/grid/orainst.loc

Opatch version:11.2.0.3.12

OUI version:11.2.0.4.0

Log File Location:/u01/11.2.0/grid/cfgtoollogs/opatch/opatch2016-03-25_13-37-48pm_1.log

Invoking Prereq "Checkconflictagainstohwithdetail"

Prereq "Checkconflictagainstohwithdetail" passed.

1.5 start upgrading GI PSU

(1) Node 1 operation, to the GI HOME patching, to grid user execution:/u01/11.2.0/grid/for $grid_home directory

Su-grid

/u01/11.2.0/grid/opatch/opatch Napply-oh $GRID _home-local/home/grid/325/22191577/21948347

/u01/11.2.0/grid/opatch/opatch Napply-oh $GRID _home-local/home/grid/325/22191577/21948348

/u01/11.2.0/grid/opatch/opatch Napply-oh $GRID _home-local/home/grid/325/22191577/21948355

Press three y during upgrade

(2) Node 1 execution complete, execution Node 2

(3) Two nodes complete verification

[Email protected] opatch]$/opatch lspatches

21948355; ACFS Patch Set update:11.2.0.4.160119 (21948355)

21948348;OCW Patch Set update:11.2.0.4.160119 (21948348)

21948347;database Patch Set update:11.2.0.4.160119 (21948347)

Opatch succeeded.

[Email protected] opatch]$/opatch LSINV

Oracle Interim Patch Installer version 11.2.0.3.12

Oracle Home:/u01/11.2.0/grid

Central Inventory:/u01/app/orainventory

From:/u01/11.2.0/grid/orainst.loc

Opatch version:11.2.0.3.12

OUI version:11.2.0.4.0

Log File Location:/u01/11.2.0/grid/cfgtoollogs/opatch/opatch2016-03-25_16-43-33pm_1.log

Lsinventory Output file Location:/u01/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2016-03-25_16-43-33pm.txt

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

Local Machine Information::

Hostname:node1-11gr2

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 is 1 products installed in this Oracle Home.

Interim Patches (3):

Patch 21948355 : Applied on Fri Mar 13:55:28 HKT 2016

Unique Patch id:19576928

Patch Description: "ACFS patch Set update:11.2.0.4.160119 (21948355)"

Created on Nov, 00:55:35 hrs PST8PDT

Bugs fixed:

21369858, 16318126, 19690653, 17503605, 17203009, 17359415, 20140148

17611362, 17164243, 19053182, 17696547, 17488768, 18168684, 21519796

18143006, 21208140, 17428148, 17070158, 20438706, 17510275, 17172303

18610307, 17376318, 17721778, 17699423, 18915417, 18155334, 18321597

19919907, 18185024, 17636008, 17363999, 20681968, 17475946

Patch 21948348 : Applied on Fri Mar 13:52:44 HKT 2016

Unique Patch id:19576928

Patch Description: "OCW patch Set update:11.2.0.4.160119 (21948348)"

Created on Dec, 23:42:28 hrs PST8PDT

Bugs fixed:

19270660, 18328800, 18508710, 18691572, 20038451, 21251192, 21232394

20365005, 17750548, 17387214, 17617807, 14497275, 20219458, 17733927

18180541, 18962892, 17292250, 17378618, 16759171, 20110156, 17843489

Patch 21948347 : Applied on Fri Mar 13:47:49 HKT 2016

Unique Patch id:19564435

Patch Description: "Database Patch Set update:11.2.0.4.160119 (21948347)"

Created on Dec, 03:31:48 hrs PST8PDT

Sub-patch 21352635; "Database Patch Set update:11.2.0.4.8 (21352635)"

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

RAC system comprising of multiple nodes

Local node = NODE1-11GR2

Remote node = NODE2-11GR2

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

Opatch succeeded.

1.6 Upgrade RDBMS PSU

(1) Execute Pre Script

Su–oracle

Execute the pre script for the DB component to be executed by the Oracle User:

/home/oracle/325/22191577/21948348/custom/scripts/prepatch.sh-dbhome $ORACLE _home

/home/oracle/325/22191577/21948348/custom/scripts/prepatch.sh completed successfully.

(2) Apply Database patches

Apply the DB patch to Oracle User execution:

Cd/u01/app/oracle/product/11.2.0/db_1/opatch

./opatch Napply-oh $ORACLE _home-local/home/oracle/325/22191577/21948348/custom/server/21948348

./opatch Napply-oh $ORACLE _home-local/home/oracle/325/22191577/21948347

(3) Execute Post Script

Run the DB component Post script to perform with the Oracle User:

/home/oracle/325/22191577/21948348/custom/scripts/postpatch.sh -dbhome $ORACLE _home

Reading/u01/oracle/product/11.2.0/db_1/install/params.ora.

Parsing File/u01/oracle/product/11.2.0/db_1/bin/racgwrap

Parsing File/u01/oracle/product/11.2.0/db_1/bin/srvctl

Parsing File/u01/oracle/product/11.2.0/db_1/bin/srvconfig

Parsing File/u01/oracle/product/11.2.0/db_1/bin/cluvfy

Verifying File/u01/oracle/product/11.2.0/db_1/bin/racgwrap

Verifying File/u01/oracle/product/11.2.0/db_1/bin/srvctl

Verifying File/u01/oracle/product/11.2.0/db_1/bin/srvconfig

Verifying File/u01/oracle/product/11.2.0/db_1/bin/cluvfy

reapplying file Permissions On/u01/oracle/product/11.2.0/db_1/bin/racgwrap

reapplying file Permissions On/u01/oracle/product/11.2.0/db_1/bin/srvctl

reapplying file Permissions On/u01/oracle/product/11.2.0/db_1/bin/srvconfig

reapplying file Permissions On/u01/oracle/product/11.2.0/db_1/bin/cluvfy

reapplying file Permissions On/u01/oracle/product/11.2.0/db_1/bin/diskmon.bin

reapplying file Permissions On/u01/oracle/product/11.2.0/db_1/bin/lsnodes

reapplying file Permissions On/u01/oracle/product/11.2.0/db_1/bin/osdbagrp

reapplying file Permissions On/u01/oracle/product/11.2.0/db_1/bin/rawutl

reapplying file Permissions On/u01/oracle/product/11.2.0/db_1/srvm/admin/ractrans

reapplying file Permissions On/u01/oracle/product/11.2.0/db_1/srvm/admin/getcrshome

reapplying file Permissions ON/U01/ORACLE/PRODUCT/11.2.0/DB_1/BIN/GNSD

reapplying file Permissions on/u01/oracle/product/11.2.0/db_1/bin/crsdiag.pl

Postpatch completed successfully

(4) Add RDBMS and start CRS

Su–root

/u01/11.2.0/grid/rdbms/install/rootadd_rdbms.sh

/u01/11.2.0/grid/crs/install/rootcrs.pl-patch

Where:/u01/11.2.0/grid is the $grid_home directory

(5) Node 2 Repeat the above steps

(6) Two nodes verify the success of the DB upgrade

[Email protected] opatch]$/opatch lspatches

21948347;database Patch Set update:11.2.0.4.160119 (21948347)

21948348;OCW Patch Set update:11.2.0.4.160119 (21948348)

Opatch succeeded.

[Email protected] opatch]$/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.12

Oracle Home:/u01/app/oracle/product/11.2.0/db_1

Central Inventory:/u01/app/orainventory

From:/u01/app/oracle/product/11.2.0/db_1/orainst.loc

Opatch version:11.2.0.3.12

OUI version:11.2.0.4.0

Log File Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-03-25_17-01-51pm_1.log

Lsinventory Output file Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/ Lsinventory2016-03-25_17-01-51pm.txt

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

Local Machine Information::

Hostname:node1-11gr2

ARU Platform id:226

ARU platform Description:: Linux x86-64

Installed top-level products (1):

Oracle Database 11g 11.2.0.4.0

There is 1 products installed in this Oracle Home.

Interim Patches (2):

Patch 21948347:applied on Fri Mar 14:51:30 HKT 2016