Specified value of MEMORY_TARGET is too small, needs to be at least 3072M解决办法
来源:互联网 发布:iphone算日子软件 编辑:程序博客网 时间:2024/05/29 16:53
今天安装EM12C的时候遇到了一个报错:
修改好数据库中的参数大小后,重新启动报错
Specified value of MEMORY_TARGET is too small, needs to be at least 3072M
提示MEMORY_TARGET is too small 这样的话数据库已经停止了,所以只能用:
SQL> CREATE PFILE FROM SPFILE;
先把生成的spfile备个份
再修改spfile中的参数:*.memory_target=3221225472
3072*1024*2014=3221225472也就是3G的大小
修改完成后,保存退出,到数据库中应用pfile
结果还是报错:
SQL> startup pfile='/u01/app/product/11.2.0/dbhome_1/dbs/initzhang.ora';
ORA-00845: MEMORY_TARGET not supported on this system
这是什么情况!!
找了半天,最后找到了问题的根本,发现没有修改系统的shm这个大小
没错,就是/etc/fstab下面的shm
添加上一句,size=4096M
保存退出
在重新应用下
mount -o remount /dev/shm
mount -l 查看下:
ok,生效了,在到oracle用户下启动数据库
SQL>STARTUP
最后启动了,ok搞定!
阅读全文
1 0
- Specified value of MEMORY_TARGET is too small, needs to be at least 3072M解决办法
- ORA-00838: Specified value of MEMORY_TARGET is too small
- ORA-00838: Specified value of MEMORY_TARGET is too small
- ORA-00838: Specified value of MEMORY_TARGET is too small
- ORA-00838: Specified value of MEMORY_TARGET is too small
- The stack size specified is too small, Specify at least 228k
- amoeba启动报错The stack size specified is too small, Specify at least 228k
- amoeba启动报错The stack size specified is too small, Specify at least 228k
- ffmpeg Provided packet is too small, needs to be 的错误
- cassandra 启动报错 The stack size specified is too small, Specify at least 228k处理
- This file requires _WIN32_WINNT to be #defined at least to XXX1. Value XXX1 or higher is recomme
- This file requires _WIN32_WINNT to be #defined at least to 0x0403. Value 0x0501 or higher is recomme
- error : This file requires _WIN32_WINNT to be #defined at least to 0x0403. Value 0x0501 or higher is
- This file requires _WIN32_WINNT to be #defined at least to 0x0403. Value 0x0501 or higher is recomme
- ORA-00838: Specified value of MEMORY_TARGET
- ORA-00838: Specified value of MEMORY_TARGET 解决方案!
- he upgrade needs a total of 92.1 M free space on disk '/boot'. Please free at least an additional 27
- [1]: max virtual memory areas vm.max_map_count [65530] is too low, increase to at least [262144]
- Apache Spark 2.2.0 中文文档
- JAVA设计模式之单例模式
- 扫地机器人十大品牌及选购技巧
- jquery easyui 排序
- android 代码混淆配置
- Specified value of MEMORY_TARGET is too small, needs to be at least 3072M解决办法
- eclipse编辑jsp文件和javascript代码很卡解决办法
- 解决jsp页面在IE8下文本模式自动为(杂项Quirks)导致页面显示错位的情况
- 二叉树的深度
- centos安装中文输入法
- [BZOJ]1443 [JSOI2009]游戏Game 二分图+博弈
- CSS3 常用四个动画(旋转、放大、旋转放大、移动)
- Vue入门系列之Vue实例详解与生命周期
- 脏读、不可重复读、幻读