oracle--ORA 838 Specified value of MEMORY_TARGET is too small, needs to be at le
http://www.51testing.com/index.php?uid-132585-action-viewspace-itemid-213107ORA-00844: Parameter not taking MEMORY_TARGET into account, see alert log for more informationMEMORY_TARGET?新参数?虽然在安装过程中瞟过一眼，但是也没太多注意，后来理解MEMORY_TARGET就是原来10g的sga_target + pga_aggregate_target的总和，越来越智能了。再看导致错误原因：由于设置了Oracle的MEMORY_TARGET参数的值小于了SGA_TARGET和PGA_TARGET的总和，因此报错。但是此时数据库已经启不来了，在数据库不能更改spfile的情况下，我们可以更改pfile，再用pfile启动SQL> create pfile ='/home/oracle/initora11g.ora' from spfile;SQL> !echo '*.memory_target=1024m' >>'/home/oracle/initora11g.ora';将pfile里面的memory_target设置成1G报错，再次验证memory_target>= sga_target + pga_aggregate_targetORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1224MORA-01078: failure in processing system parameters再改SQL> !echo '*.memory_target=1224m' >>'/home/oracle/initora11g.ora';SQL> !echo '*.sga_target=0' >>'/home/oracle/initora11g.ora';报新错误了又ORA-00845: MEMORY_TARGET not supported on this system这个问题是由于设置SGA的大小超过了操作系统/dev/shm的大小解决办法：http://yangtingkun.itpub.net/post/468/408235最终启动成功启动后再改回从spfile启动SQL>create spfile from pfile = '/home/oracle/initora11g.ora';然后再启动一次SQL> startupORACLE instance started.Total System Global Area 1068937216 bytesFixed Size 2151248 bytesVariable Size 511708336 bytesDatabase Buffers 549453824 bytesRedo Buffers 5623808 bytesDatabase mounted.Database opened.最后SQL> show parameter target;NAME TYPE VALUE------------------------------------ ----------- ------------------------------archive_lag_target integer 0db_flashback_retention_target integer 1440fast_start_io_target integer 0fast_start_mttr_target integer 0memory_max_target big integer 1300Mmemory_target big integer 1224Mpga_aggregate_target big integer 0sga_target big integer 0简单概括：create pfile='e:\init.ora' from spfile;之后在e:\init.ora直接将sga_target=1.6g,1.6g或者转化为1.6*1024*1024*1024startup pfile=e:\init.oracreate spfile from pfilestartup
