ORA-00845: MEMORY_TARGET not supported on this system（解决方法）

来源：互联网发布：java方法名长度编辑：程序博客网时间：2024/06/13 06:23

首先MEMORY_TARGET 设置不能大于tmpfs

MEMORY_TARGET 不能大于tmpfs

tmpfs是一种虚拟内存文件系统，而不是块设备。是基于内存的文件系统

Swap是通过硬盘虚拟出来的内存空间

[oracle@iZwz94iiauukqd0inyhirbZ ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 24 09:59:37 2016

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

SQL> connect sys / as sysdba
Enter password:
Connected to an idle instance.
SQL> startup force pfile='/u01/app/oracle/admin/orcl/pfile/init.ora.5302016102522'
ORA-00845: MEMORY_TARGET not supported on this system

1、我们先查看下tmpfs的大小，df -h,大小为1.9G

[root@iZwz94iiaussqd0inyhirbZ ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 40G 21G 17G 56% /
tmpfs 1.9G 1.1G 849M 56% /dev/shm/

2、然后修改/u01/app/oracle/admin/orcl/pfile下面的文件init.ora.5302016102522，memory_target的值改为比tmpfs小的1862846720

# Miscellaneous
###########################################
compatible=11.2.0.0.0
diagnostic_dest=/u01/app/oracle
memory_target=1862846720

3、然后强制加载init.ora.5302016102522文件启动数据库

SQL> startup force pfile='/u01/app/oracle/admin/orcl/pfile/init.ora.5302016102522'

OK成功

0 0