Shulou(Shulou.com)06/01 Report--

ORA-00845: MEMORY_TARGET not supported on this system error resolution

Today, I was embarrassed when importing oracle data files.

Because the environment is in the virtual machine, and then when I started the virtual machine, the memory was 3G, and I entered the system and found that the instance of oracle did not start.

Details are as follows: error message

SQL > startup

ORA-00845: MEMORY_TARGET not supported on this system

After searching the information, we found that the problem is as follows, see metalinikID 460506.1

Oracle 11g database starts the database error ora-00845 after modifying the pfile parameter

The new memory management parameter MEMORY_TARGET in oracle 11g can automatically adjust SGA and PGA. This feature requires the use of / dev/shm shared file system, and requires that / dev/shm must be greater than MEMORY_TARGET. If / dev/shm is smaller than MEMORY_TARGET, an error will be reported.

Solution

1. Initialization parameters MEMORY_TARGET or MEMORY_MAX_TARGET cannot be greater than shared memory (/ dev/shm). To solve this problem, increase / dev/shm

Such as:

# mount-t tmpfs shmfs-o size=7g / dev/shm

two。 To ensure that the operating system takes effect after reboot, the / etc/fstab file needs to be modified

Shmfs / dev/shm tmpfs size=7g 0

3. If / dev/shm is not mounted, the above error will also be reported. You need to make sure that it has been mounted.

Oracle@aaaprod-db ~] $df-h

……

Tmpfs 16G 8.9g 7.2g 56% / dev/shm

……

The following is a record of an operation

[root@aaaprod-db] # mount-o remount,size=7G / dev/shm

[root@rhel6 mydbbackup] # cat / etc/fstab

#

# / etc/fstab

# Created by anaconda on Sat Dec 20 08:29:51 2014

#

# Accessible filesystems, by reference, are maintained under'/ dev/disk'

# See man pages fstab (5), findfs (8), mount (8) and/or blkid (8) for more info

#

/ dev/mapper/vg_rhel6-lv_root / ext4 defaults 1 1

UUID=f742f5bf-7787-4a46-bc06-d751caa48482 / boot ext4 defaults 1 2

/ dev/mapper/vg_rhel6-lv_home / home ext4 defaults 1 2

/ dev/mapper/vg_rhel6-lv_swap swap swap defaults 0 0

Tmpfs / dev/shm tmpfs defaults 0 0

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

Sysfs / sys sysfs defaults 0 0

Proc / proc proc defaults 0 0

Shmfs / dev/shm tmpfs defaults,size=7g 0 0

[root@rhel6 mydbbackup] # df-h | grep shmfs

Shmfs 7.0G 941m 6.1g 14% / dev/shm

Then start the database:

SQL > startup

ORACLE instance started.

Total System Global Area 1603411968 bytes

Fixed Size 2213776 bytes

Variable Size 1124075632 bytes

Database Buffers 469762048 bytes

Redo Buffers 7360512 bytes

Database mounted.

Database opened.

Reference article: http://www.linuxidc.com/Linux/2012-12/76976.htm

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.