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