Category Archives: ORACLE

所有Oracle技术文章

ORA-21780、ORA-4030、ORA-600(keltenq)、SMG-3000、SMG-3503错误

Posted on 2012/11/17 by yangtingkun

客户Oracle 10.2.0.1数据库告警日志出现大量的ORA-21780错误，并包含SMG-3000和SMG-3503信息，紧接着出现了ORA-4030和ORA-600(keltenq)错误。 错误信息如下： Mon Aug 17 10:37:48 2009 ORA-21780 encountered WHEN generating server alert SMG-3000 Mon Aug 17 10:38:27 2009 ORA-21780 encountered WHEN generating server alert SMG-3503 Mon Aug 17 10:47:48 2009 ORA-21780 encountered WHEN generating server alert SMG-3000 Mon … Continue reading →

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

控制文件自动备份报错并产生TRACE文件

Posted on 2012/11/16 by yangtingkun

客户10.2.0.1数据库在控制文件自动备份过程中出现错误信息。 错误信息为： Thu Jun 30 02:15:46 2011 Starting control autobackup Thu Jun 30 02:15:47 2011 Errors IN file /u01/app/oracle/admin/orcl/udump/orcl_ora_1167402.trc: Thu Jun 30 02:15:47 2011 Errors IN file /u01/app/oracle/admin/orcl/udump/orcl_ora_1167402.trc: Thu Jun 30 02:15:47 2011 Errors IN file /u01/app/oracle/admin/orcl/udump/orcl_ora_1167402.trc: Control autobackup written … Continue reading →

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

ORA-600(ktspfnsb-1)错误

Posted on 2012/11/15 by yangtingkun

Exadata环境在收集统计信息时出现这个错误。 客户数据库11.2.0.2 RAC on Exadata在收集统计信息是出现的错误： Sun Feb 05 22:22:44 2012 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_j002_21084.trc (incident=255085): ORA-00600: internal error code, arguments: [ktspfnsb-1], [1], [1], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_255085/orcl2_j002_21084_i255085.trc Sun Feb 05 22:22:56 … Continue reading →

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

ORA-1000导致的ORA-7445错误

Posted on 2012/11/14 by yangtingkun

客户10.2.0.1环境，出现了ORA-1000错误并导致了ORA-7445错误的产生。 Oracle的ORA-1000错误是个普通的问题，就是当前使用的游标值超过了OPEN_CURSOR初始化参数的值，而这个错误导致的ORA-7445错误还是第一次看到： Thu Oct 28 16:32:57 2010 Errors IN file /u01/app/oracle/admin/orcl/orcl/orcl_mmon_356528.trc: ORA-07445: exception encountered: core dump [] [] [] [] [] [] ORA-00604: error occurred at recursive SQL level 2 ORA-01000: maximum OPEN cursors exceededThu Oct 28 16:32:57 2010 Errors … Continue reading →

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

更改SERVICE_NAME导致大量会话被KILL

Posted on 2012/11/13 by yangtingkun

在10.2.0.4 RAC环境中，出现了更改SERVICE_NAME导致大量会话被KILL的现象。 告警日志中信息如下： Wed Oct 24 20:06:16 2012 ALTER SYSTEM SET service_names=” SCOPE=MEMORY SID=’orcl2′; Wed Oct 24 20:06:16 2012 ALTER SYSTEM SET service_names=’orcl’ SCOPE=MEMORY SID=’orcl2′; Wed Oct 24 20:06:16 2012 Immediate KILL SESSION#: 1418, Serial#: 22066 Immediate KILL SESSION: sess: … Continue reading →

Posted in BUG | Tagged , | Leave a comment

ORA-600(17067)错误

Posted on 2012/11/11 by yangtingkun

客户9.2.0.6 RAC出现ORA-600[17067]错误。 错误信息如下： Wed DEC 3 00:51:02 2008 Errors IN file /ora9i/app/oracle/admin/orcl9i/udump/orcl9i2_ora_25250.trc: ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], [] Wed DEC 3 00:51:07 2008 Errors IN file /ora9i/app/oracle/admin/orcl9i/udump/orcl9i2_ora_25250.trc: ORA-00600: internal error code, arguments: [26599], … Continue reading →

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

ORA-600(kcbgcur_1)错误

Posted on 2012/11/07 by yangtingkun

一个临时表空间无法分配导致的ORA-600错误。 错误信息如下： Wed May 16 17:26:23 2012 ORA-1652: unable TO extend temp segment BY 128 IN tablespace ATEMP Wed May 16 17:26:31 2012 ORA-1652: unable TO extend temp segment BY 128 IN tablespace ATEMP Wed May 16 17:26:37 2012 ORA-1652: … Continue reading →

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

ORA-7445(ksfd_odmwat)错误

Posted on 2012/11/06 by yangtingkun

Oracle 9206 RAC环境访问LOGMINER视图时报错。 错误信息： Wed Aug 10 17:06:37 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl2_ora_20704.trc: ORA-07445: exception encountered: core dump [000000010069AB88] [SIGSEGV] [Address NOT mapped TO object] [0x000000008] [] [] Wed Aug 10 17:07:22 2011 Trace dumping IS performing id=[cdmp_20110810170722]Wed Aug 10 … Continue reading →

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

ORA-600(12333)错误（二）

Posted on 2012/11/05 by yangtingkun

又一个ORA-600(12333)错误。 ORA-600(12333)错误：http://yangtingkun.itpub.net/post/468/526154 ORA-600(12333)错误和ORA-600(ttclxx1)错误：http://yangtingkun.itpub.net/post/468/526078 错误发生在9206RAC环境下： Tue Jul 12 17:26:57 2011 Errors in file /opt/app/admin/orcl/udump/orcl1_ora_28993.trc: ORA-00600: internal error code, arguments: [12333], [19], [3], [15], [], [], [], [] Tue Jul 12 17:26:58 2011 Trace dumping is performing id=[cdmp_20110712172658] 详细TRACE如下： *** SESSION ID:(116.15703) … Continue reading →

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

ORA-7445(opipls)错误

Posted on 2012/11/04 by yangtingkun

客户的9206数据库出现ORA-7445错误。 错误信息： Fri Apr 17 09:11:24 2009 Errors IN file /opt/app/admin/orcl/udump/orcl1_ora_15039.trc: ORA-07445: exception encountered: core dump [000000010102BD1C] [SIGSEGV] [Address NOT mapped TO object] [0x000000004] [] [] Fri Apr 17 09:11:25 2009 Trace dumping IS performing id=[cdmp_20090417091125]Fri Apr 17 09:11:24 2009 … Continue reading →

Posted in BUG | Tagged , , | Leave a comment