ORA-00600: [kpoodp:kpodpfin_30] 資料庫升級 11.2.0.1.0->11.2.0.3.0

YallonKing發表於2012-04-22
--資料庫告警日誌出現以下錯誤,經過分析對庫進行升級操作
--告警資訊如下:
msg_id='3801180441' type='INCIDENT_ERROR' group='Generic Internal Error'
level='1' host_id='m1hfdata' host_addr='::1'
prob_key='ORA 600 [kpoodp:kpodpfin_30]' upstream_comp='' downstream_comp='DIRPATH_LOAD'
ecid='' errid='51639' detail_path='/m1hf/diag/rdbms/m1hf/m1hf/trace/m1hf_ora_3334.trc'>
Errors in file /m1hf/diag/rdbms/m1hf/m1hf/trace/m1hf_ora_3334.trc  (incident=51639):
ORA-00600: internal error code, arguments: [kpoodp:kpodpfin_30], [], [], [], [], [], [], [], [], [], [], []

 
--此問題是在資料庫並行處理時出現的內部錯誤,已經在11.2.0.2.0中修復
-在metalink上查閱相關資料後發現需要對庫進行升級解決此問題,此處採取升級至11.2.0.3.0
 
Bug 10036865: INFORMATICA LOADS FAIL IN BULK MODE WITH ORA-00600: [KPOODP:KPODPFIN_30]
補丁號:【p10404530】
--當前資料庫版本
SQL> select * from v$version where rownum<5;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
--資料庫處於開啟模式
SQL> select OPEN_MODE  from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL> select * from test.test;
        ID NAME
---------- --------------------
         1 oraking
         2 yallonking
 
--在使用dbua升級時將庫關閉後進行的,在沒有停庫的情況下升級,進度條卡死不動,遂採用停庫後進行升級,不過在未停庫進行時,也沒有停庫的相關提示,所以還是很納悶,是不是可以在不停庫的情況下進行dbua升級呢....

Your recycle bin contains objects. It is required that the recycle bin is empty prior to upgrading your database. Run "PURGE DBA_RECYCLEBIN" command using SQLPLUS before continuing with your upgrade.
Database contains schemas with objects dependent on DBMS_LDAP package. Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
Oracle recommends gathering dictionary statistics prior to upgrading the database. Refer to the Upgrade Guide for instructions to gather statistics prior to upgrading the database.
Your database has EVENT or _TRACE_EVENT initialization parameters set. Oracle recommends reviewing any defined events prior to upgrade. DBUA will retain these parameters during upgrade.

--升級完成後(約1.5h),測試庫自動開啟,不過需要修改ORACLE_HOME環境變數。
SQL> select * from v$version where rownum<5;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
SQL> select * from test.test;
        ID NAME
---------- --------------------
         1 oraking
         2 yallonking
 
至此,資料庫升級完成。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26143577/viewspace-721988/,如需轉載,請註明出處,否則將追究法律責任。

相關文章