oracle11g 起不来,memory target不够 PDF

oracle11g 起不来,memory target不够 PDF oraclehzmc cd ORACLE_HOME/dbs oraclehzmc 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 oraclehzmc dbs echo ORACLE_SID test1 oraclehzmc dbs vi init init.ora inittest1.ora oraclehzmc dbs vi inittest1.ora test1.__db_cache_size666894336 test1.__java_pool_size4194304 test1.__large_pool_size4194304 test1.__oracle_base/opt/ora11gORACLE_BASE set from environment test1.__pga_aggregate_target4194304 test1.__sga_target703316480 test1.__shared_io_pool_size0 test1.__shared_pool_size155189248 test1.__streams_pool_size0 .audit_file_dest/opt/ora11g/admin/test1/adump .audit_traildb .compatible11.2.0.0.0 .control_files/opt/ora11g/oradata/test1/control01.ctl/opt/ora11g/flash_recovery_area/test1/control02.ctl .db_block_size8192 .db_domain .db_nametest1 .db_recovery_file_dest/opt/ora11g/flash_recovery_area .db_recovery_file_dest_size4070572032 .diagnostic_dest/opt/ora11g .dispatchersPROTOCOLTCP SERVICEtest1XDB .memory_target842006528 .open_cursors300 .processes150 .remote_login_passwordfileEXCLUSIVE .sga_target838860800 .undo_tablespaceUNDOTBS1 inittest1.ora 26L 915C written oraclehzmc dbs sqlplus / as sysdba SQLPlus: 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 oraclehzmc dbs pwd /opt/ora11g/product/11.2.0/db_1/dbs oraclehzmc dbs sqlplus / as sysdba SQLPlus: 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 oraclehzmc dbs vi inittest1.ora test1.__db_cache_size666894336 test1.__java_pool_size4194304 test1.__large_pool_size4194304 test1.__oracle_base/opt/ora11gORACLE_BASE set from environment test1.__pga_aggregate_target4194304 test1.__sga_target703316480 test1.__shared_io_pool_size0 test1.__shared_pool_size155189248 test1.__streams_pool_size0 .audit_file_dest/opt/ora11g/admin/test1/adump .audit_traildb .compatible11.2.0.0.0 .control_files/opt/ora11g/oradata/test1/control01.ctl/opt/ora11g/flash_recovery_area/test1/control02.ctl .db_block_size8192 .db_domain .db_nametest1 .db_recovery_file_dest/opt/ora11g/flash_recovery_area .db_recovery_file_dest_size4070572032 .diagnostic_dest/opt/ora11g .dispatchersPROTOCOLTCP SERVICEtest1XDB .memory_target942006528 .open_cursors300 .processes150 .remote_login_passwordfileEXCLUSIVE .sga_target838860800 .undo_tablespaceUNDOTBS1 inittest1.ora 26L 915C written oraclehzmc dbs sqlplus / as sysdba SQLPlus: 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 oraclehzmc dbs sqlplus / as sysdba SQLPlus: 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