Category Archives: BUG

Oracle bugs

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

ORA-600(kghpih:ds)错误

Posted on 2012/11/03 by yangtingkun

9206数据库在收集统计信息时出现这个错误。 错误信息如下： 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 … Continue reading →

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

本机数据库数据库链无法访问远端数据库

Posted on 2012/10/30 by yangtingkun

在笔记本的本地数据库中创建数据库链，访问远端数据库，出现ORA-12170访问超时错误。 由于访问超时，首先检查网络，确认远端服务器是可以访问的： C:\Users\lenovo>ping 192.168.0.56 正在 Ping 192.168.0.56 具有 32 字节的数据: 来自 192.168.0.56 的回复: 字节=32 时间 conn test/test 已连接。 SQL> create database link enmo10 connect to test identified by test using ‘192.168.0.56/enmo10’; 数据库链接已创建。 SQL> select * from tab@enmo10; select * from … Continue reading →

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

ORA-600(kssadd: null parent)错误

Posted on 2012/10/29 by yangtingkun

Oracle 11.1.0.6数据库在归档到远端实例时出现这个错误。 详细错误信息为： Wed DEC 26 12:39:20 2012 Error 1017 received logging ON TO the standby ———————————————————— CHECK that the PRIMARY AND standby are USING a password file AND remote_login_passwordfile IS SET TO SHARED OR EXCLUSIVE, AND that the SYS … Continue reading →

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