ORA-00845: MEMORY_TARGET not supported on this system

来源：互联网发布：魔兽争霸观看录像软件编辑：程序博客网时间：2024/05/05 18:17

Elapsed: 00:00:00.00SQL> alter system set memory_max_target=20288M scope=spfile; System altered.Elapsed: 00:00:00.02SQL> alter system set memory_target=20288M scope=spfile; System altered.Elapsed: 00:00:00.01SQL> show parameter spfile;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------spfile                               string      +DATASYS/sgerp5/spfilesgerp5.o                                                 raSQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORA-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/fstabLABEL=/                 /                       ext3    defaults        1 1LABEL=/tmp              /tmp                    ext3    defaults        1 2LABEL=/boot             /boot                   ext3    defaults        1 2tmpfs                   /dev/shm                tmpfs   defaults,size=32G        0 0devpts                  /dev/pts                devpts  gid=5,mode=620  0 0sysfs                   /sys                    sysfs   defaults        0 0proc                    /proc                   proc    defaults        0 0LABEL=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> startupORACLE instance started.Total System Global Area 2.1179E+10 bytesFixed Size                  2237648 bytesVariable Size            9932114736 bytesDatabase Buffers         1.1207E+10 bytesRedo Buffers               36995072 bytesDatabase mounted.Database opened.SQL> show parameter targetNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------archive_lag_target                   integer     0db_flashback_retention_target        integer     1440fast_start_io_target                 integer     0fast_start_mttr_target               integer     0memory_max_target                    big integer 20288Mmemory_target                        big integer 20288Mparallel_servers_target              integer     256pga_aggregate_target                 big integer 0sga_target                           big integer 0SQL>