Oracle 11.2.0.4 PSU Implementation Documentation

Source: Internet
Author: User
Tags documentation file permissions

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

Copyright (c), Oracle Corporation. All rights reserved.

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

Copyright (c), Oracle Corporation. All rights reserved.

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.

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

Copyright (c), Oracle Corporation. All rights reserved.

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

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

Bugs fixed:17288409, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699 17922254, 17754782, 16934803, 13364795, 17 311728, 17441661, 17284817

Patch 21948348:applied on Fri Mar 14:33:42 HKT 2016

Unique Patch id:19576928

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

Created on Dec, 23:42:11 hrs PST8PDT

Bugs fixed:19270660, 18328800, 18508710, 18691572, 20038451, 21251192, 21232394

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

RAC system comprising of multiple nodes

Local node = NODE1-11GR2

Remote node = NODE2-11GR2

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

Opatch succeeded.

1.7 Upgrade Data Dictionary

For an existing DB to perform an upgrade dictionary operation, the Oracle user executes and executes on a single node.

CD $ORACLE _home/rdbms/admin

Sqlplus/nolog

Sql> Connect/as SYSDBA

Sql> STARTUP

sql> @ Catbundle.sql PSU apply

Sql> QUIT

1.8 Compiling Invalid objects

Execute UTLRP script and restart DB Variant invalid object

sql> @/RDBMS/ADMIN/UTLRP

1.9 Restart database, two node execution

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

/u01/11.2.0/grid/bin/crsctl start CRS

1.10 Verify that the data dictionary upgrade is successful

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

16-nov-15 08.01.16.766246 PM APPLY SERVER 11.2.0.4 0 PSU patchset 11.2.0.2.0

25-mar-16 03.36.13.857424 PM APPLY SERVER 11.2.0.4 160119 PSU PSU 11.2.0.4.160119

1.11 Restart the application 1.12 Reference Documents

Oracle Grid Infrastructure 11.2.0.4.x Patch Set Update supplemental README (document ID 1641136.1)

Oracle 11.2.0.4 PSU Implementation Documentation

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.