ORA-00845: MEMORY_TARGET not supported on this system

简介: 启动数据库,报错idle> startupORA-00845: MEMORY_TARGET not supported on this system原因 /dev/shm的值必须大于或等于memory_target、memory_max_targ...

启动数据库,报错

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

原因
/dev/shm的值必须大于或等于memory_target、memory_max_target的值

查看初始化参数文件中memory_target的大小

[oracle@prod1 dbs]$ cat initPROD.ora |grep memory
*.memory_target=1200m

查看临时文件系统的大小

[root@prod1 trace]# df -h /dev/shm/
Filesystem            Size  Used Avail Use% Mounted on
tmpfs                1014M     0 1014M   0% /dev/shm

解决办法
1 提高/dev/shm/

#卸载
[root@prod1 trace]# umount /dev/shm/
umount: /dev/shm: device is busy
umount: /dev/shm: device is busy
#如果卸载失败,杀掉占用该文件系统的进程
[root@prod1 trace]# fuser -km /dev/shm/
#提高大小
[root@prod1 ~]# vi /etc/fstab 
tmpfs                   /dev/shm                tmpfs   defaults,size=1500m        0 0
#重新加载文件系统
[root@prod1 ~]# mount /dev/shm 
#重启数据库
idle> startup
ORACLE instance started.

Total System Global Area 1255473152 bytes
Fixed Size                  1336232 bytes
Variable Size             889195608 bytes
Database Buffers          352321536 bytes
Redo Buffers               12619776 bytes
Database mounted.
Database opened.

2 降低memory_target、memory_max_target的值

目录
相关文章
|
7月前
|
Oracle 关系型数据库
Customer RecommendedORA-27090 - Unable to Reserve Kernel Resources for Asynchronous Disk I/O
Customer RecommendedORA-27090 - Unable to Reserve Kernel Resources for Asynchronous Disk I/O
51 4