ORA-56752: Oracle Database Express Edition (XE) memory parameter invalid or not specified

ORA-56752: Oracle Database Express Edition (XE) memory parameter invalid or not specified

Error: While starting the Database.

SQL> startup
ORA-56752: Oracle Database Express Edition (XE) memory parameter invalid or not specified
ORA-01078: failure in processing system parameters

Cause: In the Express edition if we allocate more SGA_target, Memory_target or sga_max_size from recommended then our database start giving error.

Solution: Limit the SGA to 1.5 G or less for the Express edition.

--Connect with an idle instance:
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

--Create the pfile from spfile
SQL> create pfile='C:\pinit.txt' from spfile;

File created.

--Change the parameter of spfile upto 1.5 GB or less. I make it 1 GB. Save file.
*.sga_max_size=1073741824
*.sga_target=1073741824

--Create spfile from pfile.
SQL> create spfile from pfile='C:\pinit.txt';
File created.

--Start the database:
Startup

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.