oracle11g 起不来,memory target不够

oracle11g 起不来,memory target不够 [oracle@hzmc ~]$ cd $ORACLE_HOME/dbs [oracle@hzmc dbs]$ ls -lrt total 44 -rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora -rw-rw---- 1 oracle oinstall 1544 Mar 16 23:44 hc_DBUA0.dat -rw-rw---- 1 oracle oinstall 1544 Mar 16 23:48 hc_orcl.dat -rw-r----- 1 oracle oinstall 24 Mar 16 23:49 lkORCL -rw-r----- 1 oracle oinstall 1536 Mar 16 23:55 orapworcl -rw-rw---- 1 oracle oinstall 1544 Apr 1 22:18 hc_test1.dat -rw-r----- 1 oracle oinstall 24 Apr 1 22:20 lkTEST1 -rw-r----- 1 oracle oinstall 1536 Apr 1 22:22 orapwtest1 -rw-r----- 1 oracle oinstall 2560 Apr 2 00:01 spfileorcl.ora -rw-r----- 1 oracle oinstall 2560 Apr 17 15:35 spfiletest1.ora -rw-r--r-- 1 oracle oinstall 915 Apr 17 15:46 inittest1.ora [oracle@hzmc dbs]$ echo $ORACLE_SID test1 [oracle@hzmc dbs]$ vi init init.ora inittest1.ora [oracle@hzmc dbs]$ vi inittest1.ora test1.__db_cache_size=666894336 test1.__java_pool_size=4194304 test1.__large_pool_size=4194304 test1.__oracle_base='/opt/ora11g'#ORACLE_BASE set from environment test1.__pga_aggregate_target=4194304 test1.__sga_target=703316480 test1.__shared_io_pool_size=0 test1.__shared_pool_size=155189248 test1.__streams_pool_size=0 *.audit_file_dest='/opt/ora11g/admin/test1/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/opt/ora11g/oradata/test1/control01.ctl','/opt/ora11g/flash_recovery_area/test1/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='test1' *.db_recovery_file_dest='/opt/ora11g/flash_recovery_area' *.db_recovery_file_dest_size=4070572032 *.diagnostic_dest='/opt/ora11g' *.dispatchers='(PROTOCOL=TCP) (SERVICE=test1XDB)' *.memory_target=842006528 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=838860800 *.undo_tablespace='UNDOTBS1' ~ ~ ~ ~ ~ "inittest1.ora" 26L, 915C written [oracle@hzmc dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 17 15:48:35 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> exit Disconnected [oracle@hzmc dbs]$ pwd /opt/ora11g/product/11.2.0/db_1/dbs [oracle@hzmc dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 17 15:48:42 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount pfile='/opt/ora11g/product/11.2.0/db_1/dbs/inittest1.ora'; ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 812M ORA-01078: failure in processing system parameters SQL> exit Disconnected [oracle@hzmc dbs]$ vi inittest1.ora test1.__db_cache_size=666894336 test1.__java_pool_size=4194304 test1.__large_pool_size=4194304 test1.__oracle_base='/opt/ora11g'#ORACLE_BASE set from environment test1.__pga_aggregate_target=4194304 test1.__sga_target=703316480 test1.__shared_io_pool_size=0 test1.__shared_pool_size=155189248 test1.__streams_pool_size=0 *.audit_file_dest='/opt/ora11g/admin/test1/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/opt/ora11g/oradata/test1/control01.ctl','/opt/ora11g/flash_recovery_area/test1/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='test1' *.db_recovery_file_dest='/opt/ora11g/flash_recovery_area' *.db_recovery_file_dest_size=4070572032 *.diagnostic_dest='/opt/ora11g' *.dispatchers='(PROTOCOL=TCP) (SERVICE=test1XDB)' *.memory_target=942006528 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=838860800 *.undo_tablespace='UNDOTBS1' ~ ~ ~ ~ ~ "inittest1.ora" 26L, 915C written [oracle@hzmc dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 17 15:49:42 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount pfile='/opt/ora11g/product/11.2.0/db_1/dbs/inittest1.ora'; ORACLE instance started. Total System Global Area 939495424 bytes Fixed Size 2218952 bytes Variable Size 268436536 bytes Database Buffers 662700032 bytes Redo Buffers 6139904 bytes SQL> create spfile from pfile; File created. SQL> shutdown abort ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@hzmc dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 17 15:50:11 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 939495424 bytes Fixed Size 2218952 bytes Variable Size 268436536 bytes Database Buffers 662700032 bytes Redo Buffers 6139904 bytes Database mounted. Database opened. SQL> show parameters sga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 900M sga_target big integer 800M SQL> show parameter memory NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ hi_shared_memory_address integer 0 memory_max_target big integer 900M memory_target big integer 900M shared_memory_address integer 0 SQL> show parameter pga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target big integer 0