环境:
OS:WIN2003
ORACLE VERSION:9.2.0.1.0
内存:2G
症状:
数据库每隔几天(一般3-5天)左右会自动DOWN掉,DOWN的时间是不固定的.
今天早上9点15分也DOWN过,我把部分告警文件粘上来,如下:
Thu Mar 23 04:09:05 2006
Current log# 3 seq# 493 mem# 1: F:\ORACLE_LOG\REDO06.LOG
ARC0: Completed archiving log 2 thread 1 sequence 492
Dump file d:\oracle\admin\hpkdb1\bdump\alert_hpkdb.log
Thu Mar 23 09:18:01 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
Thu Mar 23 09:18:01 2006
Starting ORACLE instance (normal)
可以看到,今天9点多的时候重起过,不过DOWN机的时候告警日志中没任何错误.
我把部分参数也粘出来:
processes = 150
timed_statistics = TRUE
shared_pool_size = 318767104
large_pool_size = 8388608
java_pool_size = 33554432
db_block_size = 4096
db_cache_size = 1073741824
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = LOCATION=D:\oracle\oradata\hpkdb1\archive
log_archive_format = %t_%s.dbf
db_file_multiblock_read_count= 8
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 900
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=hpkdbXDB)
job_queue_processes = 10
hash_join_enabled = FALSE
background_dump_dest = D:\oracle\admin\hpkdb1\bdump
user_dump_dest = D:\oracle\admin\hpkdb1\udump
core_dump_dest = D:\oracle\admin\hpkdb1\cdump
sort_area_size = 1048576
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 33554432
aq_tm_processes = 1
不知道是不是什么参数有问题??
DOWN机的时候虽然告警文件中没有记录,不过listener.log中有记录
23-3月 -2006 09:15:06 * FTP * handoff * 0
不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=2100))(Presentation=FTP)(Session=RAW))
不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=8080))(Presentation=HTTP)(Session=RAW))
23-3月 -2006 09:15:08 * service_died * hpkdb * 12547
TNS-12547: TNS:丢失连接
这个就是listener.log中记录的,可见丢失过连接,在丢失连接后去服务中看状态,数据库是处于未启动状态,那应该是DOWN机了.
不知道是不是什么BUG引起还是因为参数不正确??
希望各位DX支个招,在这先谢了..