ORA-00845: MEMORY_TARGET not supported on this system

启动数据库时，报错ORA-00845

[oracle@linux5 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 6 15:40:53 2012

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

Connected to an idle instance.

SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

看了下官方文档

ORA-00845: 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.

说/dev/shm小于SGA_MAX_SIZE 把/dev/shm改大即可

[root@linux5 ~]# df -m
Filesystem           1M-blocks      Used Available Use% Mounted on
/dev/sda2                 9689      7549      1640  83% /
/dev/sda5                16003     11162      4016  74% /db
/dev/sda1                   99        12        82  13% /boot
tmpfs                      502         0       502   0% /dev/shm
[root@linux5 ~]# umount /dev/shm
[root@linux5 ~]# vi /etc/fstab
[root@linux5 ~]# cat /etc/fstab
LABEL=/                 /                       ext3    defaults        1 1
LABEL=/db               /db                     ext3    defaults        1 2
LABEL=/boot             /boot                   ext3    defaults        1 2
tmpfs                   /dev/shm                tmpfs   defaults,size=1024m        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
LABEL=SWAP-sda3         swap                    swap    defaults        0 0
[root@linux5 ~]# mount /dev/shm

再次启动数据库就OK了

SQL> startup
ORACLE instance started.

Total System Global Area  626327552 bytes
Fixed Size                  2215944 bytes
Variable Size             599789560 bytes
Database Buffers           20971520 bytes
Redo Buffers                3350528 bytes
Database mounted.
Database opened.
SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27146953/viewspace-740326/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27146953/viewspace-740326/