Oracle boot error Ora-00845:memory_target not supported on the This system workaround

Oracle startup error Ora-00845:memory_target not supported on the This system

Possible reasons: The Oracle Memory_target parameter setting exceeds the memory of the Oracle server itself, or exceeds the current server's free memory (that is, the memory that is unable to get the settings when Oracle starts)

eg

Oracle VERSION:11GR2

OS version:redhat 6.4 Enterprise Edition

Server: Virtual machine

Analysis steps:

1. View the value of the current Memory_target parameter is *.memory_target=408944640, approximately 390M; (can be viewed by spfile)

2. Check the memory of the current system, approximately 200M

Grep-i Memtotal/proc/meminfo
memtotal:236376 KB

Question confirmation:

Verify that the SGA is set to the Oracle Memory_target parameter with more than the operating system's free memory

Solve:

Modify the value of Memory_target to within the appropriate range (if it is formal environment cut Oracle needs to set Memory_target memory, need to increase server memory, not discussed at the beginning)

1. Back up existing SPFile files

CP Spfilestudy.ora Spfilestudy.ora.bak

2. Use SPFile to create pfile (SPFile is binary text, not directly modified), after modifying pfile, regenerate SPFile

Sql> create Pfile from SPFile;

File created.

Modify the Pfile parameter *.memory_target=104857600

Sql> create SPFile from Pfile;

File created.

After confirming, start Oracle

Oracle boot error Ora-00845:memory_target not supported on the This system workaround