Target database memory (XXMB) exceeds the systems available

[INS-35172] Target database memory (XXMB) exceeds the systems available shared memory ({0} MB) Solution

When installing the Oracle 11gR2 database, an error is reported during installation:

 

 

[INS-35172] Target database memory (778 MB) exceeds the systems available shared memory ({0} MB ).

 

 

Tested, the maximum memory available for the system is 632 mb. For example:

 

 

 

Affects the maximum value,

That is, 632M is the size of our tmpfs file. This problem is similar to my previous blog:

Oracle11gR2 RAC ORA-00845 MEMORY_TARGET not supported on this system solution
 
Http://www.bkjia.com/database/201202/119409.html

The [ID 460506.1] documentation on MOS is described.

 

 

You are tryingto use the MEMORY_TARGET feature. this feature requires the/dev/shm filesystem to be mounted for at Least <size> bytes. the/dev/shm is either notmounted or is mounted With available space less than this size.

 

[Root @ gg2 ~] # Df-h/dev/shm

Filesystem Size Used Avail Use % Mounted on

Tmpfs 636 M 0 636 M 0%/dev/shm

 

The size of this file is the key to truly controlling the size of our AMM. If you find the cause, you can handle it. Modify the size of tmpfs to make it larger than MEMORY_TARGET.

 

# Umount tmpfs

# Mount-t tmpfs shmfs-o size = 3G/dev/shm

 

Enable Automatic mount for each restart of the OS. Modify the/etc/fstab file to change tmpfs to the following values:

Tmpfs/dev/shm tmpfs ults, size = 3G 0 0

 

If you directly modify/etc/fstab, restart the OS to make the parameter take effect.

 

Note: The size must be an integer.

 

[Root @ gg2 ~] # Df-lh/dev/shm

Filesystem Size Used Avail Use % Mounted on

Shmfs 3.0G 0 3.0G 0%/dev/shm

 

After modification, you can successfully install the SDK.

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but the source address must be indicated by link; otherwise, the documents shall be held legally liable.

Blog: http://blog.csdn.net/tianlesoftware