ORA-00845: MEMORY_TARGET not supported on this system

i have a change request to change the memory parameter of our prod database.
so what i did is backup the spfile and alter system but when starting up got this error

ORA-00845: MEMORY_TARGET not supported on this system

Version : 11.1.0.7.0

alter the system..
SQL> alter system set memory_target=10G scope=spfile;
System altered.
SQL> alter system  set memory_max_target=10G scope=spfile;
System altered.

Shutdown the DB

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL>

ERROR!!!
did some google and found that this tempfs /dev/shm should be greater than the value specified on memory_target.
now i know.

SQL> !df -h | grep shm
Filesystem            Size  Used Avail Use% Mounted on
tmpfs                 7.9G   0  7.9G   0% /dev/shm

called UNIX team to resize the /dev/shm

SQL> !df -h | grep shm
tmpfs                  15G   0  15G  0% /dev/shm

started the DB.

SQL> startup
ORACLE instance started.

Total System Global Area 1.0689E+10 bytes
Fixed Size                  2169104 bytes
Variable Size            6140462832 bytes
Database Buffers         4529848320 bytes
Redo Buffers               16994304 bytes
Database mounted.
Database opened.

SQL> set lines 200
SQL> show parameter memory;

NAME                                 TYPE                              VALUE
———————————— ——————————— ——————————
hi_shared_memory_address             integer                           0
memory_max_target                    big integer                       10G
memory_target                        big integer                       10G
shared_memory_address                integer                           0
SQL>

SQL> !df -h | grep shm
tmpfs                  15G  6.0G  9.1G  40% /dev/shm

Thanks!

bai

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s