ORA-00845: MEMORY_TARGET not supported on this system

Published by Ahmad on

ORA-00845: MEMORY_TARGET not supported on this system

When I was opening 12cR2 database after installation I get a ORA-00845 error.

Because I am using Automatic Memory Management (AMM) feature & If Shared Memory file system (shmfs) is not big enough to accommodate memory_target and memory_max_target. Then i will get this error.

[[email protected] -] $ export ORACLE_SID=orcl

[[email protected] -] $ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Nov 6 12:23:37 2018

Copyright (c) 1982, 2016, Oracle.

All rights reserved.

Connected to an idle instance.

SQL> startup ORA-00845: MEMORY_TARGET not supported on this system



[[email protected] ]# df -h

Filesystem 	Size  Used Avail Use Mounted on

dev/sda2	916   25G  62G   29%  / 

tmpfs		1.1G  520K 1.16  1    /dev/sh 

/dev/sdal	190M 1134  63M   65%  /boot

/dev/sda3	9.5G 1.6G  7.5G  18%  /tmp

12.2-data	1846 1416  446   77%  /media/sf_12.2-data

/dev/sr0	56M   56M    0  100%  /media/Vox GAS 5.2.20



There are two possible ways to remove the ORA-00845 error.

Reduce the value for the memory_target parameter Or Increase the temporary memory allocation on the server.

I will increase the Shared Memory file system (shmfs). For this I will mount with increased space for tmps.

[[email protected] -]# mount -t tmpfs shmfs - size 2g /dev/shm 

Now Check the filesystem size.

[[email protected] ]# df -h

Filesystem Size Used Avail Use Mounted on

dev/sda2 916 25G 62G 29% /

tmpfs 2.0G 0 2.0G 0% /dev/shm

/dev/sdal 190M 1134 63M 65% /boot

/dev/sda3 9.5G 1.6G 7.5G 18% /tmp

12.2-data 1846 1416 446 77% /media/sf_12.2-data

/dev/sr0 56M 56M 0 100% /media/Vox GAS 5.2.20

shmfs 2.0G 0 2.0G 0% /dev/shm

But  same changes  I will add in /etc/fstab  file for permanent effect.

 

[[email protected] ]# vim /etc/fstab

#
# /etc/fstab
# Created by anaconda on Mon Nov 5 07:52:06 2018
#
# 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=ddd1344e-d224-4100-8b4e-de0afd1a5080 / ext4 defaults 1 1
UUID=4bb5af18-fdc2-45ff-bdad-452db3c681c4 /boot ext4 defaults 1 2
UUID=65903f13-b00f-4ea4-8556-3ad72b52b508 /tmp ext4 defaults 1 2
UUID=46573343-1a4c-421a-befc-13404c61d08e swap swap defaults 0 0

#tmpfs /dev/shm tmpfs defaults 0 0

tmpfs /dev/shm tmpfs size=2g 0 0-----this line i have updated

devpts /dev/pts devpts gid=5,mode=620 0 0

sysfs /sys sysfs defaults 0 0

proc /proc proc defaults 0 0

 

The mount command mounts a storage device or file system making it accessible and attaching it to an existing directory structure.

[[email protected] ~]# mount -a

Now Start the database.

 

[[email protected] ~]# su - oracle

[[email protected] ~]$
[[email protected] ~]$ export ORACLE_SID=orcl
[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 7 22:43:17 2018

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1174405120 bytes
Fixed Size 8619984 bytes
Variable Size 838862896 bytes
Database Buffers 318767104 bytes
Redo Buffers 8155136 bytes
Database mounted.
Database opened.

Now Error  (ORA-00845: MEMORY_TARGET not supported on this system) is Resolved.

Check regularly my post and give feedback & comments!!!!.

Thanks

Ahmad (Riaz Ahmad Ansari)

OCE In (11g R2 RAC)

OCP In (11g/10g/9i)

 

Categories: Database

2 Comments

Nazir Ahmad · November 8, 2018 at 12:55 pm

Perfect !

Parvez · September 27, 2020 at 9:45 pm

Got clear info about this error.Thanks Ahmad Sir

Leave a Reply to Nazir Ahmad Cancel reply

Your email address will not be published. Required fields are marked *