Enter Your Email

Enter your email address:

Delivered by FeedBurner

Custom Search

Tuesday, March 17, 2009

ORA-00845: MEMORY_TARGET not supported on this system

ORA-00845: MEMORY_TARGET not supported on this system


[oracle@server02 ~]$ export ORACLE_SID=testdb

[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.


[root@bisserver02 ~]# df -h

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


 
Copyright © 2005 - 2008 DBA-ONWeb Technical blog. All rights reserved