Oerr ora 000845 solution is to expand the/DEV/SHM space

Source: Internet
Author: User

Open Virtual Machine Discovery instance does not come up


[Email protected] ~]# su-oracle
Sq[[email protected] ~]$ sqlplus/as SYSDBA

Sql*plus:release 11.2.0.4.0 Production on Tue 2 14:59:54 2016

Copyright (c) 1982, Oracle. All rights reserved.

Connected to an idle instance.

[Email protected] Odb>startup nomout
Sp2-0714:invalid combination of the STARTUP options


[Email protected] ~]$ oerr ora 000845
00845, 00000, "Memory_target not supported in this system"
*cause:the memory_target parameter is not supported on this operating system OR/DEV/SHM is not sized correctly on L Inux.
*action:refer to documentation for a list of supported operating systems. Or, Size/dev/shm to is at least the sga_max_size in each of the Oracle instance running on the system.


The new memory auto-managed parameter Memory_target in Oracle 11g, which automatically adjusts the SGA and PGA, requires a/DEV/SHM shared file system and requires/DEV/SHM to be greater than memory_target if/dev /SHM will get an error when it's smaller than memory_target.


[Email protected] ~]$ df-h/dev/shm/
Filesystem Size used Avail use% mounted on
Tmpfs 1.5G 72K 1.5G 1%/DEV/SHM



*.memory_target=1603272704 approx. 1.6G


The solution is to increase the/DEV/SHM space.

[Email protected] ~]$ Cat/etc/fstab | grep TMPFS
TMPFS/DEV/SHM TMPFS Defaults 0 0


[Email protected] ~]# Mount-o REMOUNT,SIZE=2G/DEV/SHM



[Email protected] ~]# df-h/dev/shm/
Filesystem Size used Avail use% mounted on
Tmpfs 2.0G 72K 2.0G 1%/DEV/SHM


[Email protected] ~]# Vim/etc/fstab


Tmpfs/dev/shm Tmpfs defaults,size=2g

Normally open.


[Email protected] Odb>startup
ORACLE instance started.

Total System Global area 1603411968 bytes
Fixed Size 2253664 bytes
Variable Size 989858976 bytes
Database buffers 603979776 bytes
Redo buffers 7319552 bytes
Database mounted.
Database opened.




Oerr ora 000845 solution is to expand the/DEV/SHM space

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.