ora-600:internal error code arguments[qerrmOFBU1],[24347],[],[],[],[],[]

还有大量信息:

Process S001 started up but failed with error = 4031
failed to start shared server 'S001', er=4031
Wed May  5 13:31:16 2010
CKPT: Begin resize of buffer pool 3 (DEFAULT for block size 8192)
CKPT: Current size = 112 MB, Target size = 2048 MB
CKPT: Could not allocate memory for buffer pool DEFAULT, 
blocksize 8192
CKPT: Begin resize of buffer pool 3 (DEFAULT for block size 8192)
CKPT: Current size = 112 MB, Target size = 2048 MB
CKPT: Could not allocate memory for buffer pool DEFAULT, 
blocksize 8192
Wed May  5 13:31:51 2010
found dead shared server 'S000', pid = (10, 51)
Wed May  5 13:32:54 2010
found dead shared server 'S000', pid = (10, 52)
Wed May  5 13:33:57 2010
found dead shared server 'S000', pid = (10, 53)
Wed May  5 13:38:09 2010
found dead shared server 'S000', pid = (10, 54)
Wed May  5 13:40:12 2010
found dead shared server 'S000', pid = (10, 55)
Wed May  5 13:46:30 2010
found dead shared server 'S000', pid = (10, 56)
found dead shared server 'S001', pid = (15, 164)
Wed May  5 13:47:30 2010
found dead shared server 'S000', pid = (10, 57)
found dead shared server 'S001', pid = (15, 165)
Wed May  5 13:49:36 2010
found dead shared server 'S000', pid = (10, 58)
found dead shared server 'S001', pid = (15, 166)
Wed May  5 13:52:45 2010
found dead shared server 'S000', pid = (10, 59)
Wed May  5 13:53:46 2010
found dead shared server 'S000', pid = (10, 60)
Wed May  5 13:54:37 2010

查看其参数文件,发现相对其8g的物理内存,参数设置的不够合理,太大了,调整参数

*.db_cache_size=2147483648  --2048
*.java_pool_size=20971520 
*.large_pool_size=33554432  --32m
*.pga_aggregate_target=1073741824  --1034m
*.sga_max_size=4294967296  --4096m
*.shared_pool_size=314572800    --300m 
*.sort_area_size= 655360 
反映速度也增加了很多,错误似乎也不出现了,但还会出现large_pool的错误,看样子还是应该增加大池的大小,归档模式有关吧.