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
This entry was posted in Oracle on by .

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply

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