千家信息网

Oracle11g 启动报错ORA-00845: MEMORY_TARGET not supported on this system报错解决

发表于:2025-02-07 作者:千家信息网编辑
千家信息网最后更新 2025年02月07日,ORA-00845: MEMORY_TARGET not supported on this system报错解决Oracle启动报错ORA-00845: MEMORY_TARGET not supp
千家信息网最后更新 2025年02月07日Oracle11g 启动报错ORA-00845: MEMORY_TARGET not supported on this system报错解决

ORA-00845: MEMORY_TARGET not supported on this system报错解决

  1. Oracle启动报错

ORA-00845: MEMORY_TARGET not supported on this system报错解决

SQL> startup

ORA-00845: MEMORY_TARGET not supported on this system

查看原本大小

[root@Shine2 oracle]# df -h|grep shm

tmpfs 505M 75K 505M 1% /dev/shm


[oracle@Shine2 ~]$ vim /etc/fstab

把文件中

tmpfs /dev/shm tmpfs defaults 0 0

改为

tmpfs /dev/shm tmpfs defaults,size=1G 0 0


修改完成后,重新启动机器


[oracle@Shine2 ~]$ sqlplus


SQL*Plus: Release 11.2.0.1.0 Production on Sat Jul 30 09:34:01 2011


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


Enter user-name: / as sysdba

Connected to an idle instance.


SQL> startup

ORACLE instance started.


Total System Global Area 640286720 bytes

Fixed Size 1338420 bytes

Variable Size 461374412 bytes

Database Buffers 171966464 bytes

Redo Buffers 5607424 bytes

Database mounted.

Database opened.


此时问题解决

0