-
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: skgpspawn3
HPUX上出现ORA-27300、ORA-27301、ORA-27302的STATUS 11错误
数据库出现ORA-27300、ORA-27301和ORA-27302错误并最终出现ORA-29702错误，导致数据库实例的崩溃。 数据库版本为10.2.0.4 RAC for HP-UX，详细错误信息为： Wed Jun 27 04:31:07 2012 Process startup failed, error stack: Wed Jun 27 04:31:07 2012 Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl2_psp0_1943.trc: ORA-27300: OS system dependent operation:fork failed WITH STATUS: 11 ORA-27301: OS failure message: Resource temporarily unavailable … Continue reading
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
告警日志出现skgpspawn failed category 27142错误
客户的数据库告警日志出现skgpspawn failed信息。 详细错误信息如下： Mon Nov 28 07:59:59 2011 skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn5 skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3 skgpspawn failed:category = 27142, depinfo = … Continue reading
Posted in BUG
Tagged 27142, defunct Oracle processes, fork, ORA-27142, skgpspawn failed, skgpspawn3, skgpspawn5, SWAP
Leave a comment
ORA-27300 和skgpspawn3错误
以前碰到过类似的ORA-27300系列错误，问题都是和系统上错误有关，这次的问题也不例外。 详细错误信息如下： Tue May 17 22:01:04 2011 Process startup failed, error stack: Tue May 17 22:01:04 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_psp0_866.trc: ORA-27300: OS system dependent operation:fork failed WITH STATUS: 11 ORA-27301: OS failure message: Resource temporarily unavailable ORA-27302: failure occurred … Continue reading