【opatch打補丁】oracle10.2.0.5.0升級10.2.0.5.9 for linux
任務：oracle 10.2.0.5.0 打補丁升級為 oracle 10.2.0.5.9
環境：Oracle Linux Server release 6.4
一、 檢查OPatch軟體及資料庫版本資訊
[oracle@test OPatch]$ ./opatch version
Invoking OPatch 10.2.0.4.9
OPatch Version: 10.2.0.4.9
OPatch succeeded.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 – Production
[oracle@test ~]$ opatch lsinventory
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /10g/app/oracle/product/10.2.0/dbhome_1
Central Inventory : /12c/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.9
OUI version : 10.2.0.5.0
OUI location : /10g/app/oracle/product/10.2.0/dbhome_1/oui
Log file location : /10g/app/oracle/product/10.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-03-07_14-24-02PM.log
Patch history file: /10g/app/oracle/product/10.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /10g/app/oracle/product/10.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-03-07_14-24-02PM.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.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@test ~]$
二、 將下載的OPatch與PSU包拷貝到伺服器上，並且解壓縮
[oracle@test setup]$ unzip p6880880_102000_LINUX.zip
Archive: p6880880_102000_LINUX.zip
creating: OPatch/
creating: OPatch/ocm/
extracting: OPatch/ocm/ocm.zip
creating: OPatch/ocm/lib/
inflating: OPatch/ocm/lib/osdt_jce.jar
inflating: OPatch/ocm/lib/osdt_core3.jar
inflating: OPatch/ocm/lib/emocmclnt-14.jar
inflating: OPatch/ocm/lib/emocmutl.jar
[oracle@test setup]$ cd $ORACLE_HOME
[oracle@test dbhome_1]$ mv OPatch OPatch_old ----將舊的OPatch檔案目錄更名
[oracle@test dbhome_1]$ cd ~/setup
[oracle@test setup]$ ls
p6880880_102000_LINUX.zip OPatch p14275629_10205_Linux-x86-64.zip
[oracle@test setup]$ mv OPatch $ORACLE_HOME ----將新的OPatch資料夾拷貝到源路徑
[oracle@test setup]$ opatch version ----檢視OPatch軟體版本資訊，要求變更為10.2.0.X版本
Invoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1
OPatch succeeded.
[oracle@test setup]$ unzip p14275629_10205_Linux-x86-64.zip
Archive: p14275629_10205_Linux-x86-64.zip
creating: 14275629/
inflating: 14275629/README.html
creating: 14275629/files/
creating: 14275629/files/dv/
creating: 14275629/files/dv/jlib/
creating: 14275629/files/dv/jlib/dva_webapp.ear/
creating: 14275629/files/dv/jlib/dva_webapp.ear/dva_webapp.war/
creating: 14275629/files/dv/jlib/dva_webapp.ear/dva_webapp.war/WEB-INF/
creating: 14275629/files/dv/jlib/dva_webapp.ear/dva_webapp.war/WEB-INF/lib/
creating: 14275629/files/dv/jlib/dva_webapp.ear/dva_webapp.war/WEB-INF/lib/dva_webapp.jar/
……………………………….略
[oracle@test setup]$ ls
14275629 p14275629_10205_Linux-x86-64.zip p6880880_102000_LINUX.zip
[oracle@test setup]$ cd 14275629
三、 關閉資料庫進行軟體備份
[oracle@test 14275629]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Mar 7 14:41:42 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@test 14275629]$ cd $ORACLE_BASE
[oracle@test oracle]$ ls
admin flash_recovery_area oradata product
[oracle@test oracle]$ cd product/10.2.0/
[oracle@test 10.2.0]$ ls
dbhome_1
[oracle@test 10.2.0]$ tar -cvf dbhome_1.tar *
dbhome_1/
dbhome_1/rdbms/
dbhome_1/rdbms/public/
dbhome_1/rdbms/public/occiData.h
dbhome_1/rdbms/public/ocidem.h
dbhome_1/rdbms/public/ocidef.h
………………………………略
[oracle@test 10.2.0]$ ll
total 2727268
drwxr-x---. 65 oracle oinstall 4096 Mar 7 14:22 dbhome_1
-rw-r--r--. 1 oracle oinstall 2792714240 Mar 7 14:57 dbhome_1.tar
四、 安裝資料庫補丁
[oracle@test ~]$ cd setup
[oracle@test setup]$ ls
14275629 p14275629_10205_Linux-x86-64.zip p6880880_102000_LINUX.zip
[oracle@test setup]$ cd 14275629/
[oracle@test 14275629]$ opatch apply
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 : /10g/app/oracle/product/10.2.0/dbhome_1
Central Inventory : /12c/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /10g/app/oracle/product/10.2.0/dbhome_1/oui
Log file location : /10g/app/oracle/product/10.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-03-07_15-51-57PM.log
Patch history file: /10g/app/oracle/product/10.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '14275629' to OH '/10g/app/oracle/product/10.2.0/dbhome_1'
Running prerequisite checks...
Patch 14275629: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.5.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.5.0 ] , [ oracle.network.cman, 10.2.0.5.0 ]
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/10g/app/oracle/product/10.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '14275629' for restore. This might take a while...
Backing up files affected by the patch '14275629' for rollback. This might take a while...
Execution of 'sh /home/oracle/setup/14275629/custom/scripts/pre -apply 14275629 ':
Return Code = 0
Patching component oracle.rdbms, 10.2.0.5.0...
Updating archive file "/10g/app/oracle/product/10.2.0/dbhome_1/lib/libserver10.a" with "lib/libserver10.a/kcbl.o"
……………………….略
Updating archive file "/10g/app/oracle/product/10.2.0/dbhome_1/lib/libordsdo10.a" with "lib/libordsdo10.a/mdopp.o"
Patching component oracle.network.listener, 10.2.0.5.0...
Patching component oracle.network.client, 10.2.0.5.0...
Copying file to "/10g/app/oracle/product/10.2.0/dbhome_1/bin/adapters"
Running make for target client_sharedlib
Running make for target ioracle
Running make for target iwrap
Running make for target client_sharedlib
Running make for target proc
Running make for target irman
Running make for target itnslsnr
ApplySession adding interim patch '14275629' to inventory
Verifying the update...
Inventory check OK: Patch ID 14275629 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 14275629 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@test 14275629]$ opatch lsinventory
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 : /10g/app/oracle/product/10.2.0/dbhome_1
Central Inventory : /12c/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /10g/app/oracle/product/10.2.0/dbhome_1/oui
Log file location : /10g/app/oracle/product/10.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-03-07_15-53-33PM.log
Patch history file: /10g/app/oracle/product/10.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /10g/app/oracle/product/10.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-03-07_15-53-33PM.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 14275629 : applied on Fri Mar 07 15:53:09 CST 2014
Unique Patch ID: 15394595
Created on 3 Oct 2012, 18:33:12 hrs PST8PDT
Bugs fixed:
8865718, 11790175, 13489660, 9020537, 9772888, 8650138, 8664189, 10091698
14275629, 10092858, 12551710, 7519406, 13349665, 8771916, 7509714
8822531, 10139235, 10159846, 13257247, 8350262, 11792865, 7119382
13632738, 11724962, 8966823, 9320130, 13775862, 11674645, 7026523
9399589, 9672816, 13503598, 9499302, 9150282, 9448311, 9659614, 13632743
9949948, 10327179, 8882576, 7612454, 7111619, 9711859, 9714832, 9735237
9952230, 12780098, 14665116, 8660422, 11066597, 14105702, 9713537
14105703, 14105704, 13483152, 13737773, 13737775, 14269955, 12925532
12748240, 9694101, 14390396, 12862186, 12862187, 10249537, 9586877
8211733, 6694396, 9548269, 7115910, 7710224, 9337325, 8354642, 7602341
14076510, 10157402, 12565867, 6402302, 10327190, 10269717, 11693109
10017048, 8546356, 8394351, 9024850, 8224558, 9770451, 9360157, 8488233
9109487, 10132870, 9171933, 10173237, 9532911, 10068982, 10306945
7361418, 11725006, 8666117, 6157713, 9184754, 10214450, 8544696, 9767674
9323583, 8277300, 9726739, 13343467, 8412426, 10326338, 10165083
6651220, 12419392, 10208905, 9145204, 13554409, 11076894, 7450366
11893577, 8970313, 14492313, 6011045, 14492314, 10162036, 11814891
14492315, 10248542, 14492316, 9469117, 13359623, 9952270, 13343471
9842573, 10324526, 12419258, 9322219, 8636407, 10010310, 12828105
9689310, 9390484, 13736501, 13736502, 9824435, 13736503, 13736504
13736505, 13736506, 9963497, 9032322, 13736507, 12551700, 12551701
12551702, 11858315, 12551703, 12551704, 12551705, 10076669, 12551706
14040433, 12551707, 6076890, 9308296, 12551708, 13916709, 12827745
12880299, 14038805, 13923855, 8528171, 9072105, 11737047
--------------------------------------------------------------------------------
OPatch succeeded.
五、 啟動資料庫進行驗證
[oracle@test 14275629]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Mar 7 15:53:44 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 419430400 bytes
Fixed Size 2096728 bytes
Variable Size 213909928 bytes
Database Buffers 197132288 bytes
Redo Buffers 6291456 bytes
Database mounted.
Database opened.
SQL>
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
小結：打補丁之前強烈建議對ORACLE軟體進行備份，資料庫關閉。看好OPacth軟體的版本（可以到官網下載p6880880_102000_LINUX.zip），否則無法打補丁成功。後續RAC打補丁全過程。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26148431/viewspace-1103194/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【opatch】Oracle打補丁工具opatch簡介Oracle
- 使用OPatch給Oracle打補丁Oracle
- opatch 工具打補丁使用說明
- 資料庫的升級和打補丁的研究資料庫
- 打補丁報錯Opatch error : "Unable to lock Central InventoryError
- 安裝oraInventory和使用opatch給Oracle打補丁AIOracle
- zt_使用opatch給oracle打補丁patch_bugOracle
- Oracle的OPatch補丁更新Oracle
- EBS opatch 補丁應用
- Linux檔案打補丁Linux
- Weblogic 補丁升級慢Web
- 12. Oracle版本、補丁及升級——12.2. 補丁及補丁集Oracle
- 資料庫PSU的補丁升級 從10.2.0.5.2(10248542)升級至10.2.0.5.12(16619894)打補丁記錄資料庫
- 升級opatch工具
- ORACLE opatch 打補丁fuser command output for /u01/.../crsctl.bin is FailureOracleAI
- OJVM+GI PSU補丁升級JVM
- ORACLE 10G RAC 升級補丁Oracle 10g
- Oracle資料庫升級與補丁Oracle資料庫
- ORACLE 11g 升級補丁（Patch）Oracle
- 如何檢視Oracle補丁 - opatch 的使用Oracle
- 12. Oracle版本、補丁及升級——12.3. 升級Oracle
- 怎樣為linux核心打補丁(轉)Linux
- db2 v9.7 補丁升級DB2
- SAP 補丁升級步驟詳解 (轉)
- Oracle 補丁體系 及 opatch 工具 介紹Oracle
- RAC資料庫中用opatch應用補丁資料庫
- GI PSU打補丁之opatch auto 自動方式分別打GI_HOME和ORACLE_HOMEOracle
- oracle打補丁回顧Oracle
- Oracle EBS中打補丁Oracle
- Linux下為DB2 9.7打補丁LinuxDB2
- 探索Oracle之資料庫升級一 升級補丁修復概述Oracle資料庫
- 資料庫升級(10.2.0.1.0->10.2.0.5.0)+打補丁P12880299資料庫
- 使用web client對 vcenter 進行補丁升級Webclient
- SAP打補丁(Tcode:SPAM)
- Torvalds給Linux核心打補丁抵禦病毒(轉)Linux
- WSUS Offline Update離線補丁升級工具
- 【PATCH】Oracle12c升級補丁初體驗Oracle
- AIX 5.3下 升級補丁到10.2.0.5步驟AI