ORA-00849: SGA_TARGET 8589934592 cannot be set to more than MEMORY_MAX_TARGET 0.

执行下面的命令后，启动数据库报错：

SQL> alter system set memory_max_target=0 scope=spfile;
System altered.
Elapsed: 00:00:00.01
SQL> alter system set memory_target=0 scope=spfile;    
System altered.

SQL> startup force
ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account
ORA-00849: SGA_TARGET 8589934592 cannot be set to more than MEMORY_MAX_TARGET 0.

目的是关掉11g的内存自动管理，但是这样设置是不对的，memory_max_target是不能在spfile中设置为0的。

解决：

create pfile='xxx' from spfile;

然后注释掉：memory_max_target=0这一行

然后create spfile from pfile='xxx'

启动正常了。