--数据库告警日志出现以下错误,经过分析对库进行升级操作
--告警信息如下:
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], [], [], [], [], [], [], [], [], [], [], []
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;
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
--------------------------------------------------------------------------------
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;
SQL> select OPEN_MODE from v$database;
OPEN_MODE
--------------------
READ WRITE
--------------------
READ WRITE
SQL> select * from test.test;
ID NAME
---------- --------------------
1 oraking
2 yallonking
---------- --------------------
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
--------------------------------------------------------------------------------
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
---------- --------------------
1 oraking
2 yallonking
至此,数据库升级完成。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26143577/viewspace-721988/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26143577/viewspace-721988/