Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why Oracle crashed when running?(ORA-04030)

895362Oct 19 2011 — edited Oct 19 2011

There are some application connected to Oracle, but Oracle crashed down one day. Trc file belows:
Dump file d:\oracle\product\10.2.0\admin\testdb\bdump\testdb_ckpt_3640.trc
Thu Oct 13 14:13:34 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1312M/4021M, Ph+PgF:3170M/5898M, VA:29M/2047M
Instance name: testdb

Redo thread mounted by this instance: 1

Oracle process number: 7

Windows thread id: 3640, image: ORACLE.EXE (CKPT)

*** 2011-10-13 14:13:34.890
*** SERVICE NAME:(SYS$BACKGROUND) 2011-10-13 14:13:34.875
*** SESSION ID:(550.1) 2011-10-13 14:13:34.875
error 4030 detected in background process
ORA-04030: 在尝试分配 8716 字节 (pga heap,Get krha asynch mem) 时进程内存不足
*** 2011-10-13 14:13:39.921 ssthreadkillsafe: skipping kill of tid=12372 (time out= 5000 ms) because thread has state SHUTTING_DOWN
*** 2011-10-13 14:14:15.765 ssthreadkillsafe: skipping kill of tid=13784 (time out= 5000 ms) because thread has state SHUTTING_DOWN

Edited by: 892359 on 2011-10-19 下午5:48

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2011

Added on Oct 19 2011

#general-database-discussions

2 comments

418 views