Tag Archives: ORA-4030

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

客户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

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 , , , , , , , , , , , | Leave a comment

数据泵导出出现ORA-4030错误

客户Oracle 10.2.0.3环境,在导出是碰到ORA-4030错误。 错误信息为: Processing object TYPE SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object TYPE SCHEMA_EXPORT/TABLE/TRIGGER Processing object TYPE SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object TYPE SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ ORA-39014: One OR more workers have prematurely exited. ORA-39029: worker 1 WITH process name “DW01” prematurely TERMINATED ORA-31671: Worker process DW01 … Continue reading

Posted in BUG | Tagged , , , , , , , , , , , , , | 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 , , , , , , , , | Leave a comment

ORA-600(kghfremptyds)和ORA-600(kghasp1)错误

客户在进行OLAP的导入时出现了这个错误。 数据库版本为10.2.0.3,除了这两个错误外,同时还出现了其他的错误: Mon Jul 30 23:49:08 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xAF509008], [], [], [], [], [], [] Mon Jul 30 23:49:09 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xAF50AF34], … Continue reading

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

ORA-7445(_kgscReleaseCursor)和ORA-4030错误

又一个ORA-4030引起的错误。 数据库版本10.2.0.3 for Windows 64环境。错误信息为: Tue Mar 13 20:51:28 中国标准时间 2012 Errors IN file d:\oracle\admin\orcl\udump\orcl_ora_6136.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kgscReleaseCursor+174] [PC:0x423AA92] [ADDR:0xC] [UNABLE_TO_READ] [] ORA-04030: 在尝试分配 244 字节 (kxs-heap-w,kntx.1) 时进程内存不足 Tue Mar 13 20:51:32 中国标准时间 2012 Errors IN file d:\oracle\admin\orcl\udump\orcl_ora_6136.trc: … Continue reading

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

ORA-7445(dbgrlWriteAlertDetail_int)和ORA-4030导致实例崩溃

客户11.2.0.2 RAC for Solaris 10 sparc单实例出现ORA-7445和ORA-4030操作,导致实例崩溃。 这个错误比较严重: 2012-05-04 02:02:26.403000 +08:00 Archived Log entry 949 added FOR thread 1 SEQUENCE 518 ID 0x70a64e83 dest 1: Archived Log entry 950 added FOR thread 1 SEQUENCE 519 ID 0x70a64e83 dest 1: Thread 1 … Continue reading

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

ORA-610内部错误

ORA-600内部错误司空见惯了,这个ORA-610的内部错误还是第一次见到。 完整的相关错误信息如下: Wed Jun 22 10:01:08 2011 Errors IN file /oracle10g/admin/orcl/bdump/orcl_ora_27376.trc: ORA-00610: Internal error code Wed Jun 22 10:02:16 2011 WARNING: inbound connection timed OUT (ORA-3136) Wed Jun 22 10:05:02 2011 Process J000 died, see its trace file Wed Jun … Continue reading

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

Windows环境下的ORA-7445(ACCESS_VIOLATION)和ORA-4030错误

客户Windows环境下32位的Oracle 10.2.0.3,在告警日志中发现多次ORA-7445和ORA-4030错误信息。 详细信息为: Mon Aug 01 15:06:06 2011 Errors IN file e:\oradata\acscnprd\trc\usr\acscnprd_ora_3356.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x605033BB] [ADDR:0x4] [UNABLE_TO_WRITE] [] Mon Aug 01 15:06:06 2011 Errors IN file e:\oradata\acscnprd\trc\usr\acscnprd_ora_3356.trc: ORA-04030: OUT OF process memory WHEN trying TO … Continue reading

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