ORA-00845: MEMORY_TARGET not supported on this system

ERROR

SQL> startup nomount;

ORA-00845: MEMORY_TARGET not supported on this system

SOLUTION

[oracle@oel6 ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_oel6-lv_root
                       43G   15G   26G  37% /
tmpfs                1001M  212M  789M  22% /dev/shm
/dev/sda1             485M   55M  405M  12% /boot
.host:/               245G  126G  119G  52% /mnt/hgfs

Change the size of that files System by issuing the following command:

mount -t tmpfs shmfs -o size=2g /dev/shm

The shared memory file system should be big enough to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values, else Oracle will throw the ORA-00845 error.

Note: While changing something with the mount command, the changes are not permanent.
To make the change persistent, edit your /etc/fstab file
tmpfs                   /dev/shm                tmpfs   defaults,size=2G         0 0

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleEBSerror

ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

Leave a Reply