Oracle study之--“ORA-00845: MEMORY_TARGET not supported on this system"錯誤

標籤：oracle 11g

Oracle study之--“ORA-00845: MEMORY_TARGET not supported on this system"錯誤

系統內容：

   作業系統：RedHat EL6(64)

   Oracle：    Oracle 11g R2

 

故障案例：

在Oracle 11gR2下調整記憶體參數：memory_target

SQL> show parameter memNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------hi_shared_memory_address             integer     0memory_max_target                    big integer 400Mmemory_target                        big integer 400Mshared_memory_address                integer     0SQL> alter system set memory_max_target=1200m scope=spfile;System altered.SQL> alter system set memory_target=1200m scope=spfile;System altered.SQL> show parameter sgaNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------lock_sga                             boolean     FALSEpre_page_sga                         boolean     FALSEsga_max_size                         big integer 400Msga_target                           big integer 0SQL> show parameter sharedNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------hi_shared_memory_address             integer     0max_shared_servers                   integershared_memory_address                integer     0shared_pool_reserved_size            big integer 6710886shared_pool_size                     big integer 0shared_server_sessions               integershared_servers                       integer     1SQL> alter system set shared_pool_size=500m scope=spfile;System altered.SQL> show parameter javaNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------java_jit_enabled                     boolean     TRUEjava_max_sessionspace_size           integer     0java_pool_size                       big integer 0java_soft_sessionspace_limit         integer     0SQL> alter system set java_pool_size=300m scope=spfile;System altered.

<strong>調整完成後，重新啟動Instance：</strong>

SQL> startup force;
ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

查看linux系統檔案系統：
[[email protected] dbs]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              18G  5.2G   12G  32% /
tmpfs                 878M   72K  878M   1% /dev/shm
/dev/sda1             2.0G   62M  1.8G   4% /boot
/dev/sda3              12G  5.7G  5.4G  52% /u01
/dev/sda5             9.9G  4.9G  4.6G  52% /usr
/dev/sda7             4.2G  300M  3.7G   8% /var

---從以上可以看到，對於虛擬tmpfs的記憶體的檔案系統，可用空間為878M，無法滿足memory_target =1200M的記憶體需求

 

調整tmpfs：

<strong>[[email protected] dbs]$ su -Password: [[email protected] ~]# umount tmpfsumount: /dev/shm: device is busy.        (In some cases useful info about processes that use         the device is found by lsof(8) or fuser(1))</strong>

<strong>關閉和tmpfs相關的process：</strong>

<strong>[[email protected] ~]# fuser -kc /dev/shm/dev/shm:             2204m</strong>

<strong>[[email protected] ~]# umount tmpfs[[email protected] ~]# mount  -t tmpfs shmfs -o size=1300m /dev/shm[[email protected] ~]# df -hFilesystem            Size  Used Avail Use% Mounted on/dev/sda2              18G  5.2G   12G  32% //dev/sda1             2.0G   62M  1.8G   4% /boot/dev/sda3              12G  5.7G  5.4G  52% /u01/dev/sda5             9.9G  4.9G  4.6G  52% /usr/dev/sda7             4.2G  300M  3.7G   8% /varshmfs                 1.3G     0  1.3G   0% /dev/shm</strong>

<strong>修改fstab檔案，當系統啟動時mount tmpfs</strong>

