-
Recent Posts
Recent Comments
- yangtingkun on 非空字段空值对查询的影响
- Eric Zong on 非空字段空值对查询的影响
- Kamus on Oracle Ace Director
- 设置全局死锁优先级 | yangtingkun on RAC全局死锁检测时间
- ORA-600(krbounotread_noctx)错误 | yangtingkun on ORA-600(krboReadBitmap_badbitmap)错误
Archives
- December 2020
- February 2019
- December 2018
- November 2018
- October 2018
- July 2018
- June 2018
- May 2018
- July 2016
- July 2013
- June 2013
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
Categories
Meta
Tag Archives: ORA-7445
ORA-7445(_intel_fast_memcpy.A)错误
在10.2.0.4 RAC for X86-64环境上出现了ORA-7445[_intel_fast_memcpy.A]的错误。 以前碰到过几次的memcpy有关的错误，但是这个错误函数是第一次碰到： Sat Apr 7 17:27:11 2012 Errors IN file /opt/app/oracle/admin/orcl/bdump/orcl1_j002_16579.trc: ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address NOT mapped TO object] [0x2A9734C000] [] []Sat Apr 7 17:27:11 2012 Errors in file /opt/app/oracle/admin/orcl/bdump/orcl1_j002_16579.trc: ORA-07445: exception encountered: … Continue reading
ORA-7445(kqlSubheapPin)错误
Oracle 10.2.0.4 for X86-64数据库出现ORA-7445[kqlSubheapPin]错误。 错误信息为： Tue Jul 26 13:27:05 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_6729.trc: ORA-07445: exception encountered: core dump [kqlSubheapPin()+84] [SIGSEGV] [Address NOT mapped TO object] [0x000000110] [] []Tue Jul 26 13:27:05 2011 Errors in file /opt/app/oracle/admin/ora/udump/ora1_ora_6729.trc: ORA-07445: exception encountered: … Continue reading
Posted in BUG
Tagged DDL, kqlSubheapPin, LOCK, Materialized view, MV, ORA-7445, QUERY REWRITE
Leave a comment
ORA-600(qerrmOStart2)(972)错误
关于ORA-600[qerrmOStart2]已经碰到第三次不同的错误了，简单记录一下这个问题。 数据库版本为10.2.0.5 RAC for Linux X86-64，错误信息为： Fri Jun 29 14:53:29 CST 2012 Errors IN file /opt/app/oracle/admin/ora/udump/ora2_ora_5832.trc: ORA-00600: internal error code, arguments: [qerrmOStart2], [972], [ORA-00972: identifier IS too long ], [], [], [], [], [] Fri Jun 29 14:53:36 CST 2012 … Continue reading
Posted in BUG
Tagged 972, identifier is too long, ORA-600, ORA-7445, ORA-972, qerrmOdcl, qerrmOStart2
Leave a comment
ORA-4030、ORA-27300错误和大量ORA-7445错误
客户11.2 RAC环境出现大量的ORA-7445错误、ORA-4030错误以及ORA-27300、ORA-27301和ORA-27302错误。 错误信息为： Sat DEC 31 02:33:18 2011 Errors IN file /app/diag/rdbms/orcl/orcl1/trace/orcl1_p015_28613.trc: ORA-07445: exception encountered: core dump [_ndoprnt()+4] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE5FE0] [PC:0xFFFFFFFF7ADA92B0] [Address NOT mapped TO object] [] ORA-04030: OUT OF process memory WHEN trying TO allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba) … Continue reading
Posted in BUG
Tagged fork failed with status, kgdsdst, ksmpgd_init_ctx, Not enough space, ORA-27300, ORA-27301, ORA-27302, ORA-4030, ORA-7445, skgpspawn3, sskgds_init, _ndoprnt
Leave a comment
ORA-600(ksqsgn:join)和ORA-7445(BREAKPOINT)错误
一个Windows环境下的RAC 10.2.0.4在添加节点时，原节点的ASM实例出现这两个错误。 错误信息如下： Sat Jun 09 11:24:21 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 GB2 192.168.7.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 GB1 172.16.7.0 configured FROM OCR … Continue reading
Posted in ORACLE
Tagged BREAKPOINT, cluster, error in lmon process, Error: KGXGN polling error (15), IPCConnect, ksqsgn:join, ORA-29702, ORA-600, ORA-7445, PRIVATE IP, PUBILC IP, RAC
Leave a comment
ORA-7445(xsStkPurge)错误
客户数据库出现ORA-7445(xsStkPurge)错误。 数据库告警日志出现如下的错误信息： Fri Aug 3 17:10:03 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_23101.trc: ORA-07445: exception encountered: core dump [xsStkPurge()+73] [SIGSEGV] [Address NOT mapped TO object] [0x0] [] [] ORA-04030: OUT OF process memory WHEN trying TO allocate 8184 bytes (OLAP stack hea,OLAP … Continue reading
Posted in BUG
Tagged dbms_aw, interp, olap, OLAP stack hea, ORA-4030, ORA-7445, Streams AQ: enqueue blocked on low memory, streams_pool, XSSTKPURGE
Leave a comment
ORA-7445(kwqbcsoa)和ORA-7445(lstclo)错误
客户环境出现多次ORA-7445错误以及Oracle executable binary mismatch detected的告警信息。 数据库版本为10.2.0.3 for Linux，错误信息如下： Mon Aug 6 11:13:11 2012 WARNING: Oracle executable BINARY mismatch detected. BINARY OF NEW process does NOT MATCH BINARY which started instance issue ALTER system SET "_disable_image_check" = TRUE TO disable these … Continue reading
Posted in BUG
Tagged IMPDP, kwqbcsoa, lstclo, olap, ORA-7445, Oracle executable binary mismatch detected
Leave a comment
ORA-7445(xsSSEXECUT)错误
又一个OLAP组件相关的bug。 数据库版本为10.2.0.3 32bit for Linux，在告警日志出现下面的错误： Mon Jul 30 23:29:19 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_24707.trc: ORA-07445: exception encountered: core dump [xsSSEXECUT()+13022] [SIGSEGV] [Address NOT mapped TO object] [0x14] [] []Mon Jul 30 23:29:19 2012 Errors in file /ora/app/oracle/admin/ORCL/udump/orcl_ora_24707.trc: ORA-07445: exception encountered: … Continue reading
ORA-7445(plcurClose)错误
11.2.0.2 RAC环境，碰到这个错误。 详细错误信息为： Tue Mar 13 14:25:17 2012 Exception [TYPE: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x37434AD, plcurClose()+27] [flags: 0x0, COUNT: 1] Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_29472.trc (incident=279439): ORA-07445: exception encountered: core dump [plcurClose()+27] [SIGSEGV] [ADDR:0x0] [PC:0x37434AD] [SI_KERNEL(general_protection)] [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_279439/orcl2_ora_29472_i279439.trc USE … Continue reading
ORA-600(1403)和ORA-7445($cold_kslgetsl)错误
10.2.0.2 RAC的ASM实例，出现这两个错误并导致实例的崩溃。 错误信息为： Thu Apr 12 18:55:42 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 lan901 192.168.0.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 lan900 198.5.1.0 configured FROM OCR … Continue reading
Posted in BUG
Tagged $cold_kslgetsl, 10.2.0.2, 1403, ASM, ins_rdbms.mk, ioracle, libknlopt.a, make, ORA-600, ORA-7445, ora-81, RAC
Leave a comment