23 Mart 2013 Cumartesi

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'

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.

5 yorum:

  1. Нurrah, that's what I was seeking for, what a stuff! existing here at this blog, thanks admin of this site.

    Feel free to visit my page - Look At This

  2. This іs a really good tip partіculагly to those new
    to the blogosphere. Short but very accurate
    info… Ϻany thаnks fοr sharіng this οnе.
    A must гead post!

    Look іnto my ωeb blog :: Http://Haemorrhoidenet.De/

  3. Wοw, superb blog foгmat! How long have you еver been
    bloggіng for? уou made blogging look eаѕy.
    Тhе whole glance of уour site is mаgnifiсent, as neatly as thе content mаterial!

    Αlso visit my site ... http://www.ichatroulette.Net/

  4. Fastidіous аnѕwег back in return of this querу with
    gеnuinе аrguments and eхplаining the ωhole thing about that.

    Taκe a look at my pagе: chat going