Oracle 10g R2 RAC手動打更新檔PSU(10.2.0.5.19)

一、準備工作

1，資料庫環境

作業系統版本 : Redhat 5.8 x64

資料庫版本 : Oracle 10.2.0.5 x64 RAC

Cluterware : 10.2.0.5

Oracle database: 10.2.0.5.0

PSU更新檔 : 10.2.0.5.19 （2015年下半年）

2，準備内容

OPatch : p6880880_102000_Linux-x86-64.zip

DB PSU : p20299014_10205_Linux-x86-64.zip

說明：p20299014更新檔包無CRS的更新檔修複，是以直接打資料庫PSU即可。

二、更新OPatch版本，必須要更新

說明：分别在兩個節點更新OPatch版本。

1. 更新OPatch版本，需要從10.2.0.4.9更新到10.2.0.5.1，OPatch直接壓縮替換就可以了。

(1) 上傳p6880880_112000_Linux-x86-64.zip,p20299014_10205_Linux-x86-64.zip到/u01/app目錄下。

(2) root使用者下将原OPatch目錄改名。

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

2. oracle目錄OPatch替換

(1) root使用者

cd /u01/app/

chown oracle:oinstall p6880880_102000_Linux-x86-64.zip

chown oracle:oinstall p20299014_10205_Linux-x86-64.zip

(2) oracle使用者

su - oracle

cd /u01/app/

unzip p6880880_112000_Linux-x86-64.zip

unzip p20299014_10205_Linux-x86-64.zip

(3) root使用者

cd /u01/app/

mv OPatch /u01/app/oracle/product/10.2.0/db_1/

(4) oracle使用者測試

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. 測試相容性

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

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/cfgtoollogs/opatch/opatch2016-03-29_10-38-44AM.log

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

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

4. 檢視該更新檔能否采用rolling方式更新

采用這種方法對應用系統沒有影響的,更新一個節點的同時,其他節點不需要停機.

$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatch query -all /u01/app/20299014/ |grep rolling

Patch is a rolling patch: true

三、打database PSU更新檔

更新看各自的環境，可以有用滾動更新的方式，也可以采用全關閉了再更新。

1. 先更新節點1，關閉節點1

[[email protected] ~]$ srvctl stop instance -d orcl -i orcl1

[[email protected] ~]$ srvctl stop listener -n node1

[[email protected] ~]$ srvctl stop asm -n node1

2. 執行更新

本地更新方式：

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

例：如果不采用滾動更新的話，本地與遠端一起打的方式：

cd /u01/app/20299014

/u01/app/oracle/product/10.2.0/db_1/OPatch/opatch apply

先打本地節點，啟動節點1資料庫，再關閉節點2，再打節點2更新檔，最後啟動節點2。

3. 節點1啟動。

[[email protected] ~]$ srvctl start asm -n node1

[[email protected] ~]$ srvctl start instance -d orcl -i orcl1

[[email protected] ~]$ srvctl start listener -n node1

4. 關閉節點2

[[email protected] ~]$ srvctl stop instance -d orcl -i orcl2

[[email protected] ~]$ srvctl stop listener -n node2

[[email protected] ~]$ srvctl stop asm -n node2

繼續打節點2更新檔，完畢後，再啟動節點2.

[[email protected] ~]$ srvctl start asm -n node2

[[email protected] ~]$ srvctl start instance -d orcl -i orcl2

[[email protected] ~]$ srvctl start listener -n node2

5. 節點1，節點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

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/cfgtoollogs/opatch/opatch2016-03-29_16-10-36PM.log

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

Lsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/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, 13596521, 17088068, 8865718, 17201047, 13489660, 9020537

8664189, 10091698, 14275629, 19909862, 17832122, 17832123, 17832124

17832125, 16619894, 8822531, 10139235, 20299014, 8350262, 7119382

19274521, 13632738, 11724962, 20331945, 19274523, 9320130, 16961614

16961615, 13775862, 16961616, 16961617, 19006757, 16961618, 16961619

18221699, 9399589, 14841459, 9672816, 9499302, 20299021, 9659614, 13632743

9949948, 14220725, 8882576, 7612454, 7111619, 9711859, 9714832, 12780098

13561951, 14665116, 11066597, 16703112, 19231857, 17721717, 9713537

14459552, 19458377, 13737773, 13737775, 16212405, 18096714, 16338983

14390396, 10249537, 19006849, 7115910, 8354642, 7602341, 14076510

12565867, 15987029, 16462834, 18641419, 11693109, 14023636, 9024850

8394351, 8224558, 17082365, 14149782, 9109487, 14841558, 9171933

10173237, 16817117, 10068982, 10306945, 8666117, 11725006, 10214450

14205448, 17082371, 9767674, 16306019, 9323583, 9726739, 16279211

