ORA-00845 Raised When Starting Instance
Last updated on DECEMBER 18, 2017
Applies to:Oracle Database - Standard Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
During the startup of the database instance the following error is raised:
Enter password: *****
Connected to an idle instance.
SQL> STARTUP NOMOUNT
ORA-00845: MEMORY_TARGET not supported on this system
The instance alert file shows:
WARNING: You are trying to use the MEMORY_TARGET feature.
This feature requires the /dev/shm file system to be mounted for at Least <size> bytes.The /dev/shm is either not mounted or is mounted with available space less than this size.
Please fix this so that MEMORY_TARGET can work as expected. Current available is <size> and used is <size> bytes.memory_target needs larger /dev/shm
Also error messages like ORA-4031 may be reported and no new connections can be established to the database.
The Automatic Memory Management (AMM) has been implemented by setting parameters like MEMORY_TARGET and/or MEMORY_MAX_TARGET.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms