Category Archives: BUG

Oracle bugs

运行脚本diagcollection.pl报错

Posted on 2011/11/29 by yangtingkun

Oracle的RAC提供了diagcollection.pl脚本，用来收集CLUSTER和数据库的脚本。不过在客户环境中执行这个脚本报错。 详细错误信息为： [root@smsdbrac1 ora_test]# $ORA_CRS_HOME/bin/diagcollection.pl -crshome=$ORA_CRS_HOME -collect Production Copyright 2004, 2005, Oracle. ALL rights reserved Cluster Ready Services (CRS) diagnostic collection tool The following CRS diagnostic archives will be created IN the LOCAL directory. crsData_smsdbrac1.tar.gz -> logs,traces AND cores FROM … Continue reading →

Posted in BUG | Tagged , | Leave a comment

告警日志出现skgpspawn failed category 27142错误

Posted on 2011/11/28 by yangtingkun

客户的数据库告警日志出现skgpspawn failed信息。 详细错误信息如下： Mon Nov 28 07:59:59 2011 skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn5 skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3 skgpspawn failed:category = 27142, depinfo = … Continue reading →

Posted in BUG | Tagged , , , , , , , | Leave a comment

ORA-600(5351)错误

Posted on 2011/11/26 by yangtingkun

在告警日志中发现了ORA-600(5351)错误，同时出现大量的There are 3 memory allocation errors for object-level stat错误。 详细的错误信息为： Tue Jun 22 12:00:09 2010 Thread 1 advanced TO log SEQUENCE 1522 CURRENT log# 3 seq# 1522 mem# 0: /dev/rredo03 There are 6 memory allocation errors FOR object-level stat IN … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment

ORA-7445($cold_qerfxArrayMaxSize)错误

Posted on 2011/11/25 by yangtingkun

客户的数据库告警日志中出现这个错误。 详细错误信息如下： Wed Oct 26 15:38:14 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_8209.trc: ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+15264] [SIGSEGV] [Address NOT mapped TO object] [0x000003058] [] [] Wed Oct 26 15:38:27 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_8209.trc: ORA-00081: address range [0x6000000000127430, 0x6000000000127434) … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

告警日志出现kewastUnPackStats信息

Posted on 2011/11/24 by yangtingkun

这个错误信息发现在客户的11.2.0.1数据库告警日志中。 告警信息如下： Fri Jul 22 14:00:51 2011 kewastUnPackStats(): bad magic 1 (0x2afd1cbafec6, 0) kewastUnPackStats(): bad magic 1 (0x2afd1cbafec6, 0) kewastUnPackStats(): bad magic 1 (0x2afd1cbafec6, 0) kewastUnPackStats(): bad magic 1 (0x2afd1cbafec6, 0) kewastUnPackStats(): bad magic 1 (0x2afd1cbafec6, 0) kewastUnPackStats(): bad magic … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(kokegPinLob1)错误

Posted on 2011/11/22 by yangtingkun

客户10.2.0.5 Oracle for AIX系统中，出现了这个ORA-600错误。 其中错误信息为： Fri Nov 18 19:50:18 GMT+08:00 2011Errors IN file /oracle/admin/ccicwmix/udump/ccicwmix_ora_4915530.trc: ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], []Fri Nov 18 19:50:18 GMT+08:00 2011Errors in file /oracle/admin/ccicwmix/udump/ccicwmix_ora_4915530.trc: ORA-00600: internal error code, arguments: … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

ORA-600(kgscLogOff-notempty)错误

Posted on 2011/11/21 by yangtingkun

客户的10.2.0.2环境在告警日志中出现这个错误。 错误信息为： Thu Oct 27 21:18:03 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_27896.trc: ORA-00600: internal error code, arguments: [kgscLogOff-notempty], [1], [], [], [], [], [], [] Thu Oct 27 21:18:05 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_27896.trc: ORA-00600: internal error code, arguments: [kgscLogOff-notempty], [1], … Continue reading →

Posted in BUG | Tagged , , , | 1 Comment

ORA-7445(kgegec)错误

Posted on 2011/11/20 by yangtingkun

客户数据库出现大量的ORA-7445错误。 这是一个11.1.0.6 for Windows 64bit的环境，在告警日志中包含了大量的ORA-7445错误： Thu Nov 10 00:00:43 2011 Exception [TYPE: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x75A20BE, kgegec()+76] Thu Nov 10 00:00:43 2011 Exception [TYPE: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x75A20BE, kgegec()+76] Thu Nov 10 00:00:43 2011 Errors IN file d:\app\administrator\diag\rdbms\gvdb\gvdb\cdump\gvdbcore.log ORA-07445: caught … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(15160)错误

Posted on 2011/11/18 by yangtingkun

客户数据库中发现了这个错误。 在告警日志中错误如下： Wed Nov 2 11:13:17 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_9007.trc: ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], [] Wed Nov 2 11:13:36 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_9007.trc: ORA-00600: internal error code, arguments: [15160], [], … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

进程日志中出现out of OS kernel IO resources

Posted on 2011/11/15 by yangtingkun

在检查一个进程的日志时，意外发现这个问题。 错误信息如下： /ora10g/app/admin/dbname/bdump/dbname1_j001_8567.trc Oracle DATABASE 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production WITH the Partitioning, REAL Application Clusters, OLAP AND DATA Mining options ORACLE_HOME = /ora10g/app/product/10.2.0/dbname System name: HP-UX Node name: dbname1 Release: B.11.23 Version: U Machine: ia64 Instance … Continue reading →

Posted in BUG | Tagged , | Leave a comment