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