Fixed – ORA-00844: Parameter not taking MEMORY_TARGET into account

When you start your database and it throws following error:

ORA-01078: failure in processing system parameters
ORA-00844: Parameter not taking MEMORY_TARGET into account
ORA-00851: SGA_MAX_SIZE 9445460234 cannot be set to more than MEMORY_TARGET 4547687648.

Ora-00844 Error

Cause: The SGA_MAX_SIZE parameter is larger than MEMORY_TARGET parameter.

May be you forgot to set the MEMORY_TARGET in the spfile after setting SGA_MAX_SIZE parameter or already set the MEMORY_TARGET parameter but forgot to set SGA_MAX_SIZE to 0.


Now to start your database, you need to remove the SGA_MAX_SIZE parameter from pfile and spfile.

If you are running a spfile, you must need to create a pfile from spfile. First connect with sys user using following command:


C:\>sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 11:17:53 2013
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
SQL> conn sys/sys@xe as sysdba
Connected.
SQL>
If you are still unable to connect with SYS user, follow below steps:
C:\>set oracle_sid=xe
C:\>sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 11:19:37 2013
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
SQL> conn sys/sys as sysdba
Connected.
SQL>

Once you are connected with database, create pfile from spfile:

SQL> create pfile from spfile;
File created.
Or
SQL> create pfile = 'D:\oraclexe\app\oracle\product\11.2.0\server\dbs\init.ora' from spfile='D:\oraclexe\app\oracle\product\11.2.0\server\dbs\SPFILEXE.ORA';
File created.
SQL> exit
Disconnected

Now, open the dbs directory which contain the newly created pfile and remove following lines from pfile (example based on Oracle 11g express):

Location: D:\oraclexe\app\oracle\product\11.2.0\server\dbs\init.ora

sga_max_size=2238535456
sga_target=0

Now recreate spfile from pfile:

SQL> create spfile from pfile;
File created.

Now startup the database will be successful:

SQL> startup
ORACLE instance started.
Total System Global Area  376635392 bytes
Fixed Size                  1383692 bytes
Variable Size             281019124 bytes
Database Buffers           88080384 bytes
Redo Buffers                6152192 bytes
Database mounted.
Database opened.

If this post helps you to resolve your problem then don’t forget to like and share with your friends as well.

SiteGround Black Friday Sale Below Banner

Get Free Blogging Tips & Technology updates in your Email !!!

Subscribe via RSS feed

The following two tabs change content below.
Anil Kumar
IT Blogger Tips focus on Blogging Tips, SEO Tips, Social Media, SQL Tips, PL/SQL Tips, Oracle DBA, Linux/Unix, Latest Technology, How Tos and Technical Solutions. You can find us on Facebook | Twitter |
Find on Google+

  • farhad aarabi

    hi dear
    tnx 4 helping

Siteground SALE
70% OFF SiteGround WordPress Hosting – $2.95/month (Exclusive Offer !!!)