ITPub博客

很常见的一个信息，以前并没有太在意，不过即使是这种异常信息，Oracle也认为是bug。 [@more@] 关闭数据库时，信息如下： Tue Aug 16 15:38:06 2011 Shutting down archive processes Tue Aug 16 15:38:11 2011 ARCH shutting down ARC2: Archival stopped Tue Aug 16 15:43:41 2011 Starting background process EMN0 EMN0 started with pid=28, OS id=1294500 Tue Aug 16 15:43:41 2011 Shutting down instance: further logons disabled Tue Aug 16 15:43:41 2011 Stopping background process QMNC

客户数据库出现ORA-600[kocgor077]错误。 [@more@] 数据库版本为10.2.0.1，详细错误信息为： Thu Oct 22 22:00:36 2009 ORA-0 encountered when generating server alert SMG-3503 Thu Oct 22 22:10:40 2009 ORA-0 encountered when generating server alert SMG-3503 Thu Oct 22 22:20:44 2009 ORA-0 encountered when generating server alert SMG-3503 Thu Oct 22 22:24:44 2009 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_606440.trc: ORA-00600: internal error code, arguments: [

客户Oracle 10.2.0.1数据库告警日志出现大量的ORA-21780错误，并包含SMG-3000和SMG-3503信息，紧接着出现了ORA-4030和ORA-600(keltenq)错误。 [@more@] 错误信息如下： 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 Aug 17 10:48:42 2009 ORA-21780 encountered when gener

客户10.2.0.1数据库在控制文件自动备份过程中出现错误信息。 [@more@] 错误信息为： 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 to DISK device hand

Exadata环境在收集统计信息时出现这个错误。 [@more@] 客户数据库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

客户10.2.0.1环境，出现了ORA-1000错误并导致了ORA-7445错误的产生。 [@more@] 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 exceeded 在文档ORA-7445

在10.2.0.4 RAC环境中，出现了更改SERVICE_NAME导致大量会话被KILL的现象。 [@more@] 告警日志中信息如下： 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: 0x18dc79b70 OS pid: 4879 Immediate Kill Session#: 1424, Serial#: 108 Immediate Kill Sessio

客户9.2.0.6 RAC出现ORA-600[17067]错误。 [@more@] 错误信息如下： 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], [1], [229], [], [], [], [], [] ORA-00600: internal error code, arguments:

一个临时表空间无法分配导致的ORA-600错误。 [@more@] 错误信息如下： 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: unable to extend temp segment by 128 in tablespace ATEMP Wed May 16 17:26:38 2012 ORA-1652: unable to extend temp segment by 128 in ta

Oracle 9206 RAC环境访问LOGMINER视图时报错。 [@more@] 错误信息： 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] 对应的TRACE信息为： *** 2011-08-10 17:06:37.463 *** SESSION ID:(49.28760) 2011-08-10 17:06:37.461 Excep

又一个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 [@more@] 错误信息为： Thu Apr 28 20:54:53 2011 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_31916032.trc (incident=148665): ORA-00600: 内部错误代码, 参数: [kollasg:client-side tmp lob], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/orac

