Get the App
SLTechnology News&Howtos  ›  Database  › 

Solution: ORA-00845: MEMORY_TARGET not supported on thi

Shulou Source: shulou.com Published: 2022-06-01 06:23:13 10月02日 Update

ORA-00845: MEMORY_TARGET not supported on this system

The shm size of the RA:Linux system is smaller than that set by SGA. SGA is set to 4G, while shm is only 1G.

Solution:

1. Temporary solution

Mount-o size=8G-o nr_inodes=1000000-o noatime,nodiratime-o remount / dev/shm

two。 Permanent solution

Resize shm

Vim / etc/fstab

Tmpfs / dev/shm tmpfs defaults 0 0

Change to

Tmpfs / dev/shm tmpfs defaults,size=6G 0 0

Wq save exit

Re-mount to make shm effective

Mount-o remount / dev/shm

From "ITPUB blog", link: http://blog.itpub.net/25469263/viewspace-2703519/, if you need to reprint, please indicate the source, otherwise legal liability will be investigated.

Http://www.ytwcbyy.com/ of Yantai Medical University Gastrointestinal Hospital

Tags: Size method provenance hospital blog only legal legal liability system gastrointestinal responsibility link Yantai permanent adjustment Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS Huawei MariaDB Shulou Tech Info Microsoft