Monday, September 10, 2012

ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account, ORA-00849

ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account
ORA-00849: SGA_TARGET 4512632 cannot be set to more than MEMORY_MAX_TARGET 0.



Solution:-


Don't set memory_target and memory_max_target parameter to 0 (zero) explicitly.

if above error happened, you can do following...

1) Restore old spfile

or

2) create pfile from parameter value taken from alert log.

or

3) create pfile from spfile and remove the MEMORY_MAX_TARGET=0 and MEMORY_TARGET=0 lines. After that, use the modified PFILE to create a new SPFILE and start the instance with this new setup.
then use the following commands to remove the explicit setting of MEMORY_TARGET=0 and MEMORY_MAX_TARGET=0:

alter system reset memory_target;
alter system reset memory_max_target;