11g的ORA-00845错误解决

最新推荐文章于 2023-12-07 10:40:29 发布

原创最新推荐文章于 2023-12-07 10:40:29 发布 · 3.4k 阅读

2 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#server #system #sql #虚拟机 #less

故障排除专栏收录该内容

12 篇文章

订阅专栏

本文介绍了解决Oracle 11g在启动时遇到ORA-00845错误的具体步骤。通过调整/dev/shm分区大小，确保其至少为1GB，从而成功解决了内存目标不支持的问题。

前两天在虚拟机上装的11g，启动的时候突然报
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

matelink上的解释是：

This feature requires the /dev/shm file system to be mounted for at least %llu bytes.
/dev/shm is either not mounted or is mounted with available space less than this size.

可以通过下面的方法修改/dev/shm

[root@server ~]# df -k /dev/shm
Filesystem           1K-blocks      Used Available Use% Mounted on
tmpfs                   359816         0    359816   0% /dev/shm
[root@server ~]# vi /etc/fstab

#tmpfs                   /dev/shm                tmpfs   defaults        0 0

/dev/VolGroup00/LogVol00 /                       ext3    defaults        1 1
LABEL=/boot             /boot                   ext3    defaults        1 2
devpts                  /dev/pts                devpts gid=5,mode=620 0 0
#tmpfs                   /dev/shm                tmpfs   defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults,size=1024m        0 0
proc                    /proc                   proc    defaults        0 0
sysfs                   /sys                    sysfs   defaults        0 0
/dev/VolGroup00/LogVol01 swap                    swap    defaults        0 0
~
~
~
~
~
~
~
~
~
~
~
"/etc/fstab" 8L, 622C written
[root@server ~]# umount /dev/shm
[root@server ~]# mount /dev/shm
[root@server ~]# df -k /dev/shm
Filesystem           1K-blocks      Used Available Use% Mounted on
tmpfs                  1048576         0   1048576   0% /dev/shm

再启动数据库

$ sqlplus '/as sysdba'

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Sep 5 06:43:32 2008

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 393375744 bytes
Fixed Size                  1300156 bytes
Variable Size             327158084 bytes
Database Buffers           58720256 bytes
Redo Buffers                6197248 bytes
Database mounted.
Database opened.
SQL>