遇到数据库异常宕机,还请各位指点下。谢谢!
现将出现问题的alter.log贴出:
Process startup failed, error stack:
Thu Feb 02 08:03:39 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_psp0_2252.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 5
ORA-27301: OS failure message: 拒绝访问。
ORA-27302: failure occurred at: skgpspawn
Thu Feb 02 08:03:40 2012
Process m000 died, see its trace file
Thu Feb 02 08:03:40 2012
ksvcreate: Process(m000) creation failed
Thu Feb 02 08:04:40 2012
Process startup failed, error stack:
Thu Feb 02 08:04:40 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_psp0_2252.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 5
ORA-27301: OS failure message: 拒绝访问。
ORA-27302: failure occurred at: skgpspawn
Thu Feb 02 08:04:41 2012
Process m000 died, see its trace file
Thu Feb 02 08:04:41 2012
ksvcreate: Process(m000) creation failed
Process startup failed, error stack:
Thu Feb 02 08:05:41 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_psp0_2252.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 6
ORA-27301: OS failure message: 句柄无效。
ORA-27302: failure occurred at: skgpspawn
Thu Feb 02 08:05:42 2012
Process m000 died, see its trace file
Thu Feb 02 08:05:42 2012
ksvcreate: Process(m000) creation failed
System State dumped to trace file d:\oracle\product\10.2.0\admin\resp\bdump\resp_mmon_2284.trc
Thu Feb 02 08:07:03 2012
Restarting dead background process MMON
MMON started with pid=11, OS id=4512
Thu Feb 02 08:07:06 2012
Process startup failed, error stack:
Thu Feb 02 08:07:06 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_psp0_2252.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 5
ORA-27301: OS failure message: 拒绝访问。
ORA-27302: failure occurred at: skgpspawn
Thu Feb 02 08:07:07 2012
Process m000 died, see its trace file
Thu Feb 02 08:07:07 2012
ksvcreate: Process(m000) creation failed
Thu Feb 02 08:11:36 2012
kkjcre1p: unable to spawn jobq slave process
Thu Feb 02 08:11:36 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_cjq0_2280.trc:
Thu Feb 02 08:12:16 2012
Process startup failed, error stack:
Thu Feb 02 08:12:16 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_psp0_2252.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 6
ORA-27301: OS failure message: 句柄无效。
ORA-27302: failure occurred at: skgpspawn
Thu Feb 02 08:12:17 2012
Process J000 died, see its trace file
Thu Feb 02 08:12:17 2012
kkjcre1p: unable to spawn jobq slave process
Thu Feb 02 08:12:17 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_cjq0_2280.trc:
Process startup failed, error stack:
Thu Feb 02 08:33:32 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_psp0_2252.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 5
ORA-27301: OS failure message: 拒绝访问。
ORA-27302: failure occurred at: skgpspawn
Process J000 died, see its trace file
Thu Feb 02 08:33:33 2012
kkjcre1p: unable to spawn jobq slave process
Thu Feb 02 08:33:33 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_cjq0_2280.trc:
Thu Feb 02 08:34:13 2012
Process startup failed, error stack:
Thu Feb 02 08:34:13 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_psp0_2252.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 6
ORA-27301: OS failure message: 句柄无效。
ORA-27302: failure occurred at: skgpspawn
Process J000 died, see its trace file
Thu Feb 02 08:34:14 2012
kkjcre1p: unable to spawn jobq slave process
Thu Feb 02 08:34:14 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_cjq0_2280.trc:
Thu Feb 02 09:24:34 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_psp0_2252.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 5
ORA-27301: OS failure message: 拒绝访问。
ORA-27302: failure occurred at: skgpspawn
Thu Feb 02 09:24:35 2012
Process m000 died, see its trace file
Thu Feb 02 09:24:35 2012
ksvcreate: Process(m000) creation failed
Thu Feb 02 10:13:49 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_cjq0_2280.trc:
ORA-27300: OS system dependent operation:CreateThread failed with status: 8
ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
ORA-27302: failure occurred at: sssxcpttcs4
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_ora_5152.trc:
ORA-00610: Internal error code
Thu Feb 02 10:14:20 2012
kkjcre1p: unable to spawn jobq slave process
Thu Feb 02 10:14:20 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_cjq0_2280.trc:
Process J000 died, see its trace file
Thu Feb 02 10:15:47 2012
kkjcre1p: unable to spawn jobq slave process
Thu Feb 02 10:15:47 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_cjq0_2280.trc:
Thu Feb 02 10:34:11 2012
Process startup failed, error stack:
Thu Feb 02 10:34:11 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_psp0_2252.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 5
ORA-27301: OS failure message: 拒绝访问。
ORA-27302: failure occurred at: skgpspawn
Thu Feb 02 10:34:12 2012
Process J000 died, see its trace file
Thu Feb 02 10:34:12 2012
kkjcre1p: unable to spawn jobq slave process
Thu Feb 02 10:34:12 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_cjq0_2280.trc:
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_psp0_2252.trc:
ORA-09314: sltln: error translating logical name
OSD-04503: Message 4503 not found; No message file for product=RDBMS, facility=SOSD
Thu Feb 02 11:00:53 2012
PSP0: terminating instance due to error 9314
Thu Feb 02 11:00:54 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_pmon_2248.trc:
ORA-09314: sltln: error translating logical name
Thu Feb 02 11:00:54 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_ckpt_2268.trc:
ORA-09314: sltln: error translating logical name
Thu Feb 02 11:00:54 2012
Error occured while spawning process m000; error = 9314
Thu Feb 02 11:00:56 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_mman_2256.trc:
ORA-09314: sltln: error translating logical name
Thu Feb 02 11:00:56 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_dbw0_2260.trc:
ORA-09314: sltln: error translating logical name
Thu Feb 02 11:01:11 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_q001_3016.trc:
ORA-09314: sltln: error translating logical name
Thu Feb 02 11:01:14 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_reco_2276.trc:
ORA-09314: sltln: error translating logical name
Thu Feb 02 11:01:14 2012
Errors in file d:\oracle\product\10.2.0\admin\resp\bdump\resp_smon_2272.trc:
ORA-09314: sltln: error translating logical name
Thu Feb 02 11:01:16 2012
Instance terminated by PSP0, pid = 2252
Thu Feb 02 13:34:07 2012
WARNING: inbound connection timed out (ORA-3136)
|