8412426, 10326338, 10165083, 6651220, 9145204, 13554409, 11076894

19854436, 11893577, 17865671, 16746190, 14492313, 14492314, 11814891

14492315, 14492316, 16742123, 21048089, 16864562, 14546638, 12419258

16056270, 10010310, 18139709, 9689310, 9390484, 21048090, 21048091

9963497, 12551700, 16362358, 12551701, 17465584, 12551702, 12551703

12551704, 10076669, 12551705, 16270946, 12551706, 12551707, 6076890

9308296, 12551708, 14258925, 12880299, 17381900, 18641451, 17381901

17381902, 11790175, 12796518, 9772888, 8650138, 17056813, 14469008

12551710, 10092858, 7519406, 9821321, 8771916, 13349665, 7509714

10159846, 13257247, 18031728, 18641461, 16372203, 11792865, 19007266

19309466, 16309604, 16309605, 16309606, 18522511, 8966823, 11674645

17551414, 15877957, 15877958, 7026523, 15877959, 17716305, 13503598

18767250, 9150282, 9448311, 10327179, 14774730, 19153980, 9735237

9952230, 15877960, 15877961, 15877962, 15877963, 8660422, 18221700

18221701, 16279401, 14546673, 14105702, 14105703, 14105704, 13483152

14269955, 17285560, 12925532, 12748240, 9694101, 12862186, 12862187

14727319, 8211733, 9586877, 9548269, 6694396, 7710224, 9337325, 11856395

10157402, 15950541, 19699191, 6402302, 10327190, 10269717, 13015379

10017048, 8546356, 13561750, 8821114, 9770451, 9360157, 8488233, 10132870

4180770, 9532911, 7361418, 6157713, 9184754, 8544696, 17850678, 8277300

13343467, 16382448, 13791364, 12419392, 10208905, 20236416, 20236417

20236418, 20236419, 7450366, 8970313, 6690853, 6011045, 10162036, 10248542

9469117, 13359623, 9952270, 13343471, 9842573, 17381899, 12710774

20558005, 10324526, 9322219, 8636407, 12828105, 19289642, 13736501

9824435, 13736502, 18681879, 13736503, 13736504, 13736505, 13736506

9032322, 13736507, 14035825, 19769505, 11858315, 14040433, 13916709

12827745, 14038805, 19567242, 16721594, 13923855, 19567243, 8528171

9072105, 19567244, 11737047

Rac system comprising of multiple nodes

Local node = node1

Remote node = node2

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

OPatch succeeded.

四、更新資料庫資料字典

1，資料庫啟動，資料庫已經啟動的情況下,不需要再啟動資料庫，直接執行腳本即可。

$ 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. 執行完後我們可以查到PSU更新資訊：

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 PSU 10.2.0.5.19

3 rows selected.

SQL>

本文轉自 koumm 51CTO部落格，原文連結：http://blog.51cto.com/koumm/1762862，如需轉載請自行聯系原作者

Oracle 10g R2 RAC手動打更新檔PSU(10.2.0.5.19)

一、準備工作

1，資料庫環境

2，準備内容

二、更新OPatch版本，必須要更新

1. 更新OPatch版本，需要從10.2.0.4.9更新到10.2.0.5.1，OPatch直接壓縮替換就可以了。

2. oracle目錄OPatch替換

3. 測試相容性

4. 檢視該更新檔能否采用rolling方式更新

三、打database PSU更新檔

1. 先更新節點1，關閉節點1

2. 執行更新

3. 節點1啟動。

4. 關閉節點2

5. 節點1，節點2檢查更新情況

四、更新資料庫資料字典

1，資料庫啟動，資料庫已經啟動的情況下,不需要再啟動資料庫，直接執行腳本即可。

2. 執行完後我們可以查到PSU更新資訊：

繼續閱讀

ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_4188_1.MYI' (Errcode: 28)

艱難安裝LDAP,SSL認證

《Linux指令行與Shell腳本程式設計大全第2版.布盧姆》pdf

MySQL的4種隔離級别？出現問題

ACS基本配置-權限等級管理

XX系統實施過程問題總結

無元件上傳圖檔到資料庫中，最完整解決方案

【MySQL資料庫】資料庫索引事務1.索引2.事務

傳說FreeBSD等比Linux更穩定，更“健壯”

無人機--飛控科普

27 Best Free Eclipse Plug-ins for Java Developer to be ProductiveCode Quality PluginsText Editor PluginsDependency ManagementVersion Control Integration PluginsFramework Development Continuous Integration Related PluginsOther Utility Plugins

neo4j之cypher使用文檔

NOSQL安全攻擊

mybatis_入門程式Mybatis入門

登入plsql 報錯 the account is locked --使用者被鎖

SequoiaDB巨杉資料庫C++驅動概述