ORA-03113: end-of-file on communication channel
Process ID: 7920
Session ID: 170 Serial number: 5
去alert_<instance>.log查了下7920的id，没发现什么问题。系统是windows2008 32bit，Oracle 11.1.0.6.0.
数据库基本都是空的，只要能连上做测试就行。
网上google了很多，做了几步操作后又出来很多oracle memory size问题，折腾了很久又还原了。
如果分不够再加。底下是7920的trace：
Trace file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_7920.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.0 Service Pack 2
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:941M/2046M, Ph+PgF:2221M/4331M, VA:1195M/2047M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 18
Windows thread id: 7920, image: ORACLE.EXE (SHAD)
*** 2013-03-25 15:37:59.614
*** SESSION ID:(170.5) 2013-03-25 15:37:59.621
*** CLIENT ID:() 2013-03-25 15:37:59.621
*** SERVICE NAME:() 2013-03-25 15:37:59.621
*** MODULE NAME:(sqlplus.exe) 2013-03-25 15:37:59.621
*** ACTION NAME:() 2013-03-25 15:37:59.621
Successfully allocated 2 recovery slaves
Using 545 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 8, block 2, scn 73960475
cache-low rba: logseq 8, block 3
on-disk rba: logseq 8, block 79, scn 73960556
start recovery at logseq 8, block 3, scn 0
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 38Kb in 0.23s => 0.16 Mb/sec
Longest record: 0Kb, moves: 0/88 (0%)
Longest LWN: 9Kb, moves: 0/23 (0%), moved: 0Mb
Last redo scn: 0x0000.04688c6b (73960555)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 25/25 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 146/171 = 0.9
----------------------------------------------
*** 2013-03-25 15:37:59.967
KCRA: start recovery claims for 25 data blocks
*** 2013-03-25 15:37:59.971
KCRA: blocks processed = 25/25, claimed = 25, eliminated = 0
*** 2013-03-25 15:38:00.061
Recovery of Online Redo Log: Thread 1 Group 2 Seq 8 Reading mem 0
*** 2013-03-25 15:38:00.081
Completed redo application