ORA-00845: MEMORY_TARGET not supported on this system

How to fix ORA-00845: MEMORY_TARGET not supported on this system

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

Hmmmmm, that`s new for me, never faced before.

Checked disk space

[root@localhost ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/cciss/c0d0p3     209G   27G  171G  14% /
/dev/cciss/c0d1p1     903G  265G  592G  31% /oradata
/dev/cciss/c0d0p1      99M   24M   71M  26% /boot
tmpfs                 3.9G     0  3.9G   0% /dev/shm
[root@localhost ~]#

Increased tmpfs size. To do that open fstab file via any editable program (gedit, vi etc)


[root@localhost ~]# vi /etc/fstab
...
tmpfs      /dev/shm      tmpfs   defaults,size=8G


(Some one decreased this value that was reason)

[root@localhost ~]# more /etc/fstab 

LABEL=/                 /                       ext3    defaults        1 1

LABEL=/oradata          /oradata                ext3    defaults        1 2

LABEL=/boot1            /boot                   ext3    defaults        1 2

tmpfs                   /dev/shm                tmpfs   defaults,size=8G        0 0

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

sysfs                   /sys                    sysfs   defaults        0 0

proc                    /proc                   proc    defaults        0 0

LABEL=SW-cciss/c0d0p2   swap                    swap    defaults        0 0

/swapfile  swap   swap defaults 0 0

 
To make change effective immediately run:

[root@localhost ~]# mount -o remount /dev/shm

Or mount -t tmpfs shmfs -o size=8g /dev/shm
Check
[root@localhost ~]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/cciss/c0d0p3     209G   27G  171G  14% /

/dev/cciss/c0d1p1     903G  265G  592G  31% /oradata

/dev/cciss/c0d0p1      99M   24M   71M  26% /boot

tmpfs                 8.0G     0  8.0G   0% /dev/shm

[root@localhost ~]# 

Let`s start a database

[oracle@localhost dbs]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 30 10:17:30 2011

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

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 5277921280 bytes

Fixed Size      2213096 bytes

Variable Size   4496296728 bytes

Database Buffers   738197504 bytes

Redo Buffers     41213952 bytes

Database mounted.

Database opened.

SQL> exit