ora-00845解决方法

[oracle@highgo1 ~]$ oerr ora 00845

00845, 00000, "MEMORY_TARGET not supported on this system"

// *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux.

// *Action: Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.

修改/etc/fstab

# /etc/fstab

# Created by anaconda on Fri Feb  5 01:16:37 2016

#

# 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

#

UUID=c3c4cbe0-bab0-4ef1-ae54-e1e60aff43db /                       ext4    defaults        1 1

UUID=1dd39184-106f-4f46-97c1-afff96cc8e08 /boot                   ext4    defaults        1 2

UUID=35e81db3-b061-4154-90d9-3d29b2858c86 swap                    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

~

~

~

使用如下命令生效（根据情况修改大小）

 mount -o remount,size=3G /dev/shm