ORA-00845: MEMORY_TARGET

I have installed Oracle11g on my laptop and have installed the database as well with mostly default parameters.

After installing the database, I started DBCA configure the database and as soon as I selected the database on DBA Config menu, I received the message "ORA-00845:MEMORY_TARGET Not supported on this system".

After googling for this error, came to know that this has something to do howmuch shared memory is allocated at OS level and the values set for MEMORY_TARGET at the database level for Automatic Memory Management.

when I checked for these two, my initial setting was like this -

[root@KirtiBIVM bin]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
38471112 15607268 20878104 43% /
/dev/sda1 101086 12112 83755 13% /boot
tmpfs 517552 270252 247300 53% /dev/shm


whereas my MEMORY_TARGET and MEMORY_MAX_TARGET are set as 404m.

I changed the shared memory at OS level by using the command -

[root@KirtiBIVM bin]# mount -t tmpfs shmfs -o size=3G /dev/shm


after which, the details are -

[oracle@KirtiBIVM bin]$ df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
38471112 15608440 20876932 43% /
/dev/sda1 101086 12112 83755 13% /boot
tmpfs 3145728 620932 2524796 20% /dev/shm
shmfs 3145728 620932 2524796 20% /dev/shm
[oracle@KirtiBIVM bin]$



After this, I have amended the parameters MEMORY_TARGET and MEMORY_MAX_TARGET giving following commands -

logged in as SYS

ALTER SYTSEM SET MEMORY_MAX_TARGET=2G SCOPE=SPFILE;

ALTER SYSTEM SET MEMORY_TARGET=1G SCOPE=SPFILE;

Restarted the database as -

SHUTDOWN IMMEDIATE;

STARTUP;

And this has resolved the issue.