ORA-00849: SGA_TARGET cannot be set to more than MEMORY_MAX_TARGET

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 05 Sep, 2023
  • 0 Comments
  • 29 Secs Read

ORA-00849: SGA_TARGET cannot be set to more than MEMORY_MAX_TARGET

ORA-00849: SGA_TARGET cannot be set to more than MEMORY_MAX_TARGET
SQL> show sga
SQL> show parameter memory
SQL> show parameter sga
SQL> create pfile = 'INITPRIM.ORA' from spfile ='SPFILEPRIM.ORA';
File created.

 modify pfile as per your need using some editor, and remove your spfile

SQL> create spfile = 'SPFILEPRIM.ORA' from pfile ='INITPRIM.ORA';
File created.

SQL> STARTUP
ORACLE instance started.
Total System Global Area 3.4206E+10 bytes
Fixed Size                  2256912 bytes
Variable Size            1.9864E+10 bytes
Database Buffers         1.4227E+10 bytes
Redo Buffers              112771072 bytes
Database mounted.
Database opened.

Hope It Helps!