Hi guys
Recently I was trying to understand the AUTOMATIC MEMORY MANAGEMENT feature of 11g onwards database & ended up in a drastic situation where I changed MEMORY_TARGET parameter with a value higher than MEMORY_MAX_TARGET
This has blocked the database from starting & a quick googling brought me to correct solution
As sys, connect to idle database
#sqlplus / as sysdba
SQL> create pfile from spfile;
–Applies to where spfile is used instead of pfile
Edit the pfile & comment/delete the MEMORY_MAX_TARGET parameter, get back to SQL>
SQL>create spfile from pfile;
SQL>startup;
This should resolve the error ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
Hope this helps few folks out there!
regards,