溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
一、當前環境
| 平臺 | 版本 | 模式 |
| Linux 32bit | Oracle 10.2.0.3 | 單實例 |
修復CPU bug
即Patch 7369190:
登陸metalink網站
查找對應補丁
將下載下來的補丁p7369190_10203_LINUX.zip上傳到數據庫服務器上
按照補丁自帶的說明文檔升級
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
? 解壓補丁
$unzip p7369190_10203_LINUX.zip
? 關閉數據庫實例
SQL> shutdown immediate;
? 安裝補丁
按照補丁自帶說明文件執行
$cd 7369190
$opatch napply -skip_subset -skip_duplicate
備注：Oracle 10.2.0.3版本的opath不帶napply參數，需要下載p6741493_10203_GENERIC.zip補丁，將p6741493補丁解壓縮，使用p6741493補丁解壓縮路徑的opatch命令，執行以下命令安裝7369190補丁：
oracle@linux-o154:~/7369190/7369190> /opt/oracle/OPatch/opatch napply -skip_subset -skip_duplicate
? 執行sql
按照文檔說明，執行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
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
