- Problem Memory target
ORA-00844: Parameter not taking MEMORY_TARGET into account
ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504.
Before any action, backup your old configuration.
Edit in Pfile line with memory target to more then SGA_MAX_SIZE
*.memory_target=5368709120
Add line before '*.' lines
You must specified spfile because without that you dont have any spfile
spfile='/u01/app/oracle/product/12.2.0/dbhome_1/dbs/spfiledatabaseinstance01.ora'
try if everything works
try regenerate spfile from pfile
CREATE SPFILE FROM PFILE = '$ORACLE_HOME/dbs/nameofpfile
restart db
shutdown immediate;
startup;
if not, edit spfile with same value as in pfile (memorytarget)
now, you could be able to run db as normal (startup)
Translate
Use categories on the left bar
For orientation in my website, please use a left menu bar with category/subcategory list