Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19)

Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19)
Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19) I. Preparations 1. database environment

Operating system version: RedHat 5.8x64
Database Version: Oracle 10.2.0.5 x64 RAC
Cluterware: 10.2.0.5
Oracle database: 10.2.0.5.0
PSU Patch: 10.2.0.5.19 (second half of 2015)

2. Prepare the content

OPatch: p6880880_102000_Linux-x86-64.zip
Db psu: p20299014_10205_Linux-x86-64.zip

Note: p20299014 patch Pack does not have CRS patch repair, so you can directly access the database PSU.

2. Update the OPatch version.

Note: The OPatch version is updated on the two nodes respectively.

1. Update OPatch from 10.2.0.4.9 to 10.2.0.5.1.

(1) upload to the/u01/app directory.
(2) Rename the original OPatch directory under the root user.

Mv/u01/app/oracle/product/10.2.0/db_1/OPatch/u01/app/oracle/product/10.2.0/db_1/OPatchBK

2. Replace the oracle directory OPatch

(1) root User
Cd/u01/app/
Chown oracle: oinstall p6880880_102000_Linux-x86-64.zip
Chown oracle: oinstall p20299014_10205_Linux-x86-64.zip

(2) oracle users

Su-oracle
Cd/u01/app/
Unzip p6880880_112000_Linux-x86-64.zip
Unzip p20299014_10205_Linux-x86-64.zip

(3) root User

Cd/u01/app/
Mv OPatch/u01/app/oracle/product/10.2.0/db_1/

(4) oracle user test

Su-oracle

/U01/app/oracle/product/10.2.0/db_1/OPatch/opatch version

Invoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1

3. Test compatibility

Su-oracle

$ ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir/u01/app/20299014-oh $ ORACLE_HOME

Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home:/u01/app/oracle/product/10.2.0/db_1
Central Inventory:/u01/app/oracle/oraInventory
From:/etc/oraInst. loc
OPatch version: 10.2.0.5.1
OUI version: 10.2.0.5.0
OUI location:/u01/app/oracle/product/10.2.0/db_1/oui
Log file location:/u01/app/oracle/product/10.2.0/db_1/export toollogs/opatch/opatch2016-03-29_10-38-44AM.log
Patch history file:/u01/app/oracle/product/10.2.0/db_1/export toollogs/opatch/opatch_history.txt
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.

4. Check whether the patch can be upgraded using rolling.

This method does not affect the application system. When a node is upgraded, no downtime is required for other nodes.
$/U01/app/oracle/product/10.2.0/db_1/OPatch/opatch query-all/u01/app/20299014/| grep rolling
Patch is a rolling patch: true

Iii. Patch database PSU

The upgrade depends on the environment. You can use the rolling upgrade method, or you can disable all of them before upgrading.

1. Upgrade Node 1 first and disable Node 1

[Oracle @ node1 ~] $ Srvctl stop instance-d orcl-I orcl1
[Oracle @ node1 ~] $ Srvctl stop listener-n node1
[Oracle @ node1 ~] $ Srvctl stop asm-n node1

2. Perform upgrade

Local upgrade method:
Cd/u01/app/
/U01/app/oracle/product/10.2.0/db_1/OPatch/opatch napply-local-oh/u01/app/oracle/product/10.2.0/db_1-id 20299014

For example, if rolling upgrade is not used, the local and remote commands are used together:
Cd/u01/app/20299014
/U01/app/oracle/product/10.2.0/db_1/OPatch/opatch apply

Create a local node, Start Node 1 Database, disable Node 2, patch Node 2, And Start Node 2.

3. Start Node 1.

[Oracle @ node1 ~] $ Srvctl start asm-n node1
[Oracle @ node1 ~] $ Srvctl start instance-d orcl-I orcl1
[Oracle @ node1 ~] $ Srvctl start listener-n node1

4. Disable Node 2

[Oracle @ node2 ~] $ Srvctl stop instance-d orcl-I orcl2
[Oracle @ node2 ~] $ Srvctl stop listener-n node2
[Oracle @ node2 ~] $ Srvctl stop asm-n node2

Continue to patch Node 2. After completion, Start Node 2.

[Oracle @ node2 ~] $ Srvctl start asm-n node2
[Oracle @ node2 ~] $ Srvctl start instance-d orcl-I orcl2
[Oracle @ node2 ~] $ Srvctl start listener-n node2

5. Check upgrade status for node 1 and node 2

$/U01/app/oracle/product/10.2.0/db_1/OPatch/opatch lsinv

Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.

Oracle Home:/u01/app/oracle/product/10.2.0/db_1
Central Inventory:/u01/app/oracle/oraInventory
From:/etc/oraInst. loc
OPatch version: 10.2.0.5.1
OUI version: 10.2.0.5.0
OUI location:/u01/app/oracle/product/10.2.0/db_1/oui
Log file location:/u01/app/oracle/product/10.2.0/db_1/export toollogs/opatch/opatch2016-03-29_16-10-36PM.log

Patch history file:/u01/app/oracle/product/10.2.0/db_1/export toollogs/opatch/opatch_history.txt

Lsinventory Output file location:/u01/app/oracle/product/10.2.0/db_1/export toollogs/opatch/lsinv/lsinventory2016-03-29_16-10-36PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2 ):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0
There are 2 products installed in this Oracle Home.

