新手请教:Oracle服务器隔几天Down一次,怎么分析?

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

1.相关表做一下优化.
2.几个系统表空间加大.

貌似系统资源有问题， 这个看下系统的日志吧。 windows 下的Oracle 没啥搞头。