Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
. Advertisement .
..3..
. Advertisement .
..4..
Hi experts, please help me solve this problem: ora-00845: memory_target not supported on this system.
The following error is generated upon database instance startup:
SQL> connect sys as sysdba
Enter password: *****
Connected to an idle instance.
SQL> STARTUP NOMOUNT
ORA-00845: MEMORY_TARGET not supported on this system
What is the cause of this message? How to fix it quickly?
Thanks in advance.
The cause:
Linux’s /dev/shm is used by the new Automatic Memory Management function to manage SGA and PGA. The issues happen if /dev/shm is mounted wrongly or if MEMORY TARGET or MEMORY MAX TARGET are specified with values greater than the configured /dev/shm size.
Solution:
Do as the following instruction to fix ora-00845: memory_target not supported on this system error.
Verify that ORACLE HOME is properly set. When it is not set properly, this error can occasionally occur.
Make sure the /dev/shm size is set to a size that is sufficient, as in:
The shared memory device in this instance has a 7GB configuration.
Attack an entry for it to the /etc/fstab mount table to ensure that the same change is maintained after a system restart, as in: