Tag Archives: ORA-7445

同一个SQL引发多个ORA-7445错误

Posted on 2011/12/14 by yangtingkun

在客户的Oracle 9204 RAC for Linux x86环境中，发现同一SQL引发了多个ORA-7445错误。 节点1上错误信息为： Wed Nov 30 14:19:38 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8519.trc: ORA-07445: exception encountered: core dump [kghalf()+743] [SIGSEGV] [Address NOT mapped TO object] [0x1FE0] [] [] . . . Thu DEC 1 16:09:03 2011 Errors … Continue reading →

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

ORA-7445(kglLockIterator)错误

Posted on 2011/12/09 by yangtingkun

在客户的10.2.0.3环境中发现这个错误。 告警日志中错误为： Mon Sep 20 10:21:04 2010 Errors IN file /home/oracle/admin/ARIC/udump/aric_ora_3776.trc: ORA-07445: exception encountered: core dump [SIGSEGV] [Address NOT mapped TO object] [4294967377] [] [] []Mon Sep 20 10:21:04 2010 Errors in file /home/oracle/admin/ARIC/udump/aric_ora_3776.trc: ORA-07445: exception encountered: core dump [SIGSEGV] … Continue reading →

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

ORA-7445(qerixGetKey)错误

Posted on 2011/12/06 by yangtingkun

执行并行查询时碰到的问题。 错误信息如下： Wed Sep 28 18:03:47 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_p001_8093.trc: ORA-07445: exception encountered: core dump [SIGSEGV] [Address NOT mapped TO object] [21] [] [] [] Wed Sep 28 18:03:47 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_p000_8091.trc: ORA-07445: exception encountered: core dump … Continue reading →

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

ORA-7445($cold_qerfxArrayMaxSize)错误

Posted on 2011/11/25 by yangtingkun

客户的数据库告警日志中出现这个错误。 详细错误信息如下： Wed Oct 26 15:38:14 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_8209.trc: ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+15264] [SIGSEGV] [Address NOT mapped TO object] [0x000003058] [] [] Wed Oct 26 15:38:27 2011 Errors IN file /oracleapp/oracle10g/admin/ora10/udump/ora10_ora_8209.trc: ORA-00081: address range [0x6000000000127430, 0x6000000000127434) … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-7445(kgegec)错误

Posted on 2011/11/20 by yangtingkun

客户数据库出现大量的ORA-7445错误。 这是一个11.1.0.6 for Windows 64bit的环境，在告警日志中包含了大量的ORA-7445错误： Thu Nov 10 00:00:43 2011 Exception [TYPE: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x75A20BE, kgegec()+76] Thu Nov 10 00:00:43 2011 Exception [TYPE: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x75A20BE, kgegec()+76] Thu Nov 10 00:00:43 2011 Errors IN file d:\app\administrator\diag\rdbms\gvdb\gvdb\cdump\gvdbcore.log ORA-07445: caught … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-7445(sigsetjmp)错误

Posted on 2011/11/14 by yangtingkun

客户数据库中出现ORA-7445错误，导致错误的SQL在访问V$ACCESS视图。 错误信息如下： Sun Sep 19 17:15:17 2010 Errors IN file /home/oracle/admin/ARIC/udump/aric_ora_26489.trc: ORA-07445: exception encountered: core dump [SIGSEGV] [Address NOT mapped TO object] [0] [] [] []Sun Sep 19 17:15:17 2010 Errors in file /home/oracle/admin/ARIC/udump/aric_ora_26489.trc: ORA-07445: exception encountered: core dump [SIGSEGV] … Continue reading →

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

ORA-600(2037)错误

Posted on 2011/11/09 by yangtingkun

最近已经碰到多起客户数据库无法打开的情况，这就是其中一次。 这是一个10201 for Windows 64bit数据库，在一次掉电后，数据库无法启动，在后台告警日志中出现下列的错误： Mon Oct 31 00:00:28 2011 ALTER DATABASE OPEN Mon Oct 31 00:00:28 2011 Beginning crash recovery OF 1 threads parallel recovery started WITH 16 processes Mon Oct 31 00:00:28 2011 Started redo scan Mon Oct … Continue reading →

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

ORA-7445(qeshIHInsertPRowInBkt)错误

Posted on 2011/10/07 by yangtingkun

客户数据库告警日志出现了这个错误信息。 错误信息如下： Fri Mar 18 09:52:26 2011 Errors IN file /oracle/db/admin/B1EDB/udump/b1edb_ora_20076.trc: ORA-07445: exception encountered: core dump [qeshIHInsertPRowInBkt()+48] [SIGSEGV] [Address NOT mapped TO object] [0x000B2B7B0] [] []Fri Mar 18 09:52:26 2011 Errors in file /oracle/db/admin/B1EDB/udump/b1edb_ora_20076.trc: ORA-07445: exception encountered: core dump [qeshIHInsertPRowInBkt()+48] … Continue reading →

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

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

Posted on 2011/10/06 by yangtingkun

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