新手请教:Oracle服务器隔几天Down一次,怎么分析?
时间:2011-09-30
来源:互联网
Oracle服务器隔几天Down一次,
出现问题的时候Oracle服务Down了,
XP系统打开其他应用窗口都失败,只能重启电脑.
我是新手,请教各位达人,问题如何定位.
Thread 1 advanced to log sequence 7948
Current log# 1 seq# 7948 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\PSCDR\REDO01.LOG
Thu Sep 29 07:45:56 2011
***********************************************************************
Fatal NI connect error 12560, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production
Time: 29-SEP-2011 07:45:56
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
ORA-609 : opiodr aborting process unknown ospid (596_3528)
Thu Sep 29 07:50:53 2011
Errors in file e:\app\administrator\diag\rdbms\pscdr\pscdr\trace\pscdr_psp0_392.trc:
ORA-09314: sltln: error translating logical name
OSD-04503: Message 4503 not found; No message file for product=RDBMS, facility=SOSD
PSP0 (ospid: 392): terminating the instance due to error 9314
Thu Sep 29 07:50:53 2011
Error occured while spawning process J000; error = 9314
Thu Sep 29 07:50:55 2011
ORA-1092 : opiodr aborting process unknown ospid (596_3720)
Thu Sep 29 07:50:55 2011
Errors in file e:\app\administrator\diag\rdbms\pscdr\pscdr\trace\pscdr_q000_2488.trc:
ORA-09314: sltln: error translating logical name
ORA-1092 : opidrv aborting process Q000 ospid (596_2488)
Thu Sep 29 07:50:56 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:50:56 2011
Non critical error ORA-00001 caught while writing to trace file "e:\app\administrator\diag\rdbms\pscdr\pscdr\trace\pscdr_s000_1844.trc"
Error message: OSD-00001: Message 1 not found; No message file for product=RDBMS, facility=SOSD
O/S-Error: (OS 1450) 系统资源不足,无法完成请求的服务。
Writing to the above trace file is disabled for now on...
Thu Sep 29 07:50:57 2011
Non critical error ORA-00001 caught while writing to trace metadata file (.trm)
Trace file name: "e:\app\administrator\diag\rdbms\pscdr\pscdr\trace\pscdr_dbw0_1004.trc"
Error message: OSD-00001: Message 1 not found; No message file for product=RDBMS, facility=SOSD
O/S-Error: (OS 1450) 系统资源不足,无法完成请求的服务。
Writing to trace metadata is disabled for now on...
ORA-9314 : opidrv aborting process S000 ospid (596_1844)
Thu Sep 29 07:50:57 2011
ORA-1092 : opidrv aborting process W000 ospid (596_3452)
Thu Sep 29 07:50:55 2011
ORA-1092 : opiodr aborting process unknown ospid (596_980)
Thu Sep 29 07:50:57 2011
Non critical error DIA-00001 caught while writing to trace metadata file (.trm)
Trace file name: "e:\app\administrator\diag\rdbms\pscdr\pscdr\trace\pscdr_d000_1812.trc"
Error message: OSD-00001: Message 1 not found; No message file for product=RDBMS, facility=SOSD
O/S-Error: (OS 1450) 系统资源不足,无法完成请求的服务。
Writing to trace metadata is disabled for now on...
Thu Sep 29 07:50:57 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:51:04 2011
ORA-1092 : opiodr aborting process unknown ospid (596_3168)
Thu Sep 29 07:51:04 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:51:04 2011
ORA-1092 : opiodr aborting process unknown ospid (596_2976)
Thu Sep 29 07:51:04 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:51:04 2011
ORA-1092 : opiodr aborting process unknown ospid (596_2936)
Thu Sep 29 07:51:04 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:51:04 2011
ORA-1092 : opiodr aborting process unknown ospid (596_2512)
Thu Sep 29 07:51:04 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:51:16 2011
Instance terminated by PSP0, pid = 392
出现问题的时候Oracle服务Down了,
XP系统打开其他应用窗口都失败,只能重启电脑.
我是新手,请教各位达人,问题如何定位.
Thread 1 advanced to log sequence 7948
Current log# 1 seq# 7948 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\PSCDR\REDO01.LOG
Thu Sep 29 07:45:56 2011
***********************************************************************
Fatal NI connect error 12560, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production
Time: 29-SEP-2011 07:45:56
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
ORA-609 : opiodr aborting process unknown ospid (596_3528)
Thu Sep 29 07:50:53 2011
Errors in file e:\app\administrator\diag\rdbms\pscdr\pscdr\trace\pscdr_psp0_392.trc:
ORA-09314: sltln: error translating logical name
OSD-04503: Message 4503 not found; No message file for product=RDBMS, facility=SOSD
PSP0 (ospid: 392): terminating the instance due to error 9314
Thu Sep 29 07:50:53 2011
Error occured while spawning process J000; error = 9314
Thu Sep 29 07:50:55 2011
ORA-1092 : opiodr aborting process unknown ospid (596_3720)
Thu Sep 29 07:50:55 2011
Errors in file e:\app\administrator\diag\rdbms\pscdr\pscdr\trace\pscdr_q000_2488.trc:
ORA-09314: sltln: error translating logical name
ORA-1092 : opidrv aborting process Q000 ospid (596_2488)
Thu Sep 29 07:50:56 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:50:56 2011
Non critical error ORA-00001 caught while writing to trace file "e:\app\administrator\diag\rdbms\pscdr\pscdr\trace\pscdr_s000_1844.trc"
Error message: OSD-00001: Message 1 not found; No message file for product=RDBMS, facility=SOSD
O/S-Error: (OS 1450) 系统资源不足,无法完成请求的服务。
Writing to the above trace file is disabled for now on...
Thu Sep 29 07:50:57 2011
Non critical error ORA-00001 caught while writing to trace metadata file (.trm)
Trace file name: "e:\app\administrator\diag\rdbms\pscdr\pscdr\trace\pscdr_dbw0_1004.trc"
Error message: OSD-00001: Message 1 not found; No message file for product=RDBMS, facility=SOSD
O/S-Error: (OS 1450) 系统资源不足,无法完成请求的服务。
Writing to trace metadata is disabled for now on...
ORA-9314 : opidrv aborting process S000 ospid (596_1844)
Thu Sep 29 07:50:57 2011
ORA-1092 : opidrv aborting process W000 ospid (596_3452)
Thu Sep 29 07:50:55 2011
ORA-1092 : opiodr aborting process unknown ospid (596_980)
Thu Sep 29 07:50:57 2011
Non critical error DIA-00001 caught while writing to trace metadata file (.trm)
Trace file name: "e:\app\administrator\diag\rdbms\pscdr\pscdr\trace\pscdr_d000_1812.trc"
Error message: OSD-00001: Message 1 not found; No message file for product=RDBMS, facility=SOSD
O/S-Error: (OS 1450) 系统资源不足,无法完成请求的服务。
Writing to trace metadata is disabled for now on...
Thu Sep 29 07:50:57 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:51:04 2011
ORA-1092 : opiodr aborting process unknown ospid (596_3168)
Thu Sep 29 07:51:04 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:51:04 2011
ORA-1092 : opiodr aborting process unknown ospid (596_2976)
Thu Sep 29 07:51:04 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:51:04 2011
ORA-1092 : opiodr aborting process unknown ospid (596_2936)
Thu Sep 29 07:51:04 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:51:04 2011
ORA-1092 : opiodr aborting process unknown ospid (596_2512)
Thu Sep 29 07:51:04 2011
ORA-1092 : opitsk aborting process
Thu Sep 29 07:51:16 2011
Instance terminated by PSP0, pid = 392
作者: kelizhong 发布时间: 2011-09-30
1.相关表做一下优化.
2.几个系统表空间加大.
2.几个系统表空间加大.
作者: dawugui 发布时间: 2011-09-30
貌似系统资源有问题, 这个看下系统的日志吧。 windows 下的Oracle 没啥搞头。
作者: tianlesoftware 发布时间: 2011-09-30
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28