ORA-00845: MEMORY_TARGET not supported on this system

最新推荐文章于 2023-05-16 21:34:58 发布

黄宝康

最新推荐文章于 2023-05-16 21:34:58 发布

阅读量807

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle

本文链接：https://blog.youkuaiyun.com/huangbaokang/article/details/81198615

oracle 专栏收录该内容

217 篇文章

订阅专栏

本文介绍了在启动Oracle数据库时遇到ORA-00845错误的解决方法。通过调整Linux系统中/dev/shm分区的大小来支持MEMORY_TARGET参数，确保Oracle实例能够正确启动。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

今天在项目部署的时候，启动Oracle数据库时遇到了如下错误

[root@ibopo-center-db ~]# su - oracle
[oracle@ibopo-center-db ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 25 10:48:21 2018

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

Connected to an idle instance.

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

解决办法

修改/dev/shm的大小，官网的说法：

打开官方文档的error messages标签，可以看到有关错误代码的解释

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.

修改的地方，加上size即可。

[oracle@ibopo-center-db ~]$ cat /etc/fstab 

#
# /etc/fstab
# Created by anaconda on Wed Jan 10 16:10:50 2018
#
# 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=6a3d7636-a80f-49c8-ad07-40b12ba275cb /                       ext4    defaults        1 1
UUID=0e3438e5-2663-4911-8e1a-ed802b35af01 /boot                   ext4    defaults        1 2
UUID=4c6e5fb8-6ada-4fa2-9a4c-6af5071ea140 swap                    swap    defaults        0 0

#tmpfs                   /dev/shm                tmpfs   defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults,size=64G        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
/dec/hdb5               swap                    swap    defaults        0 0
/etc/swapfree           swap                    swap    defaults        0 0

修改之后重新挂载下

重新挂载/dev/shm
[root@huangbaokang ~]# umount /dev/shm/ 
[root@huangbaokang ~]# mount /dev/shm/ 
[root@huangbaokang ~]# mount

然后重新sqlplus登录，startup即可。

专业墙纸贴纸厨房用具装饰出售，本人网店经营，访问即是爱

博客对你有用记得访问下哦，增加下访问量，如有需要可以下单购买哦^_^。店铺地址https://item.taobao.com/item.htm?id=570637716145