Oracle 错误“ORA-00838: Specified value of MEMORY_TARGET is too small”处理办法

错误的修改了ORACLE 11g的memory参数之后，导致DB启动不起来
SQL> startup
ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 2080M

SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ -----------------------------------------
hi_shared_memory_address integer 0
memory_max_target                    big integer 1584M
memory_target                        big integer 1584M
shared_memory_address integer 0

SQL> alter system set memory_target = 512M scope=spfile

SQL> alter system set memory_max_target =1024Mscope=spfile

解决方法如下：

SQL> CREATE PFILE FROM SPFILE;
MANUALLY EDIT PFILE & CORRECT MEMORY_TARGET VALUE

SQL> CREATE SPFILE FROM PFILE;

SQL> STARTUP

其中生成的PFILE (init.ora) 位于 $ORACLE_HOME/dbs folder. 修改这个 init.ora 文件。

或者在操作时，指定文件位置，如 
create pfile='' from spfile ;
startup pfile=/dbs/init.ora