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
解决方案 »
- 【求助】Linux下安装和编译Oracle ASM Lib和Driver时出错
- 几十万数据的更新、新增效率问题
- 用PL/SQL写ORACLE存储过程或函数怎么在PL/SQL里调试
- pl/sql小疑问
- ORACLE启动问题,,,高分求救!!
- windows server 2003 安装oracle死机
- 关于Oracle 8i的SQL语句的问题?求高手指教
- 如何写两个表之间的外联查询语句,求语法!!
- 这个sql 该如何去实现最简单?
- asp.net中调用oracle 9i中的存储过程的请教
- oracle中用户授权的问题?
- oracle 10g scott/tiger登录 启动实例时 startup 提示 sp2-0310 无法打开数据库文件“up.sql”
貌似系统资源有问题, 这个看下系统的日志吧。 windows 下的Oracle 没啥搞头。
重装了Windows 2003,观察十几天,oracle至今没Down过。
多谢各位热心关注~~~~~~~~~~~