Oracle Study--"Ora-00845:memory_target not supported in this system" error
System environment:
Operating system: RedHat EL6 (64)
Oracle:oracle 11g R2
Fault case:
Adjusting memory parameters under 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 0S Ql> 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 Integ Er 0sql> show parameter sharedname TYPE VALUE-----------------------------------------------------------------------------hi_shared_memory_address integer 0max_shared_servers integershared_memory_address integer 0shared_pool_reserved_size Big integer 6710 886shared_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> after the adjustment is complete, restart instance:</strong>
sql> startup force;
Ora-00845:memory_target not supported on the 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
To view the Linux system file system:
[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
---from the above can be seen, for the virtual TMPFS memory of the file system, the free space is 878M, can not meet the Memory_target =1200m memory requirements
Adjust TMPFS:
<strong>[[email protected] dbs]$ su-password: [[email protected] ~]# umount tmpfsumount:/dev/shm:device is busy.< c6/> (in some cases useful info about processes, use the device are found by lsof (8) or fuser (1)) </strong>
<strong> Close and TMPFS related 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[[e Mail 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> Modify the Fstab file when the system boots Mount Tmpfs</strong>
<strong>[[email protected] ~]# vi/etc/fstab##/etc/fstab# Created by Anaconda on Sun Sep-16:52:59 2013## Ac Cessible filesystems, by reference, is maintained under '/dev/disk ' # See mans Pages Fstab (5), Findfs (8), mount (8) and/or B Lkid (8) For more INFO#UUID=85FFCAEB-1855-4F6A-B1AF-D4E13D7B8850/EXT4 defaults 1 1uuid=0e 7c052e-fc2a-402a-82cc-116e7629ef8f/boot EXT4 Defaults 1 2UUID=CF98CF21-BA1F-4A3A-AAC3-43406DD 5fca1/u01 EXT4 Defaults 1 2uuid=e3cf943c-48c4-4c4b-ba65-f11ba1f6a2e0/usr EXT4 Defaults 1 2uuid=c5dd449a-ce22-4d47-a6d3-2d09c0186489/var ext4 defaults 1 2U uid=e701d956-939e-441b-bad4-03b2057d4159 Swap swap defaults 0 0tmpfs/dev/s HM Tmpfs defaults,size=1300m 0 0devpts/dev/pts devpts gid=5,mod e=620 0 0sysfs /sys sysfs defaults 0 0proc/proc proc Defau LTS 0 0~[[email protected] ~]# Mount Tmpfs[[email protected] ~]# df-hfilesystem Size used Av Ail 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> validation: </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/s Da3 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 A Vail use% mounted on/dev/sda2 18G 5.2G 12G 32%//dev/sda1 2.0G 62M 1.8G 4%/BOOT/DEV/SDA 3 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 in Sun Sep 16:52:59 2013## Accessible filesystems, by reference, is maintained under '/dev/disk ' # See Mans 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=CF 98cf21-ba1f-4a3a-aac3-43406dd5fca1/u01 EXT4 Defaults 1 2uuid=e3cf943c-48c4-4c4b-ba65-f11ba1f 6A2E0/USR EXT4 Defaults 1 2uuid=c5dd449a-ce22-4d47-a6d3-2d09c0186489/var EXT4 defaults 1 2uuid=e701d956-939e-441b-bad4-03b2057d4159 swap swap defaults 0 0t Mpfs/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>
Restart instance:
[Email protected] ~]$ sqlplus '/as sysdba '
Sql*plus:release 11.2.0.3.0 Production on Thu June 25 11:34:39 2015
Copyright (c) 1982, 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 in this system" error