数据库异常宕机

[复制链接]
查看11 | 回复9 | 2013-2-25 14:51:24 | 显示全部楼层 |阅读模式
遇到数据库异常宕机,还请各位指点下。谢谢!
现将出现问题的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)

回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
像是OS的问题~也可能是存储的问题
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
iori809 发表于 2012-2-2 16:58
像是OS的问题~也可能是存储的问题

在发生宕机的时刻操作系统事件中看到有磁盘上文件系统损坏不能使用的错误,但重启之后又没事了
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
weipeng415 发表于 2012-2-2 17:05
在发生宕机的时刻操作系统事件中看到有磁盘上文件系统损坏不能使用的错误,但重启之后又没事了

首先确认是本地磁盘还是存储~
然后进一步诊断
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
iori809 发表于 2012-2-2 17:12
首先确认是本地磁盘还是存储~
然后进一步诊断

就是本地磁盘
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
本帖最后由 sundog315 于 2012-2-2 17:22 编辑
Troubleshooting ORA-27300 ORA-27301 ORA-27302 errors [ID 579365.1]
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
weipeng415 发表于 2012-2-2 17:16
就是本地磁盘

那就看看有没有坏道~硬盘灯是否报警
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
sundog315 发表于 2012-2-2 17:21
Troubleshooting ORA-27300 ORA-27301 ORA-27302 errors

系统是XP的,Oracle是10.2.0.1
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
本帖最后由 weipeng415 于 2012-2-2 17:29 编辑
iori809 发表于 2012-2-2 17:21
那就看看有没有坏道~硬盘灯是否报警

我开始去登录电脑,输入密码登录的时刻报错,就重启了,重启后没发现异常
回复

使用道具 举报

千问 | 2013-2-25 14:51:24 | 显示全部楼层
检查下权限,数据库文件,看看是否都正常
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行