Posts
ORA-00845: MEMORY_TARGET not supported on this system
[oracle@server02 ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Mar 17 05:59:38 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-00845: MEMORY_TARGET not supported on this system
*** This Error occurred when I configured MEMORY_TARGET on a Centos 5.2 64BIT Server.
I found one Doc, which states the cause of the error and to solve the Issue.
The main reason for this error is MEMORY_TARGET or MEMORY_MAX_TARGET cannot be greater than the shared memory filesystem (/dev/shm) on the OS.
Filesystem Size Used Avail Use% Mounted on
tmpfs 1.9G 0 1.9G 0% /dev/shm
As per the Document I increased the /dev/shm to 7GB.
[root@server02 ~]# mount -t tmpfs shmfs -o size=7g /dev/shm
[root@server02 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
tmpfs 7.0G 0 7.0G 0% /dev/shm
shmfs 7.0G 0 7.0G 0% /dev/shm
[oracle@server02 ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Mar 17 06:14:18 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2146112 bytes
Variable Size 1627390144 bytes
Database Buffers 503316480 bytes
Redo Buffers 5033984 bytes
Database mounted.
Database opened.
1) Reference: http://www.cyberciti.biz/tips/what-is-devshm-and-its-practical-usage.html - /dev/shm
2) Metalink - 465048.1
