ITPub博客

10.2.0.4 RAC环境关闭数据库时出现ORA-600[2801]错误。 [@more@]详细错误信息为：Mon Apr 11 22:44:24 2011alter database add supplemental log dataTue Apr 12 00:11:42 2011Thread 1 advanced to log sequence 3108 (LGWR switch) Current log# 1 seq# 3108 mem# 0: +DATA/orcl/onlinelog/group_1.307.727394923 Current log# 1 seq# 3108 mem# 1: +DATA/orcl/onlinelog/group_1.306.727394925Tue Apr 12 00:16:55 2011Thread 1 advanced to log sequence 3109 (LGWR switch) Current log# 2 seq# 3109 mem# 0: +

这是一个10.2.0.1到10.2.0.4上都存在的bug。 [@more@]错误发生在DG的STANDBY数据库中：Fri Oct 19 12:01:16 2012Errors in file /data/oracle/admin/vodapp/bdump/vodapp_mrp0_21304.trc:ORA-00600: internal error code, arguments: [3689], [33], [], [], [], [], [], []Errors with log /baceldba/archive/1_30374_730819916.dbfMRP0: Background Media Recovery terminated with error 600导致这个错误的原因很简单，在主库执行了ALTER TABLESPACE DROP DATAFILE后，并不会导致DATAFILE的被删除，后随后在增加新

10.2.0.4 RAC环境的ASM实例出现这个ORA-7445错误。 [@more@]错误信息为：Fri Dec 3 19:49:49 2010Errors in file /opt/app/oracle/admin/+ASM/bdump/+asm2_lck0_19876.trc:Fri Dec 3 19:50:44 2010Errors in file /opt/app/oracle/admin/+ASM/bdump/+asm2_ckpt_19863.trc:ORA-07445: exception encountered: core dump [kgskhighthreshold()+32] [SIGSEGV] [Address not mapped to object] [0x0000001F6] [] []Fri Dec 3 19:51:00 2010Trace dumping is performing id=[cdmp_20101203195100]Fri Dec 3 19:51:27 201

客户10.2.0.3 RAC环境启动后碰到DRM问题导致实例崩溃。 [@more@]错误信息为：Mon Jan 19 12:42:58 2009Database Characterset is ZHS16GBKreplication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCQMNC started with pid=28, OS id=4496Mon Jan 19 12:43:01 2009Completed: ALTER DATABASE OPENMon Jan 19 12:43:32 2009Thread 2 advanced to log sequence 2081 Current log# 3 seq# 2081 mem# 0: +DISKGROUP1/orcl1/onlinelog/group_3.258.628169029Mo

Oracle 11.2.0.2上SQL TUNING的bug。 [@more@]数据库版本为11.2.0.2 RAC for Solaris，错误信息为：Thu Jul 05 22:00:01 2012Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"Thu Jul 05 22:28:35 2012Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0x102B3CC08, qsmmixComputeClusteringFactor()+1640] [flags: 0x0, count: 1]Errors in file /opt/oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j002_7688.trc (incident=

已经在多个RAC环境碰到因为等待reliable message导致进程hang死的情况了。 [@more@]这个问题在RAC环境比较常见，在很多客户中都碰到过这个问题，而数据库版本多集中在10.2.0.4，个别的版本为10.2.0.5。而出现这个信息的进程也不太相同，最常见的的m000进程，这个进程的僵死会导致一个节点的AWR无法自动收集。另外比较常见的就是导致高级队列机制异常，直接影响是数据泵导出无法正常运行，会导致进程挂起。最近又碰到了类似的情况，在MOS文档中发现Bug 6148054 RAC hang waiting for "reliable message"文章描

前一段时间在客户测试TPCC的时候碰到这个问题，今天在MOS上找到问题的原因，简单记录一下。 [@more@]在11.2中，如果表设置了KEEP池，而在初始化参数中没有指定DB_KEEP_CACHE_SIZE的值，就可能会造成数据库中出现明显的ENQ: KO – Fast Object Checkpoint的等待，同时还伴有reliable message的等待。MOS文档ENQ: KO - Fast Object Checkpoint And Reliable Message Causing Bad Performance [ID 1377830.1]描述了这个问题，给出的解决方案是不使用KEEP池，改为使用DEFAULT池，或者设置DB_KEEP_CACHE_SIZE的值为非

