ORA-00838: Specified value of MEMORY_TARGET is too small

ORA-00838: Specified value of MEMORY_TARGET, evet bu hatanin sebebi memory_target degerinin parametre dosyasi icindeki degerinin ihtiyacimiz olan degerden kucuk olmasi. Bir cok sebebi olabilir, mesala sga_target degeri yuksek verilmistir ve db yeniden baslatilirken, memory_target degeri kucuk ise verir vs.

cozum asagidaki adimlari yapabiliriz;

SQL> startup

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1172M

SQL> create pfile='/home/oracle/pfile.ora' from spfile;

File created.

spfile`den pfile olusturup, icindeki memory_target degerini yeniden veriyoruz.

$ vi '/home/oracle/pfile.ora'

*.memory_target=1300234240

daha sonra, pfile`den spfile olusturup veritabanimizi aciyoruz.

SQL> create spfile from pfile='/home/oracle/pfile.ora';

File created.

SQL> startup

ORACLE instance started.

Total System Global Area  534462464 bytes

Fixed Size                  2212736 bytes

Variable Size             524291200 bytes

Database Buffers            4194304 bytes

Redo Buffers                3764224 bytes

Database mounted.

Database opened.