Error : ORA-00845: MEMORY_TARGET not supported While starting the Oracle Database.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
Solution:
1) Set the ORACLE_HOME to DB Product Home
export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1
2) login as root
[root@oracle oracle]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_oracleem-lv_root
93G 19G 69G 22% /
tmpfs 7.2G 112K 7.2G 0% /dev/shm
/dev/sda1 485M 99M 362M 22% /boot
Note: The highlighted mount is 0% used though does not have enough memory to start the DB
3) Change the size of file system to 12g
[root@oracle oracle]# mount -t tmpfs shmfs -o size=12g /dev/shm
This will be temporary solution to start the DB.
4) Start the DB
5)To permanently fix it you have to edit the file /etc/fstab by logging in as root user and commit the changes by saving the file.
[root@oracle ~]# cat /etc/fstab
tmpfs /dev/shm tmpfs size=12g 0 0
6) Start the DB.
SQL> startup
ORACLE instance started.
Total System Global Area 1.1758E+10 bytes
Fixed Size 2239056 bytes
Variable Size 5939135920 bytes
Database Buffers 5804916736 bytes
Redo Buffers 12128256 bytes
