Oracle 11g Ora-00845:memory_target not supported on the This system

Error after starting Oracle 11GR2: ORA-00845

Rac1:/home/oracle> Sqlplus/as sysdba;

Sql*plus:release 11.2.0.3.0 Production ontue Feb 14 09:11:41 2012

Copyright (c) 1982, Oracle. All rights reserved.

Connected to an idle instance.

Sql> Startup

Ora-00845:memory_target not supported Onthis system

This error has been dealt with before, because the size of the TMPFS memory_target setting, it will be reported this error.

rac1:/home/oracle> Oerr Ora 845

00845, 00000, "Memory_target notsupported on this system"

*cause:the memory_target parameter Wasnot supported on this operating system OR/DEV/SHM is not sized correctly onlin Ux.

*action:refer to documentation for alist of supported operating systems. Or, Size/dev/shm to is at least thesga_max_size in each of the Oracle instance running on the system.

Verify that:

Sql> Conn/as sysdba;

Connected to an idle instance.

sql> startup Mount;

ORACLE instance started.

Total System Global area 1402982400 bytes

Fixed Size 2228304 bytes

Variable Size 822087600 bytes

Database buffers 570425344 bytes

Redo buffers 8241152 bytes

Database mounted.

Sql> Show Parameter Memory_target

NAME TYPE VALUE

----------------------------------------------- ------------------------------

Memory_target Big Integer 1344M

--The Memory_target here is 1344M.

[Email protected] ~]# DF-LH

Filesystem Size used Avail use% mounted on

/dev/sda3 14G 11G 2.4G 83%/

Tmpfs 978M 88K 978M 1%/DEV/SHM

/DEV/SDA1 194M 46M 139M 25%/boot

--Here you can see that TMPFS is only 978M. This parameter was modified when I installed the DB:

[Email protected] ~]# Cat/etc/fstab

UUID=B1D2DE8E-DE31-4DEB-B4E8-755C0ED01616/EXT4 Defaults 1 1

Uuid=4df5aa5f-8ef0-473a-931a-51d11e21aa53/boot EXT4 Defaults 1 2

Uuid=82085104-5021-4aaf-8e85-f213998107b6swap Swap Defaults 0 0

Tmpfs/dev/shm Tmpfs defaults,size=3g 0 0

Devpts/dev/pts devpts gid=5,mode=620 0 0

Sysfs/sys Sysfs Defaults 0 0

PROC/PROC proc Defaults 0 0

--Only the configuration here does not take effect when it is started. Specific configuration reference:

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

http://blog.csdn.net/tianlesoftware/article/details/6896614

--Re-mount the TMPFS:

[Email protected] ~]# UMOUNT/DEV/SHM

Umount:/dev/shm:device is busy.

(In some cases useful info about processes

The device is found by lsof (8) or fuser (1))


The processing method of the Linux Umount report device is busy

http://blog.csdn.net/tianlesoftware/article/details/6194295


--equipment busy, with fuser processing:

[Email protected] ~]# FUSER-KM/DEV/SHM

/dev/shm:1805m

[Email protected] ~]# UMOUNT/DEV/SHM

[Email protected] ~]# MOUNT/DEV/SHM

[Email protected] ~]# DF-LH

Filesystem Size used Avail use% mounted on

/dev/sda3 14G 11G 2.4G 83%/

/DEV/SDA1 194M 46M 139M 25%/boot

Tmpfs 3.0G 0 3.0G 0%/dev/shm

--it's normal now.


Once again, it turns out that the parameters of the setting are still not in effect, so it is doubtful whether the TMPFS is half as stable under Oracle Linux 6.1. This question another blog to test.

Oracle 11g Ora-00845:memory_target not supported on the This system