客户11.2 RAC环境出现ORA-7445[pevm_icd_call_common]错误。 [@more@]详细错误信息为：Mon Aug 20 17:31:49 2012Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xD8] [PC:0x93F1E34, pevm_icd_call_common()+754] [flags: 0x0, count: 1]Redo thread 1 internally disabled at seq 9 (SMON)Errors in file /oracle/diag/rdbms/orcl/orcl2/trace/orcl2_m003_21741.trc (incident=12433):ORA-07445: exception encountered: core dump [pevm_icd_call_common()+754] [SIGSEGV] [ADDR:0xD8] [P

客户的10.2.0.4 FOR AIX数据库在刷新物化视图时碰到这个错误。 [@more@]错误信息为：Fri Oct 5 06:20:27 2012Errors in file /home/oracle/app/admin/orcl/udump/orcl_ora_4272180.trc:ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], []从TRACE文件可以看到，出现错误时在执行的语句是物化视图的刷新：*** 2012-10-05 06:20:27.599ksedmp: internal or fatal errorORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], []Current

客户9208 RAC环境出现ORA-600(15419)和ORA-6544(2603)错误。 [@more@]错误信息为：Sun Feb 5 15:58:52 2012Errors in file /oracle/app/admin/orcl/udump/orcl2_ora_250852.trc:ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], []ORA-06544: PL/SQL: internal error, arguments: [2603], [], [], [], [], [], [], []ORA-06553: PLS-707: unsupported construct or internal error [2603]Sun Feb 5 15:58:53 2012Trace dumping is performing id=[c

Oracle 9208 RAC for AIX出现这个错误。 [@more@]错误信息为：Tue Jun 22 17:41:21 2010Errors in file /oracle/app/admin/orcl/udump/orcl2_ora_4293428.trc:ORA-00600: internal error code, arguments: [12804], [kkdlgtd: bad object type], [], [], [], [], [], []Tue Jun 22 17:41:22 2010Trace dumping is performing id=[cdmp_20100622174122]从错误信息上分析，这个问题发生在Oracle检查对象类型时。查询MOS文档ORA-600 [12804] [kkdlgtd: bad object type] Alter Table Add Column Or Running a Query [I

客户9.2.0.8 RAC for AIX环境出现ORA-600[KSSADP1]错误。 [@more@]错误信息为：Thu Apr 19 21:16:45 2012Errors in file /oracle/app/admin/orcl/udump/orcl1_ora_442896.trc:ORA-00600: internal error code, arguments: [KSSADP1], [], [], [], [], [], [], []Thu Apr 19 21:16:45 2012Errors in file /oracle/app/admin/orcl/udump/orcl1_ora_442896.trc:ORA-00600: internal error code, arguments: [KSSADP1], [], [], [], [], [], [], []Thu Apr 19 21:16:45 2012Trace dumping is performing id=[cdmp_

客户9.2.0.6数据库出现ORA-600(kauxs_do_jou:3)错误。  错误信息为：Wed Mar 28 22:44:48 2012Errors in file /data/oracle/admin/orcl/udump/orcl_ora_19724.trc:ORA-00600: 内部错...

客户数据库出现ORA-600(504)错误，其中第5个错误参数为row cache objects。以前碰到过一个sharedpool的相关latch：http://yangtingkun.itpub.net/post/468/526079  错误信息为：Wed ...

客户10.2.0.4RAC数据库出现ORA-7445(kpufdesc)错误。  错误信息如下：Thu Dec 22 15:29:07 2011Errors in file/home/oracle/product/10.2.0/admin/orcl/bdump/orcl2_mmon_16893....

使用正则表达式导致的错误。  错误信息为：Fri Dec 16 15:37:51 2011Exception [type: SIGSEGV, Invalid permissions for mapped object][ADDR:0x2AFEA42A4000] [PC:0x9016222, lxsCn...

客户数据库出现SCHEDULER后台作业频繁调用XDB包，导致系统性能受到影响，数据库版本为10.2.0.3。  导致性能问题的SQL为：BEGIN BEGIN IF(xdb.DBMS_XDBZ0.is_hierarchy_enabled_interna...

11.2.0.1的ASM出现ORA-600[kfgFinalize_2]错误。  错误信息为：Fri Jun 17 09:59:51 2011NOTE: No asm libraries found in the system* instance_number obtained from CSS = 2, chec...

由于共享磁盘问题导致的两个ORA-600错误。  客户的10.2.0.4RAC for Linux X86-64，在告警日志中出现了大量的错误信息：Tue Apr 24 16:15:04 2012Errors in file /u01/admin/orcl/udum...

又是一个EXADATA上的错误。  数据库版本为11.2.0.2RAC，错误信息为：Tue Dec 06 10:34:33 2011Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0][PC:0x908F8BC,...