最近系统运行一段时间,老是挂掉,检查是oracle的问题,用plsql登录马上出现无响应,关也关不掉.重启电脑又好了,系统可以运行,但是过一段又这样了,请问是怎么回事?
补充:这个系统已经运行一两年了,都没问题,是最近出的状况 alert.log内容部分如下:
at Nov 12 16:32:43 2011
Thread 1 advanced to log sequence 5592
Current log# 2 seq# 5592 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO02.LOG
Sun Nov 13 10:42:00 2011
Thread 1 advanced to log sequence 5593
Current log# 3 seq# 5593 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO03.LOG
Dump file d:\oracle\admin\ora92\bdump\alert_ora92.log
Mon Nov 14 08:21:58 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Mon Nov 14 08:21:58 2011
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 = 150
timed_statistics = TRUE
shared_pool_size = 268435456
sga_max_size = 1074864892
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\ora92\CONTROL01.CTL, D:\oracle\oradata\ora92\CONTROL02.CTL, D:\oracle\oradata\ora92\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 536870912
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora92
dispatchers = (PROTOCOL=TCP) (SERVICE=ora92XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\ora92\bdump
user_dump_dest = D:\oracle\admin\ora92\udump
core_dump_dest = D:\oracle\admin\ora92\cdump
sort_area_size = 524288
db_name = ora92
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 134217728
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
Mon Nov 14 08:22:02 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Nov 14 08:22:03 2011
alter database mount exclusive
Mon Nov 14 08:22:08 2011
Successful mount of redo thread 1, with mount id 2079197739.
Mon Nov 14 08:22:08 2011
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Nov 14 08:22:08 2011
alter database open
Mon Nov 14 08:22:09 2011
Beginning crash recovery of 1 threads
Mon Nov 14 08:22:09 2011
Started first pass scan
Mon Nov 14 08:22:09 2011
Completed first pass scan
3381 redo blocks read, 65 data blocks need recovery
Mon Nov 14 08:22:09 2011
Started recovery at
Thread 1: logseq 5593, block 141903, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 5593 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORA92\REDO03.LOG
Mon Nov 14 08:22:10 2011
Ended recovery at
Thread 1: logseq 5593, block 145284, scn 0.395305724
65 data blocks read, 65 data blocks written, 3381 redo blocks read
Crash recovery completed successfully
Mon Nov 14 08:22:10 2011
Thread 1 advanced to log sequence 5594
Thread 1 opened at log sequence 5594
Current log# 1 seq# 5594 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO01.LOG
Successful open of redo thread 1.
Mon Nov 14 08:22:11 2011
SMON: enabling cache recovery
Mon Nov 14 08:22:12 2011
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.
Mon Nov 14 08:22:12 2011
SMON: enabling tx recovery
Mon Nov 14 08:22:12 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Mon Nov 14 10:02:07 2011
Thread 1 advanced to log sequence 5595
Current log# 2 seq# 5595 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO02.LOG
Mon Nov 14 12:22:03 2011
Thread 1 advanced to log sequence 5596
Current log# 3 seq# 5596 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO03.LOG
Dump file d:\oracle\admin\ora92\bdump\alert_ora92.log
Mon Nov 14 13:48:59 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Mon Nov 14 13:48:59 2011
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 = 150
timed_statistics = TRUE
shared_pool_size = 268435456
sga_max_size = 1074864892
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\ora92\CONTROL01.CTL, D:\oracle\oradata\ora92\CONTROL02.CTL, D:\oracle\oradata\ora92\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 536870912
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora92
dispatchers = (PROTOCOL=TCP) (SERVICE=ora92XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\ora92\bdump
user_dump_dest = D:\oracle\admin\ora92\udump
core_dump_dest = D:\oracle\admin\ora92\cdump
sort_area_size = 524288
db_name = ora92
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 134217728
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
Mon Nov 14 13:49:04 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Nov 14 13:49:06 2011
alter database mount exclusive
Mon Nov 14 13:49:11 2011
Successful mount of redo thread 1, with mount id 2079194578.
Mon Nov 14 13:49:11 2011
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Nov 14 13:49:11 2011
alter database open
Mon Nov 14 13:49:12 2011
Beginning crash recovery of 1 threads
Mon Nov 14 13:49:12 2011
Started first pass scan
Mon Nov 14 13:49:13 2011
Completed first pass scan
15308 redo blocks read, 460 data blocks need recovery
Mon Nov 14 13:49:13 2011
Started recovery at
Thread 1: logseq 5596, block 44170, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 5596 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORA92\REDO03.LOG
Mon Nov 14 13:49:14 2011
Ended recovery at
Thread 1: logseq 5596, block 59478, scn 0.395387488
460 data blocks read, 460 data blocks written, 15308 redo blocks read
Crash recovery completed successfully
Mon Nov 14 13:49:15 2011
Thread 1 advanced to log sequence 5597
Thread 1 opened at log sequence 5597
Current log# 1 seq# 5597 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO01.LOG
Successful open of redo thread 1.
Mon Nov 14 13:49:16 2011
SMON: enabling cache recovery
Mon Nov 14 13:49:17 2011
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.
Mon Nov 14 13:49:17 2011
SMON: enabling tx recovery
补充:这个系统已经运行一两年了,都没问题,是最近出的状况 alert.log内容部分如下:
at Nov 12 16:32:43 2011
Thread 1 advanced to log sequence 5592
Current log# 2 seq# 5592 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO02.LOG
Sun Nov 13 10:42:00 2011
Thread 1 advanced to log sequence 5593
Current log# 3 seq# 5593 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO03.LOG
Dump file d:\oracle\admin\ora92\bdump\alert_ora92.log
Mon Nov 14 08:21:58 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Mon Nov 14 08:21:58 2011
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 = 150
timed_statistics = TRUE
shared_pool_size = 268435456
sga_max_size = 1074864892
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\ora92\CONTROL01.CTL, D:\oracle\oradata\ora92\CONTROL02.CTL, D:\oracle\oradata\ora92\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 536870912
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora92
dispatchers = (PROTOCOL=TCP) (SERVICE=ora92XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\ora92\bdump
user_dump_dest = D:\oracle\admin\ora92\udump
core_dump_dest = D:\oracle\admin\ora92\cdump
sort_area_size = 524288
db_name = ora92
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 134217728
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
Mon Nov 14 08:22:02 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Nov 14 08:22:03 2011
alter database mount exclusive
Mon Nov 14 08:22:08 2011
Successful mount of redo thread 1, with mount id 2079197739.
Mon Nov 14 08:22:08 2011
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Nov 14 08:22:08 2011
alter database open
Mon Nov 14 08:22:09 2011
Beginning crash recovery of 1 threads
Mon Nov 14 08:22:09 2011
Started first pass scan
Mon Nov 14 08:22:09 2011
Completed first pass scan
3381 redo blocks read, 65 data blocks need recovery
Mon Nov 14 08:22:09 2011
Started recovery at
Thread 1: logseq 5593, block 141903, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 5593 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORA92\REDO03.LOG
Mon Nov 14 08:22:10 2011
Ended recovery at
Thread 1: logseq 5593, block 145284, scn 0.395305724
65 data blocks read, 65 data blocks written, 3381 redo blocks read
Crash recovery completed successfully
Mon Nov 14 08:22:10 2011
Thread 1 advanced to log sequence 5594
Thread 1 opened at log sequence 5594
Current log# 1 seq# 5594 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO01.LOG
Successful open of redo thread 1.
Mon Nov 14 08:22:11 2011
SMON: enabling cache recovery
Mon Nov 14 08:22:12 2011
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.
Mon Nov 14 08:22:12 2011
SMON: enabling tx recovery
Mon Nov 14 08:22:12 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Mon Nov 14 10:02:07 2011
Thread 1 advanced to log sequence 5595
Current log# 2 seq# 5595 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO02.LOG
Mon Nov 14 12:22:03 2011
Thread 1 advanced to log sequence 5596
Current log# 3 seq# 5596 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO03.LOG
Dump file d:\oracle\admin\ora92\bdump\alert_ora92.log
Mon Nov 14 13:48:59 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Mon Nov 14 13:48:59 2011
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 = 150
timed_statistics = TRUE
shared_pool_size = 268435456
sga_max_size = 1074864892
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\ora92\CONTROL01.CTL, D:\oracle\oradata\ora92\CONTROL02.CTL, D:\oracle\oradata\ora92\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 536870912
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora92
dispatchers = (PROTOCOL=TCP) (SERVICE=ora92XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\ora92\bdump
user_dump_dest = D:\oracle\admin\ora92\udump
core_dump_dest = D:\oracle\admin\ora92\cdump
sort_area_size = 524288
db_name = ora92
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 134217728
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
Mon Nov 14 13:49:04 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Nov 14 13:49:06 2011
alter database mount exclusive
Mon Nov 14 13:49:11 2011
Successful mount of redo thread 1, with mount id 2079194578.
Mon Nov 14 13:49:11 2011
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Nov 14 13:49:11 2011
alter database open
Mon Nov 14 13:49:12 2011
Beginning crash recovery of 1 threads
Mon Nov 14 13:49:12 2011
Started first pass scan
Mon Nov 14 13:49:13 2011
Completed first pass scan
15308 redo blocks read, 460 data blocks need recovery
Mon Nov 14 13:49:13 2011
Started recovery at
Thread 1: logseq 5596, block 44170, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 5596 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORA92\REDO03.LOG
Mon Nov 14 13:49:14 2011
Ended recovery at
Thread 1: logseq 5596, block 59478, scn 0.395387488
460 data blocks read, 460 data blocks written, 15308 redo blocks read
Crash recovery completed successfully
Mon Nov 14 13:49:15 2011
Thread 1 advanced to log sequence 5597
Thread 1 opened at log sequence 5597
Current log# 1 seq# 5597 mem# 0: D:\ORACLE\ORADATA\ORA92\REDO01.LOG
Successful open of redo thread 1.
Mon Nov 14 13:49:16 2011
SMON: enabling cache recovery
Mon Nov 14 13:49:17 2011
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.
Mon Nov 14 13:49:17 2011
SMON: enabling tx recovery
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货