Archive for June, 2014

ORA-00845: MEMORY_TARGET not supported on this system

June 9, 2014 Leave a comment

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





Categories: ORA-XXX