ORA-00845

环境:

oracle11gR2 + centOS4.8

启动时：

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

原因是由于/dev/shm（我得是700M）小于参数文件中的MEMORY_TARGET参数（1g）

 

解决：

通过修改参数文件启动，过程略述，下面是修改/dev/shm大小去解决这个问题

[root@DB11g ~]# vi /etc/fstab

把

none                    /dev/shm                tmpfs   defaults        0 0

改为

none                    /dev/shm                tmpfs   defaults,size=1G        0 0

[root@DB11g ~]# unmount /dev/shm

[root@DB11g ~]# mount /dev/shm

检查一下，ok

[root@DB11g ~]# df -k /dev/shm
Filesystem           1K-blocks      Used Available Use% Mounted on
none                   1048576         0   1048576   0% /dev/shm

可以启动了
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1058779136 bytes
Fixed Size                  1341224 bytes
Variable Size             612370648 bytes
Database Buffers          440401920 bytes
Redo Buffers                4665344 bytes
Database mounted.
Database opened.
SQL>