在WEB网站中,ORACLE 过一段时间就死掉了。下面是ORACLE日志。程序中用了定时器频繁操作数据库。
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Sun Jul 17 18:46:30 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:46:31 2011
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Sun Jul 17 18:46:42 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:46:43 2011
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Sun Jul 17 18:46:54 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:46:55 2011
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:47:00 2011
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_472.trc:Sun Jul 17 18:50:35 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:50:36 2011
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_472.trc:Sun Jul 17 18:52:06 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:52:07 2011
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_472.trc:Sun Jul 17 18:52:22 2011
DDE: Problem Key 'ORA 4030' was completely flood controlled (0x6)
Further messages for this problem key will be suppressed for up to 10 minutes
Sun Jul 17 18:53:28 2011
Restarting dead background process DIA0
Sun Jul 17 18:53:28 2011
DIA0 started with pid=20, OS id=5180
Sun Jul 17 18:55:46 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xC] [PC:0x6CC9041, _clsdcxini()+61]
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_m000_2896.trc (incident=115069):
ORA-07445: exception encountered: core dump [clsdcxini()+61] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x6CC9041] [UNABLE_TO_READ] []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_115069\orcl_m000_2896_i115069.trc
Sun Jul 17 18:55:46 2011
Process m000 died, see its trace file
Sun Jul 17 18:55:46 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xC] [PC:0x6CC9041, _clsdcxini()+61]
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_m000_4236.trc (incident=115077):
ORA-07445: exception encountered: core dump [clsdcxini()+61] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x6CC9041] [UNABLE_TO_READ] []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_115077\orcl_m000_4236_i115077.trc
Process m000 died, see its trace file
Sun Jul 17 18:58:08 2011
Restarting dead background process DIA0
Sun Jul 17 18:58:08 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process DIA0 died, see its trace file
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_pmon_3544.trc:
ORA-00443: background process "DIA0" did not start
Sun Jul 17 19:00:02 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 19:00:02 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_lgwr_4068.trc (incident=108676):
ORA-04030: out of process memory when trying to allocate 82444 bytes (pga heap,control file i/o buffer)
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_lgwr_4068.trc:
ORA-04030: out of process memory when trying to allocate 82444 bytes (pga heap,control file i/o buffer)
LGWR (ospid: 4068): terminating the instance due to error 4030
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_pmon_3544.trc (incident=108604):
ORA-04030: out of process memory when trying to allocate bytes (,)
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4124.trc (incident=109172):
ORA-04030: 鍦ㄥ皾璇曞垎閰? 瀛楄妭 (,) 鏃惰繘绋嬪唴瀛樹笉瓒?
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmnl_4996.trc (incident=108716):
ORA-04030: out of process memory when trying to allocate bytes (,)
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4084.trc (incident=109092):
ORA-04030: 鍦ㄥ皾璇曞垎閰? 瀛楄妭 (,) 鏃惰繘绋嬪唴瀛樹笉瓒?
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_s000_5660.trc (incident=108732):
ORA-04030: out of process memory when trying to allocate bytes (,)
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_s000_5660.trc (incident=108733):
ORA-04030: out of process memory when trying to allocate bytes (,)
ORA-04030: out of process memory when trying to allocate bytes (,)
ORA-4030 : opidrv aborting process S000 ospid (1316_5660)
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_diag_4296.trc (incident=108620):
ORA-04030: out of process memory when trying to allocate bytes (,)
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_reco_1464.trc (incident=108700):
ORA-04030: out of process memory when trying to allocate bytes (,)
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_472.trc (incident=108740):
ORA-04030: out of process memory when trying to allocate bytes (,)
ORA-04030: out of process memory when trying to allocate ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)
ORA-04030: out of process memory when trying to allocate ORA-04030: out of process memory when trying to allocate 64528 bytes (sort subheap,sort key)
bytes (,)
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Sun Jul 17 18:46:30 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:46:31 2011
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Sun Jul 17 18:46:42 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:46:43 2011
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Sun Jul 17 18:46:54 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:46:55 2011
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process W000 died, see its trace file
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:47:00 2011
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_472.trc:Sun Jul 17 18:50:35 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:50:36 2011
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_472.trc:Sun Jul 17 18:52:06 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 18:52:07 2011
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_472.trc:Sun Jul 17 18:52:22 2011
DDE: Problem Key 'ORA 4030' was completely flood controlled (0x6)
Further messages for this problem key will be suppressed for up to 10 minutes
Sun Jul 17 18:53:28 2011
Restarting dead background process DIA0
Sun Jul 17 18:53:28 2011
DIA0 started with pid=20, OS id=5180
Sun Jul 17 18:55:46 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xC] [PC:0x6CC9041, _clsdcxini()+61]
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_m000_2896.trc (incident=115069):
ORA-07445: exception encountered: core dump [clsdcxini()+61] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x6CC9041] [UNABLE_TO_READ] []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_115069\orcl_m000_2896_i115069.trc
Sun Jul 17 18:55:46 2011
Process m000 died, see its trace file
Sun Jul 17 18:55:46 2011
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xC] [PC:0x6CC9041, _clsdcxini()+61]
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_m000_4236.trc (incident=115077):
ORA-07445: exception encountered: core dump [clsdcxini()+61] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x6CC9041] [UNABLE_TO_READ] []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_115077\orcl_m000_4236_i115077.trc
Process m000 died, see its trace file
Sun Jul 17 18:58:08 2011
Restarting dead background process DIA0
Sun Jul 17 18:58:08 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Process DIA0 died, see its trace file
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_pmon_3544.trc:
ORA-00443: background process "DIA0" did not start
Sun Jul 17 19:00:02 2011
Process startup failed, error stack:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_psp0_2488.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: ssthrddcr
Sun Jul 17 19:00:02 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_lgwr_4068.trc (incident=108676):
ORA-04030: out of process memory when trying to allocate 82444 bytes (pga heap,control file i/o buffer)
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_lgwr_4068.trc:
ORA-04030: out of process memory when trying to allocate 82444 bytes (pga heap,control file i/o buffer)
LGWR (ospid: 4068): terminating the instance due to error 4030
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_pmon_3544.trc (incident=108604):
ORA-04030: out of process memory when trying to allocate bytes (,)
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4124.trc (incident=109172):
ORA-04030: 鍦ㄥ皾璇曞垎閰? 瀛楄妭 (,) 鏃惰繘绋嬪唴瀛樹笉瓒?
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmnl_4996.trc (incident=108716):
ORA-04030: out of process memory when trying to allocate bytes (,)
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4084.trc (incident=109092):
ORA-04030: 鍦ㄥ皾璇曞垎閰? 瀛楄妭 (,) 鏃惰繘绋嬪唴瀛樹笉瓒?
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_s000_5660.trc (incident=108732):
ORA-04030: out of process memory when trying to allocate bytes (,)
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_s000_5660.trc (incident=108733):
ORA-04030: out of process memory when trying to allocate bytes (,)
ORA-04030: out of process memory when trying to allocate bytes (,)
ORA-4030 : opidrv aborting process S000 ospid (1316_5660)
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_diag_4296.trc (incident=108620):
ORA-04030: out of process memory when trying to allocate bytes (,)
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_reco_1464.trc (incident=108700):
ORA-04030: out of process memory when trying to allocate bytes (,)
Sun Jul 17 19:00:03 2011
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_472.trc (incident=108740):
ORA-04030: out of process memory when trying to allocate bytes (,)
ORA-04030: out of process memory when trying to allocate ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)
ORA-04030: out of process memory when trying to allocate ORA-04030: out of process memory when trying to allocate 64528 bytes (sort subheap,sort key)
bytes (,)
解决方案 »
- update更新两条数据怎么写呀
- ora-01017 invalid username/password;logon denied
- oracle 查询语句的编写 拜托各位~~~~~
- DBA一般用什么oracle工具来进行备份、查看执行计划等等工作?
- Oracle中如何忽略找不到数据的错误(错误处理还在)
- 关于不同操作系统下查询窗口自动跳出的问题
- 从本地导入数据到服务器数据库中的problem
- 如何查看存储过程的输出值
- 存储过程中drop 其他用户表,权限不足,why
- ★急问!!!oracle的OracleOraHome81Agent启动不了,提示:错误3221356551.
- 很简单一个存储过程,目的是想在第一条语句触发异常后,继续执行下面语句,不知道如何实现这样的功能。
- 100分!!关于SQL事务与回滚!!
32位window机器有单进程限制的。 通过调整 sga_target 和pga来解决还有是 适当调整sessions 和process 加大点看看