Home > ORA-XXX > ORA-00845: MEMORY_TARGET not supported on this system

ORA-00845: MEMORY_TARGET not supported on this system

Today, I tuned the memory_target to 8G on a 11g instance, it showed the errors above when it got restarted. It was caused by the tmpfs size.

[oracle@yhktamvmdb01 etc]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
tmpfs                 7.8G  164K  7.8G   1% /dev/shm <– the size less than 8G.
/dev/sda1             485M   37M  423M   9% /boot

Then, I increased the size by the command below

[root@yhktamvmdb01 ~]# mount -t tmpfs shmfs -o size=12g /dev/shm

[root@yhktamvmdb01 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
tmpfs                  12G     0   12G   0% /dev/shm <– the size increased to 12G

Start the database successfully

SQL> startup
ORACLE instance started.

Total System Global Area 8551575552 bytes
Fixed Size                  2270360 bytes
Variable Size            5049944936 bytes
Database Buffers         3489660928 bytes
Redo Buffers                9699328 bytes
Database mounted.
Database opened.

Make the change on the tmpfs permanently by editing the /etc/fstab as the following

tmpfs                   /dev/shm                tmpfs   size=12g        0 0

 

 

 

 

Advertisements
Categories: ORA-XXX
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: