启动oracle SQL> startup ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account, see alert log for more information
解决办法: create pfile from spfile; 删除pfile中的memory_max_target和memory_target。 create spfile from pfile;
startup成功
参考:
MEMORY_MAX_TARGET was setto 0.
Cause
The problem is caused by the MEMORY_MAX_TARGET parameter explicitly being setto 0.In case AMM should not be used, MEMORY_MAX_TARGET should not be set at all.
Solution
The solutions to the problem are:
create a PFILE from the SPFILE being used and remove the MEMORY_MAX_TARGET=0 and MEMORY_TARGET=0 lines. After that, use the modified PFILE tocreate a new SPFILE andstart the instance with this new setup.
should the instance be running,then use the following commands to remove the explicit setting of MEMORY_TARGET=0 and MEMORY_MAX_TARGET=0:(在oracle运行时,可以通过下面的办法移除参数)