oracle11g ora_00845错误解决
ORA-00845错误解决
SQL> startup;
ORA-00845: MEMORY_TARGET not supported on this system
这就是SGA大小超过了memory_max_target
1：调整sga变小，这个不推荐
2：加大/dev/shm
查看/dev/shm大小
[root@primary shm]# df -h /dev/shm
Filesystem Size Used Avail Use% Mounted on
none 2.0G 976M 1.1G 49% /dev/shm
而之前
SQL> show parameter MEMORY
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
hi_shared_memory_address integer
0
memory_max_target big integer
1632M
memory_target big integer
1632M
shared_memory_address integer
1632m 显然超过了1.1g
3：
[root@primary shm]# mount -t tmpfs shmfs -o size=3g /dev/shm
4：
另外添加下面：
vi /etc/fstab
shmfs /dev/shm tmpfs size=3g 0 0
5：
在尝试startup
SQL> startup;
ORACLE instance started.
Total System Global Area 1707446272 bytes
Fixed Size 1336988 bytes
Variable Size 1006635364 bytes
Database Buffers 687865856 bytes
Redo Buffers 11608064 bytes
Database mounted.
Database opened.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22934571/viewspace-1046112/ ，如需转载，请注明出处，否则将追究法律责任。
