ORA-00845: MEMORY_TARGET not supported on this system

Elapsed: 00:00:00.00
SQL> alter system set memory_max_target=20288M scope=spfile; 

System altered.

Elapsed: 00:00:00.02
SQL> alter system set memory_target=20288M scope=spfile; 

System altered.

Elapsed: 00:00:00.01
SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATASYS/sgerp5/spfilesgerp5.o
                                                 ra
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

[root@sgpc146 ~]# df -h | grep shm 
tmpfs                  16G  276M   16G   2% /dev/shm

[root@sgpc146 oracle]# cat /etc/fstab | grep tmpfs 
tmpfs                   /dev/shm                tmpfs   defaults        0 0

[root@sgpc146 oracle]# vi /etc/fstab

LABEL=/                 /                       ext3    defaults        1 1
LABEL=/tmp              /tmp                    ext3    defaults        1 2
LABEL=/boot             /boot                   ext3    defaults        1 2
tmpfs                   /dev/shm                tmpfs   defaults,size=32G        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
LABEL=SWAP-sda3         swap                    swap    defaults        0 0
~

可以通过重启使这个配置生效，也可以通过重新挂载来修改其大小：

[root@sgpc146 oracle]# mount -o remount,size=32G /dev/shm 
[root@sgpc146 oracle]# 
[root@sgpc146 oracle]#  df -h | grep shm 
tmpfs                  32G  276M   32G   1% /dev/shm
[root@sgpc146 oracle]# 

 

SQL> startup
ORACLE instance started.

Total System Global Area 2.1179E+10 bytes
Fixed Size                  2237648 bytes
Variable Size            9932114736 bytes
Database Buffers         1.1207E+10 bytes
Redo Buffers               36995072 bytes
Database mounted.
Database opened.
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 20288M
memory_target                        big integer 20288M
parallel_servers_target              integer     256
pga_aggregate_target                 big integer 0
sga_target                           big integer 0
SQL>