Interim patches (1 ):

Patch 20299014: applied on Tue Mar 29 16:03:40 CST 2016
Unique Patch ID: 19074368
Created on 24 Jun 2015, 02:35:37 hrs PST8PDT
Bugs fixed:
20074391,135 96521, 17088068,886 5718, 17201047,134 89660, 9020537
8664189,100 91698, 14275629,199 09862, 17832122,178 32123, 17832124
17832125,166 19894, 8822531,101 39235, 20299014,835 0262, 7119382
19274521,136 32738, 11724962,203 31945, 19274523,932 16961614
16961615,137 75862, 16961616,169 61617, 19006757,169 61618, 16961619
18221699,939 9589, 14841459,967 2816, 9499302,202 99021, 9659614,136 32743
9949948,142 20725, 8882576,761 2454, 7111619,971 1859, 9714832,127 80098
13561951,146 65116, 11066597,167 03112, 19231857,177 21717, 9713537
14459552,194 58377, 13737773,137 37775, 16212405,180 96714, 16338983
14390396,102 49537, 19006849,711 5910, 8354642,760 2341, 14076510
12565867,159 87029, 16462834,186 41419, 11693109,140 23636, 9024850
8394351,822 4558, 17082365,141 49782, 9109487,148 42658, 9171933
10173237,168 17117, 10068982,103 06945, 8666117,117 25006, 10214450
14205448,170 82371, 9767674,163 06019, 9323583,972 6739, 16279211
8412426,103 26338, 10165083,665 1220, 9145204,135 54409, 11076894
19854436,118 93577, 17865671,167 46190, 14492313,144 92314, 11814891
14492315,144 92316, 16742123,210 16864562,145, 12419258
16056270,100 10310, 18139709,968 9310, 9390484,210 21048091
9963497,125 51700, 16362358,125 51701, 17465584,125 51702, 12551703
12551704,100 76669, 12551705,162 70946, 12551706,125 51707, 6076890
9308296,125 51708, 14258925,128 80299, 17381900,186 41451, 17381901
17381902,117 90175, 12796518,977 2888, 8650138,170 56813, 14469008
12551710,100 92858, 7519406,982 1321, 8771916,133 49665, 7509714
10159846,132 57247, 18031728,186 41461, 16372203,117 92865, 19007266
19309466,163 09604, 16309605,163 09606, 18522511,896 6823, 11674645
17551414,158 77957, 15877958,702 6523, 15877959,177 16305, 13503598
18767250,915 0282, 9448311,103 27179, 14774730,191 53980, 9735237
9952230,158 77960, 15877961,158 77962, 15877963,866 0422, 18221700
18221701,162 79401, 14546673,141 05702, 14105703,141 05704, 13483152
14269955,172 85560, 12925532,127 48240, 9694101,128 62186, 12862187
14727319,821 1733, 9586877,954 8269, 6694396,771 0224, 9337325,118 56395
10157402,159 50541, 19699191,640 2302, 10327190,102 69717, 13015379
10017048,854 6356, 13561750,882 1114, 9770451,936 0157, 8488233,101 32870
4180770,953 2911, 7361418,615 7713, 9184754,854 4696, 17850678,827 7300
13343467,163 listen 48, 13791364,124 19392, 10208905,202 36416, 20236417
20236418,202 36419, 7450366,897 0313, 6690853,601 1045, 10162036,102 48542
9469117,133 59623, 9952270,133 43471, 9842573,173 81899, 12710774
20558005,103 24526, 9322219,863 6407, 12828105,192 89133, 13736501
9824435,137 36502, 18681879,137 36503, 13736504,137 36505, 13736506
9032322,137 36507, 14035825,197 69505, 11858315,140 40433, 13916709
12827745,140 38805, 19567242,167 21594, 13923855,195 67243, 8528171
9072105,195 67244, 11737047

Rac system comprising of multiple nodes
Local node = node1
Remote node = node2
--------------------------------------------------------------------------------
OPatch succeeded.

4. Upgrade database data dictionary 1. When the database is started and the database is started, you can directly execute the script without starting the database.

$ Sqlplus/as sysdba

Cd $ ORACLE_HOME/rdbms/admin
Sqlplus/nolog
SQL> CONNECT/AS SYSDBA
SQL> STARTUP
SQL> @ catbundle. SQL psu apply
SQL> @ utlrp. SQL
SQL>

2. After the execution, we can find the PSU update information:

Set line 150
Col ACTION_TIME for a30
Col ACTION for a10
Col NAMESPACE for a8
Col VERSION for a18
Col BUNDLE_SERIES for a5
Col COMMENTS for a20
Select * from dba_registry_history;
 

ACTION_TIME ACTION NAMESPAC VERSION ID BUNDL COMMENTS
-----------------------------------------------------------------------------------------------------
29-MAR-16 04.15.04.729398 PM jvmpsu. SQL SERVER 10.2.0.5.2OJVMBP 0 RAN jvmpsu. SQL
29-MAR-16 04.15.52.723026 PM jvmpsu. SQL SERVER 10.2.0.5.2OJVMBP 0 RAN jvmpsu. SQL
29-MAR-16 04.24.14.043257 pm apply server 10.2.0.5 19 PSU 10.2.0.5.19

3 rows selected.
SQL>