ora-600[kcblasm_1]bug處理（二）

6、編譯數(shù)據(jù)庫(kù)。

創(chuàng)新互聯(lián)是專業(yè)的潁上網(wǎng)站建設(shè)公司，潁上接單;提供成都網(wǎng)站設(shè)計(jì)、成都做網(wǎng)站,網(wǎng)頁(yè)設(shè)計(jì),網(wǎng)站設(shè)計(jì),建網(wǎng)站,PHP網(wǎng)站建設(shè)等專業(yè)做網(wǎng)站服務(wù);采用PHP框架,可快速的進(jìn)行潁上網(wǎng)站開(kāi)發(fā)網(wǎng)頁(yè)制作和功能擴(kuò)展;專業(yè)做搜索引擎喜愛(ài)的網(wǎng)站,專業(yè)的做網(wǎng)站團(tuán)隊(duì),希望更多企業(yè)前來(lái)合作!

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @catbundle.sql psu apply

此過(guò)程日志過(guò)多，不再次顯示。

SQL> @utlrp.sql

此過(guò)程日志過(guò)多，不再次顯示。

SQL> QUIT

7、查看補(bǔ)丁是否安裝到ORACLE_HOME及DB中。

[oracle@server ~]$ cd /home/oracle/orahome/OPatch

[oracle@server OPatch]$ ./opatch lsinventory

Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1

Oracle Home : /home/oracle/orahome

Central Inventory : /home/oracle/orabase/oraInventory

from : /etc/oraInst.loc

OPatch version : 10.2.0.5.1

OUI version : 10.2.0.5.0

OUI location : /home/oracle/orahome/oui

Log file location : /home/oracle/orahome/cfgtoollogs/opatch/opatch3014-08-04_14-46-06PM.log

Patch history file: /home/oracle/orahome/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /home/oracle/orahome/cfgtoollogs/opatch/lsinv/lsinventory2014-08-04_14-46-06PM.txt

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

Installed Top-level Products (3):

Oracle Database 10g 10.2.0.1.0

Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0

Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0

There are 3 products installed in this Oracle Home.

Interim patches (1) :

Patch 12419392 : applied on Mon Aug 04 14:25:33 CST 2014

Unique Patch ID: 13794201

Created on 29 May 2011, 22:29:59 hrs PST8PDT

Bugs fixed:

6402302, 10269717, 10327190, 8865718, 10017048, 9024850, 8394351, 8546356

9360157, 9770451, 9020537, 9772888, 8664189, 10091698, 12551710, 7519406

10132870, 8771916, 9109487, 10173237, 10068982, 8350262, 11792865

11724962, 11725006, 9184754, 8544696, 9320130, 7026523, 8277300, 9726739

8412426, 12419392, 6651220, 9150282, 9659614, 9949948, 10327179, 8882576

7612454, 9711859, 9714832, 10248542, 9952230, 9469117, 9952270, 8660422

10324526, 12419258, 9713537, 10010310, 9390484, 9963497, 12551700

12551701, 10249537, 12551702, 12551703, 8211733, 12551704, 9548269

12551705, 12551706, 9337325, 12551707, 7602341, 12551708, 9308296

10157402, 11737047

OPatch succeeded.

[oracle@server OPatch]$

SQL> select * from dba_registry_history;

ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS

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

14-JUN-11 12.31.31.749220 PM VIEW RECOMPILE 8289601 view recompila

tion

14-JUN-11 12.31.31.816662 PM UPGRADE SERVER 10.2.0.5.0 Upgraded from

10.2.0.4.0

04-AUG-14 02.38.05.811707 PM APPLY SERVER 10.2.0.5 4 PSU PSU 10.2.0.5.4

SQL>

備注：

1、該patch升級(jí)步驟可查看p12419392_10205_Linux-x86-64.zip包中的readme.html。同時(shí)升級(jí)時(shí)必須關(guān)閉數(shù)據(jù)庫(kù)，本例為單實(shí)例數(shù)據(jù)庫(kù)演示。

2、查看PSU是否更新成功，根據(jù)http://dreamsanqin.blog.51cto.com/845412/1535784方法完成。

當(dāng)前題目：ora-600[kcblasm_1]bug處理（二）
標(biāo)題鏈接：http://muchs.cn/article2/jcgjic.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供企業(yè)網(wǎng)站制作、微信公眾號(hào)、云服務(wù)器、網(wǎng)站設(shè)計(jì)、網(wǎng)站排名、用戶體驗(yàn)

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容