OracleServerSID 服务启不来

Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
  processes                = 300
  shared_pool_size         = 83886080
  large_pool_size          = 8388608
  java_pool_size           = 50331648
  control_files            = F:\ORACLE\PRODUCT\10.1.0\ORADATA\ER_D\CONTROL01.CTL, F:\ORACLE\PRODUCT\10.1.0\ORADATA\ER_D\CONTROL02.CTL, F:\ORACLE\PRODUCT\10.1.0\ORADATA\ER_D\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 67108864
  compatible               = 10.1.0.2.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = F:\oracle\product\10.1.0\flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=ERDXDB)
  job_queue_processes      = 10
  background_dump_dest     = F:\ORACLE\PRODUCT\10.1.0\ADMIN\ER_D\BDUMP
  user_dump_dest           = F:\ORACLE\PRODUCT\10.1.0\ADMIN\ER_D\UDUMP
  core_dump_dest           = F:\ORACLE\PRODUCT\10.1.0\ADMIN\ER_D\CDUMP
  sort_area_size           = 65536
  db_name                  = ER_D
  open_cursors             = 1000
  pga_aggregate_target     = 25165824
PMON started with pid=2, OS id=3004
MMAN started with pid=4, OS id=4332
DBW0 started with pid=6, OS id=6464
DBW1 started with pid=8, OS id=6424
LGWR started with pid=10, OS id=6624
CKPT started with pid=12, OS id=6780
SMON started with pid=14, OS id=3060
RECO started with pid=16, OS id=6668
Sun Oct 28 12:23:02 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
CJQ0 started with pid=18, OS id=5916
Sun Oct 28 12:23:02 2012
starting up 1 shared server(s) ...
Sun Oct 28 12:23:02 2012
alter database mount exclusive
Sun Oct 28 12:23:02 2012
Controlfile identified with block size 16384
Sun Oct 28 12:23:06 2012
Setting recovery target incarnation to 2
Sun Oct 28 12:23:06 2012
Successful mount of redo thread 1, with mount id 2029299110
Sun Oct 28 12:23:06 2012
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sun Oct 28 12:23:06 2012
alter database open
Sun Oct 28 12:23:07 2012Beginning crash recovery of 1 threads
attempting to start a parallel recovery with 15 processes
Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p003_3056.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p006_6372.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p004_7272.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p011_3616.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p002_928.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p000_4288.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p009_7484.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p010_8188.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p007_4464.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p013_6480.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p014_7080.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:52 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p012_7724.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:53 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p005_6148.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:54 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_p008_2912.trc:
ORA-10388: parallel query server interrupt (failure)Sun Oct 28 12:27:54 2012
ORA-12805: ??????????? parallel recovery failed to get any processes
non-parallel recovery will be done
Sun Oct 28 12:27:54 2012
Started first pass scan
Sun Oct 28 12:27:54 2012
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Sun Oct 28 12:27:54 2012
Started redo application at
Thread 1: logseq 937, block 2, scn 0.4762253
Recovery of Online Redo Log: Thread 1 Group 3 Seq 937 Reading mem 0
  Mem# 0 errs 0: F:\ORACLE\PRODUCT\10.1.0\ORADATA\ER_D\REDO03.LOG
Sun Oct 28 12:27:55 2012
Completed redo application
Sun Oct 28 12:27:55 2012
Completed crash recovery at
Thread 1: logseq 937, block 3, scn 0.4782255
0 data blocks read, 0 data blocks written, 1 redo blocks read
Sun Oct 28 12:27:55 2012
Thread 1 advanced to log sequence 938
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 4 at log switch
Thread 1 opened at log sequence 938
  Current log# 1 seq# 938 mem# 0: F:\ORACLE\PRODUCT\10.1.0\ORADATA\ER_D\REDO01.LOG
Successful open of redo thread 1
Sun Oct 28 12:27:56 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Oct 28 12:27:56 2012
SMON: enabling cache recovery
Sun Oct 28 12:27:56 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\udump\erd_ora_5940.trc:
ORA-00704: ????????
ORA-04031: ???? 4224 ??????? ("shared pool","unknown object","sga heap(1,0)","library cache")Sun Oct 28 12:27:56 2012
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Sun Oct 28 12:27:56 2012
Errors in file f:\oracle\product\10.1.0\admin\er_d\bdump\erd_pmon_3004.trc:
ORA-00704: bootstrap process failure

上面哪个ora-04031网上查是共享内存不足，但是我现在连数据库都进不去怎么改，或许还有可能是其他错误，请帮忙看下？

不要启动数据库，编辑你的PFILE设置内存大小，估计你的太小
然后用FPILE启动看看

在pfile里面填上：
sga_max_size= 500m
sga_target=500m
然后以pfile启动
试试

调试易

OracleServerSID 服务启不来

解决方案 »