ORA-00845，momery_target not supported on this system

出现ORA-00845报错时我们首先用oerr工具查询

[oracle@orcl1 admin]$ oerr ora 00845
00845, 00000, "MEMORY_TARGET not supported on this system"
// *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/
shm was not sized correctly on Linux.
// *Action: Refer to documentation for a list of supported operating systems. Or, size /dev/shm to
 be at least the SGA_MAX_SIZE on each Oracle instance running on the system.

原因：是MEMOTY_TARGET参数不支持这个操作系统或者Linux上/dev/shm大小不满足
操作：增大/dev/shm 至少满足SGA_MAX_SIZE的

首先我们修改/dev/shm大小，模拟这个报错

查询参数

SQL> show parameter target
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target             integer     0
db_flashback_retention_target         integer     1440
fast_start_io_target             integer     0
fast_start_mttr_target             integer     0
memory_max_target             big integer 1520M
memory_target                 big integer 1520M
parallel_servers_target          integer     32
pga_aggregate_target             big integer 0
sga_target                 big integer 0

修改/dev/shm，使其比MAMORY_TARGET小

[root@orcl1 ~]# df -h
Filesystem               Size  Used Avail Use% Mounted on
/dev/mapper/centos-root   18G   13G  4.7G  74% /
devtmpfs                 1.9G     0  1.9G   0% /dev
tmpfs                    1.9G  279M  1.6G  15% /dev/shm
tmpfs                    1.9G  8.4M  1.9G   1% /run
tmpfs                    1.9G     0  1.9G   0% /sys/fs/cgroup
/dev/sda1                497M  124M  374M  25% /boot
tmpfs                    380M     0  380M   0% /run/user/0
[root@orcl1 ~]# mount -o size=2G -o nr_inodes=1000000 -o noatime,nodiratime -o remount /dev/shm
[root@orcl1 ~]# df -h
Filesystem               Size  Used Avail Use% Mounted on
/dev/mapper/centos-root   18G   13G  4.7G  74% /
devtmpfs                 1.9G     0  1.9G   0% /dev
tmpfs                    1.0G  279M  746M  28% /dev/shm
tmpfs                    1.9G  8.4M  1.9G   1% /run
tmpfs                    1.9G     0  1.9G   0% /sys/fs/cgroup
/dev/sda1                497M  124M  374M  25% /boot
tmpfs                    380M     0  380M   0% /run/user/0

重新启动数据库

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup open
ORA-00845: MEMORY_TARGET not supported on this system

启动的时候就出现ORA-00845错误，这是时候是没有启动。（这种状态暂时不知到怎么去修改MEMORY_TARGET大小，请指教）
我们增加/dev/shm的大小

[root@orcl1 ~]# mount -o size=2G -o nr_inodes=1000000 -o noatime,nodiratime -o remount /de
v/shm[root@orcl1 ~]# df -h
Filesystem               Size  Used Avail Use% Mounted on
/dev/mapper/centos-root   18G   13G  4.7G  74% /
devtmpfs                 1.9G     0  1.9G   0% /dev
tmpfs                    2.0G     0  2.0G   0% /dev/shm
tmpfs                    1.9G  8.3M  1.9G   1% /run
tmpfs                    1.9G     0  1.9G   0% /sys/fs/cgroup
/dev/sda1                497M  124M  374M  25% /boot
tmpfs                    380M     0  380M   0% /run/user/0

然后数据库就可以正常启动

[root@orcl1 ~]# su - oracle
Last login: Wed Oct 11 11:51:31 CST 2017 on pts/1
[oracle@orcl1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 11 11:57:53 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup open
ORACLE instance started.
Total System Global Area 1586708480 bytes
Fixed Size            2253624 bytes
Variable Size          973081800 bytes
Database Buffers      603979776 bytes
Redo Buffers            7393280 bytes
Database mounted.
Database opened.