Translate

Use categories on the left bar

For orientation in my website, please use a left menu bar with category/subcategory list

Oracle - Issues


  1. 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)