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

SiteGround WordPress Hosting Promo Discount 60 OFF

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

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

SQL> create pfile from spfile;
File created.
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

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


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.

I use SEMRush for Keyword Research & Boost Organic Traffic. Do You?

Highly recommended SEM & SEO Tool for overview of Traffic, Keywords, Backlinks and more. You can search your competitors URL to analyze keywords & crush your competition.

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
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)