现有一数据中心用oracle数据库，经常出现故障，直接导致无法登陆，昨晚又不行了，检查alert日志，摘抄如下：
Tue Nov 28 00:59:46 2006
ksbsrv: No startup acknowledgement from forked process after 30 seconds
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
Tue Nov 28 01:03:47 2006
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
Tue Nov 28 01:06:37 2006
Thread 1 advanced to log sequence 13329
Current log# 16 seq# 13329 mem# 0: Z:\\ORADATA\\HZDC01\\REDO16.LOG
Tue Nov 28 01:08:01 2006
Thread 1 advanced to log sequence 13330
Current log# 17 seq# 13330 mem# 0: Z:\\ORADATA\\HZDC01\\REDO17.LOG
Tue Nov 28 04:00:05 2006
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
Tue Nov 28 04:02:59 2006
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
Tue Nov 28 04:59:59 2006
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
Tue Nov 28 05:04:26 2006
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
Dump file c:\\oracle92\\admin\\hzdc01\\bdump\\alert_hzdc01.log
Tue Nov 28 08:03:52 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Nov 28 08:03:52 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes
= 1500
timed_statistics = TRUE
shared_pool_size = 318767104
sga_max_size
= 1596532696
shared_pool_reserved_size= 31457280
large_pool_size
= 25165824
java_pool_size = 33554432
trace_enabled
= FALSE
control_files
= z:\\oradata\\HZDC01\\CONTROL01.CTL, z:\\oradata\\HZDC01\\CONTROL02.CTL, z:\\oradata\\HZDC01\\CONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 1157627904
compatible
= 9.2.0.0.0
log_buffer
= 2097152
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 18000
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= HZDC01
dispatchers
= (PROTOCOL=TCP) (SERVICE=HZDC01XDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = C:\\Oracle92\\admin\\HZDC01\\bdump
user_dump_dest = C:\\Oracle92\\admin\\HZDC01\\udump
core_dump_dest = C:\\Oracle92\\admin\\HZDC01\\cdump
sort_area_size = 524288
db_name
= HZDC01
open_cursors
= 700
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 524288000
aq_tm_processes
= 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 28 08:03:56 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address \'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))\'...
Tue Nov 28 08:03:56 2006
alter database mount exclusive
Tue Nov 28 08:04:00 2006
Successful mount of redo thread 1, with mount id 3161266604.
Tue Nov 28 08:04:00 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Nov 28 08:04:00 2006
alter database open
Tue Nov 28 08:04:03 2006
Beginning crash recovery of 1 threads
Tue Nov 28 08:04:03 2006
Started first pass scan
Tue Nov 28 08:04:03 2006
Completed first pass scan
4614 redo blocks read, 110 data blocks need recovery
Tue Nov 28 08:04:03 2006
Started recovery at
Thread 1: logseq 13330, block 106752, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 17 Seq 13330 Reading mem 0
Mem# 0 errs 0: Z:\\ORADATA\\HZDC01\\REDO17.LOG
Tue Nov 28 08:04:03 2006
Ended recovery at
Thread 1: logseq 13330, block 111366, scn 2077.1843067885
110 data blocks read, 110 data blocks written, 4614 redo blocks read
Crash recovery completed successfully
Tue Nov 28 08:04:05 2006
Thread 1 advanced to log sequence 13331
Thread 1 opened at log sequence 13331
Current log# 18 seq# 13331 mem# 0: Z:\\ORADATA\\HZDC01\\REDO18.LOG
Successful open of redo thread 1.
Tue Nov 28 08:04:07 2006
SMON: enabling cache recovery
Tue Nov 28 08:04:07 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Nov 28 08:04:09 2006
SMON: enabling tx recovery
Tue Nov 28 08:04:09 2006
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Tue Nov 28 08:08:10 2006
Thread 1 advanced to log sequence 13332
Current log# 19 seq# 13332 mem# 0: Z:\\ORADATA\\HZDC01\\REDO19.LOG
数据库所在主机是一台惠普小型机，4个3G cpu,主机内存3G, 操作系统为Windows 2003
数据库SGA配置如下：
Total System Global Area 1596532696 bytes
Fixed Size
456664 bytes
Variable Size
436207616 bytes
Database Buffers 1157627904 bytes
Redo Buffers
2240512 bytes
求各位高手给分析一下，该如何解决？谢谢
|
