Moneycontrol Brokerage Recos

Tuesday, October 25, 2016

ora-00845 memory_target not supported on this system



ORA-00845 memory_target not supported on this system


You will get this error message when try to start DB instance or launched DBCA to drop an existing 11g database which has memory_target parameter value is set larger than current size of your shared/tmpfs file system or you can say your shared memory size at OS level is too small to fit SGA memory components in there.

Here I tried to start the database and received below error.











Below identified and found that /dev/shm size is tool small to fit the SAG memory components in there.




Increase the tmpfs size to larger value where all SGA/MEMORY_TARGET value can be fit. Here we increased the /dev/shm size to 2G from 500M.





Now we have 2G size for tmpfs /dev/shm






Now, try starting the database instance.














Now, things worked....!!

No comments:

Post a Comment