ORA-00845: MEMORY_TARGET not supported on this system
来源:互联网 发布:手机声卡软件 编辑:程序博客网 时间:2024/05/22 19:11
来自Oracle的官方解析是:
Starting with Oracle Database 11g, the Automatic Memory Management feature requires more shared memory (/dev/shm)and file descriptors. The size of the shared memory should be at least the greater of MEMORY_MAX_TARGET and MEMORY_TARGET for each Oracle instance on the computer. If MEMORY_MAX_TARGET or MEMORY_TARGET is set to a non zero value, and an incorrect size is assigned to the shared memory, it will result in an ORA-00845 error at startup.
简单来说就是 MEMORY_MAX_TARGET 的设置不能超过 /dev/shm 的大小
调整MEMORY_MAX_TARGET,
Starting with Oracle Database 11g, the Automatic Memory Management feature requires more shared memory (/dev/shm)and file descriptors. The size of the shared memory should be at least the greater of MEMORY_MAX_TARGET and MEMORY_TARGET for each Oracle instance on the computer. If MEMORY_MAX_TARGET or MEMORY_TARGET is set to a non zero value, and an incorrect size is assigned to the shared memory, it will result in an ORA-00845 error at startup.
调整MEMORY_MAX_TARGET,
查看/dev/shm原本大小
[root@iZwzeee0inyhirbZ bin]# df -h|grep shm
tmpfs 939M 0 939M 0% /dev/shm
在文件搜索里找到init.ora.XXXXXXX文件
更改MEMORY_TARGET的值:
###########################################
# Miscellaneous
###########################################
compatible=11.2.0.0.0
diagnostic_dest=/u01/app/oracle
memory_target=962846720
强制加载启动成功:
SQL> startup force pfile='/u01/app/oracle/admin/orcl/pfile/init.ora.5302016102522'
ORACLE instance started.
Total System Global Area 960372736 bytes
Fixed Size 2219152 bytes
Variable Size 541066096 bytes
Database Buffers 411041792 bytes
Redo Buffers 6045696 bytes
Database mounted.
Database opened.
SQL>
0 0
- ORA-00845: MEMORY_TARGET not supported on this system 错误解决方法!
- ORA-00845: MEMORY_TARGET not supported on this system - Linux Servers
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ora-00845 MEMORY_TARGET not supported on this system 的问题
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- oracle11g ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- ORA-00845: MEMORY_TARGET not supported on this system
- sqlmap cookie注入实战
- Android菜鸟之学习android源码之四(修改系统默认字体尺寸)
- ES6中Set和WeakSet的使用
- Android开发:android studio报错: Failed to resolve: com.android.support.constraint:constraint-layout:1.0.
- 为什么作为Android开发想学学React&&React Native?
- ORA-00845: MEMORY_TARGET not supported on this system
- Visual-slam 相关链接和文献
- capwap学习笔记——capwap的前世今生
- VJ水题堆-关于斐波那契数列的求解过程
- CDR如何备份和恢复文件
- google 2fa 双因子印证
- placeholder属性的兼容问题
- ORACLE 11GR2 安装学习时使用的示例数据库
- java基础疑点分析