客户的9206数据库出现ORA-7445错误。 [@more@] 错误信息： 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] 导致该错误详细信息： *** 2009-04-17 09:11:24.746 *** SESSION ID:(107.25) 2009-04-17 09:11:24.738 Exception signal: 11 (SIGSEG

9206数据库在收集统计信息时出现这个错误。 [@more@] 错误信息如下： Fri Oct 14 05:00:52 2011 Errors in file /opt/app/admin/orcl/bdump/orcl2_p010_16736.trc: ORA-00600: internal error code, arguments: [kghpih:ds], [0x494217CE8], [], [], [], [], [], [] Fri Oct 14 05:00:53 2011 Trace dumping is performing id=[cdmp_20111014050053] Fri Oct 14 05:00:53 2011 Errors in file /opt/app/admin/orcl/bdump/orcl2_j000_16586.trc: ORA-12012: error on auto execute of job 291 ORA-12801:

在笔记本的本地数据库中创建数据库链，访问远端数据库，出现ORA-12170访问超时错误。 [@more@] 由于访问超时，首先检查网络，确认远端服务器是可以访问的： C:Userslenovo>ping 192.168.0.56 正在 Ping 192.168.0.56 具有 32 字节的数据: 来自 192.168.0.56 的回复: 字节=32 时间<1ms TTL=64 来自 192.168.0.56 的回复: 字节=32 时间<1ms TTL=64 来自 192.168.0.56 的回复: 字节=32 时间<1ms TTL=64 来自 192.168.0.56 的回复: 字节=32 时间<1ms TTL=64 192.168.0.56 的 Ping 统计信息:

Oracle 11.1.0.6数据库在归档到远端实例时出现这个错误。 [@more@]详细错误信息为：Wed Dec 26 12:39:20 2012Error 1017 received logging on to the standby------------------------------------------------------------Check that the primary and standby are using a password fileand remote_login_passwordfile is set to SHARED or EXCLUSIVE, and that the SYS password is same in the password files. returning error ORA-16191------------------------------------------------------------Errors

又是一个ANSI标准SQL导致的BUG。 [@more@]数据库版本10.2.0.1，错误信息为：Wed Nov 09 19:15:27 2011Errors in file c:oracleproduct10.2.0adminorcludumporcl_ora_784.trc:ORA-00600: 内部错误代码, 参数: [kkoljt1], [], [], [], [], [], [], []根据文档Bug 5864217 - OERI [kkoljt1] from ANSI query with join elimination [ID 5864217.8]，在10.2.0.3以前版本中标准SQL如果出现了连接消除会导致ORA-600[kkoljt1]的错误。Oracle在11.1.0.6和10.2.0.4中解决了这个问题。除了升级外，避免标准SQL的写法是最好

客户10.2.0.1 for Windows出现ORA-7445错误。 [@more@]没有打过补丁的数据库出现问题的几率果然很大：Thu Mar 29 15:11:50 2012Errors in file c:oracleproduct10.2.0adminorcludumporcl_ora_880.trc:ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkdlavc+233] [PC:0x7F6661] [ADDR:0x0] [UNABLE_TO_READ] []这个问题是由于访问了一个不正常的视图所致，解决方法就是重建视图。关于这个bug的描述可以参考文档ORA-07445 [kkdlavc()+284] When Performing Query Against a View。

客户10.2.0.1 for Windows 32数据库出现ORA-7445[_kkqtnloCbk]错误。 [@more@]告警日志中错误信息为：Tue Nov 08 14:56:39 2011Errors in file c:oracleproduct10.2.0adminorcludumporcl_ora_4720.trc:ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkqtnloCbk+124] [PC:0x1DB818C] [ADDR:0xF5] [UNABLE_TO_READ] []导致这个错误的原因是Oracle处理ANSI语法时出现异常，参考文档Bug 4204383 Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries。这个错误影响10.2.0.3以下版本，Oracl

一个由于低版本JDBC驱动导致的错误。 [@more@] 告警日志中错误信息为：Fri Aug 12 19:00:03 2011Errors in file /opt/app/oracle/admin/orcl/udump/orcl2_ora_28464.trc:ORA-07445: exception encountered: core dump [lnxadd()+471] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []Fri Aug 12 19:00:04 2011 Trace dumping is performing id=[cdmp_20110812190004]根据MOS文档setDouble On INSERT Corrupts Data In NUMBER Column Using Oracle10g JDBC Driver [ID 313373.1]，导致问题的原因是使用了低版本的J

客户10.2.0.4 RAC for Linux X64环境，告警日志出现ORA-600(6033)错误。 [@more@]详细错误信息为：/opt/app/oracle/admin/orcl/udump/orcl1_ora_25075.trcOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1System name: LinuxNode name: hb1Release: 2.6.9-78.ELlargesmpVersion: #1 SMP Wed Jul 9 16:03:59 EDT 200