您好,登錄后才能下訂單哦!
一、當(dāng)前環(huán)境
平臺(tái) | 版本 | 模式 |
Linux 32bit | Oracle 10.2.0.3 | 單實(shí)例 |
修復(fù)CPU bug
即Patch 7369190:
登陸metalink網(wǎng)站
查找對(duì)應(yīng)補(bǔ)丁
將下載下來的補(bǔ)丁p7369190_10203_LINUX.zip上傳到數(shù)據(jù)庫服務(wù)器上
按照補(bǔ)丁自帶的說明文檔升級(jí)
oracle@linux-o154:~> /opt/oracle/product/10.2.0/db_1/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.3.0
Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
Oracle Home : /opt/oracle/product/10.2.0/db_1
Central Inventory : /opt/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /opt/oracle/product/10.2.0/db_1/oui
Log file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch3011-04-20_21-21-24PM.log
Lsinventory Output file location : /opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2011-04-20_21-21-24PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 2 products installed in this Oracle Home.
Interim patches (2) :
Patch 5556081 : applied on Sat Oct 30 10:48:31 EDT 2010
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081
Patch 5557962 : applied on Sat Oct 30 10:48:22 EDT 2010
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974
? 解壓補(bǔ)丁
$unzip p7369190_10203_LINUX.zip
? 關(guān)閉數(shù)據(jù)庫實(shí)例
SQL> shutdown immediate;
? 安裝補(bǔ)丁
按照補(bǔ)丁自帶說明文件執(zhí)行
$cd 7369190
$opatch napply -skip_subset -skip_duplicate
備注:Oracle 10.2.0.3版本的opath不帶napply參數(shù),需要下載p6741493_10203_GENERIC.zip補(bǔ)丁,將p6741493補(bǔ)丁解壓縮,使用p6741493補(bǔ)丁解壓縮路徑的opatch命令,執(zhí)行以下命令安裝7369190補(bǔ)?。?/font>
oracle@linux-o154:~/7369190/7369190> /opt/oracle/OPatch/opatch napply -skip_subset -skip_duplicate
? 執(zhí)行sql
按照文檔說明,執(zhí)行sql
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @/opt/oracle/7369190/7369190/files/cpu/CPUOct2008/catcpu.sql
If catcpu.sql reports any Invalid Objects, run the following commands:
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS= 'INVALID';
no rows selected
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。