<strong>[[email protected] ~]# vi /etc/fstab## /etc/fstab# Created by anaconda on Sun Sep 29 16:52:59 2013## Accessible filesystems, by reference, are maintained under '/dev/disk'# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info#UUID=85ffcaeb-1855-4f6a-b1af-d4e13d7b8850 /                       ext4    defaults        1 1UUID=0e7c052e-fc2a-402a-82cc-116e7629ef8f /boot                   ext4    defaults        1 2UUID=cf98cf21-ba1f-4a3a-aac3-43406dd5fca1 /u01                    ext4    defaults        1 2UUID=e3cf943c-48c4-4c4b-ba65-f11ba1f6a2e0 /usr                    ext4    defaults        1 2UUID=c5dd449a-ce22-4d47-a6d3-2d09c0186489 /var                    ext4    defaults        1 2UUID=e701d956-939e-441b-bad4-03b2057d4159 swap                    swap    defaults        0 0tmpfs                   /dev/shm                tmpfs    defaults,size=1300m        0 0devpts                  /dev/pts                devpts  gid=5,mode=620  0 0sysfs                   /sys                    sysfs   defaults        0 0proc                    /proc                   proc    defaults        0 0~[[email protected] ~]# mount tmpfs[[email protected] ~]# df -hFilesystem            Size  Used Avail Use% Mounted on/dev/sda2              18G  5.2G   12G  32% //dev/sda1             2.0G   62M  1.8G   4% /boot/dev/sda3              12G  5.7G  5.4G  52% /u01/dev/sda5             9.9G  4.9G  4.6G  52% /usr/dev/sda7             4.2G  300M  3.7G   8% /vartmpfs                 1.3G     0  1.3G   0% /dev/shm</strong>

<strong>驗證：</strong>

<strong>[[email protected] ~]# umount /dev/shm[[email protected] ~]# df -hFilesystem            Size  Used Avail Use% Mounted on/dev/sda2              18G  5.2G   12G  32% //dev/sda1             2.0G   62M  1.8G   4% /boot/dev/sda3              12G  5.7G  5.4G  52% /u01/dev/sda5             9.9G  4.9G  4.6G  52% /usr/dev/sda7             4.2G  300M  3.7G   8% /var[[email protected] ~]# mount tmpfs[[email protected] ~]# df -hFilesystem            Size  Used Avail Use% Mounted on/dev/sda2              18G  5.2G   12G  32% //dev/sda1             2.0G   62M  1.8G   4% /boot/dev/sda3              12G  5.7G  5.4G  52% /u01/dev/sda5             9.9G  4.9G  4.6G  52% /usr/dev/sda7             4.2G  300M  3.7G   8% /vartmpfs                 1.3G     0  1.3G   0% /dev/shm[[email protected] ~]# cat /etc/fstab## /etc/fstab# Created by anaconda on Sun Sep 29 16:52:59 2013## Accessible filesystems, by reference, are maintained under '/dev/disk'# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info#UUID=85ffcaeb-1855-4f6a-b1af-d4e13d7b8850 /                       ext4    defaults        1 1UUID=0e7c052e-fc2a-402a-82cc-116e7629ef8f /boot                   ext4    defaults        1 2UUID=cf98cf21-ba1f-4a3a-aac3-43406dd5fca1 /u01                    ext4    defaults        1 2UUID=e3cf943c-48c4-4c4b-ba65-f11ba1f6a2e0 /usr                    ext4    defaults        1 2UUID=c5dd449a-ce22-4d47-a6d3-2d09c0186489 /var                    ext4    defaults        1 2UUID=e701d956-939e-441b-bad4-03b2057d4159 swap                    swap    defaults        0 0tmpfs                   /dev/shm                tmpfs    defaults,size=1300m        0 0devpts                  /dev/pts                devpts  gid=5,mode=620  0 0sysfs                   /sys                    sysfs   defaults        0 0proc                    /proc                   proc    defaults        0 0</strong>

<strong>[[email protected] ~]# df -hFilesystem            Size  Used Avail Use% Mounted on/dev/sda2              18G  5.2G   12G  32% //dev/sda1             2.0G   62M  1.8G   4% /boot/dev/sda3              12G  5.7G  5.4G  52% /u01/dev/sda5             9.9G  4.9G  4.6G  52% /usr/dev/sda7             4.2G  300M  3.7G   8% /vartmpfs                 1.3G     0  1.3G   0% /dev/shm</strong>

重新啟動Instance：

[[email protected] ~]$ sqlplus ‘/as sysdba‘

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 25 11:34:39 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size                  2227944 bytes
Variable Size            1224737048 bytes
Database Buffers           16777216 bytes
Redo Buffers                8921088 bytes
Database mounted.
Database opened.

 

Oracle study之--“ORA-00845: MEMORY_TARGET not supported on this system"錯誤