[Solved] ORA-00845: MEMORY_TARGET not supported on this system
Error:
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL>
Solution: Set the parameter value in file $ORACLE_HOME/dbs/init<dbname>.ora, Parameter value must satisfied below formula:
MEMORY_TARGET = SGA_TARGET + PGA_AGGREGATE_TARGET
Example:
crd.__pga_aggregate_target=260046848
crd.__sga_target=381681664
*.memory_target=639631360
Now increase the size of tmpfs File system in Linux: follow below steps:
[oracle@ole1 dbs]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_ole1-lv_root
18G 12G 5.3G 68% /
tmpfs 764M 124K 763M 1% /dev/shm
/dev/sda1 485M 53M 407M 12% /boot
.host:/ 238G 230G 7.9G 97% /mnt/hgfs
[root@ole1 ~]# cat /etc/fstab
#
# /etc/fstab
# Created by anaconda on Fri May 30 14:47:40 2014
#
# 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
#
/dev/mapper/vg_ole1-lv_root / ext4 defaults 1 1
UUID=b7e7d6ba-7a0d-4440-bff1-fc9e53333bd0 /boot ext4 defaults 1 2
/dev/mapper/vg_ole1-lv_swap swap swap defaults 0 0
tmpfs /dev/shm tmpfs size=2g 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
[root@ole1 ~]#
[root@ole1 ~]# mount -o remount tmpfs
[root@ole1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_ole1-lv_root
18G 12G 5.3G 68% /
tmpfs 2.0G 124K 2.0G 1% /dev/shm
/dev/sda1 485M 53M 407M 12% /boot
.host:/ 238G 230G 7.9G 97% /mnt/hgfs
[root@ole1 ~]#
SQL> startup
ORACLE instance started.
Total System Global Area 1255473152 bytes
Fixed Size 1336232 bytes
Variable Size 671091800 bytes
Database Buffers 570425344 bytes
Redo Buffers 12619776 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 1200M
memory_target big integer 1200M
shared_memory_address integer 0
SQL>
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL>
Solution: Set the parameter value in file $ORACLE_HOME/dbs/init<dbname>.ora, Parameter value must satisfied below formula:
MEMORY_TARGET = SGA_TARGET + PGA_AGGREGATE_TARGET
Example:
crd.__pga_aggregate_target=260046848
crd.__sga_target=381681664
*.memory_target=639631360
Now increase the size of tmpfs File system in Linux: follow below steps:
[oracle@ole1 dbs]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_ole1-lv_root
18G 12G 5.3G 68% /
tmpfs 764M 124K 763M 1% /dev/shm
/dev/sda1 485M 53M 407M 12% /boot
.host:/ 238G 230G 7.9G 97% /mnt/hgfs
[root@ole1 ~]# cat /etc/fstab
#
# /etc/fstab
# Created by anaconda on Fri May 30 14:47:40 2014
#
# 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
#
/dev/mapper/vg_ole1-lv_root / ext4 defaults 1 1
UUID=b7e7d6ba-7a0d-4440-bff1-fc9e53333bd0 /boot ext4 defaults 1 2
/dev/mapper/vg_ole1-lv_swap swap swap defaults 0 0
tmpfs /dev/shm tmpfs size=2g 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
[root@ole1 ~]#
[root@ole1 ~]# mount -o remount tmpfs
[root@ole1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_ole1-lv_root
18G 12G 5.3G 68% /
tmpfs 2.0G 124K 2.0G 1% /dev/shm
/dev/sda1 485M 53M 407M 12% /boot
.host:/ 238G 230G 7.9G 97% /mnt/hgfs
[root@ole1 ~]#
SQL> startup
ORACLE instance started.
Total System Global Area 1255473152 bytes
Fixed Size 1336232 bytes
Variable Size 671091800 bytes
Database Buffers 570425344 bytes
Redo Buffers 12619776 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 1200M
memory_target big integer 1200M
shared_memory_address integer 0
SQL>

Comments
Post a Comment