ORA-00845: MEMORY_TARGET not supported on this system

While installation of oracle database, due to high memory target getting into shared memory of low size

Here we can see than memory size is allocated as 1440 MB , and shared memory size is also set as 1500MB.

[root@orcldg u01]# df -h /dev/shm
Filesystem      Size  Used Avail Use% Mounted on
shmfs           1.5G     0  1.5G   0% /dev/shm

Workaround:

Increase the shared memory segments to resolve the issue

[root@orcldg grid]# umount tmpfs
[root@orcldg grid]# mount -t tmpfs shmfs -o size=3000m /dev/shm

You have to adjust the SGA or PGA size parameters to startup the database instance using pfile

Before allocation of shm

[oracle@orcl19x oradata]$ ipcs

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status
0x00000000 312901632  oracle     640        4096       0
0x00000000 312934401  oracle     640        4096       0
0x149f5fc8 312967170  oracle     640        4096       0

------ Semaphore Arrays --------
key        semid      owner      perms      nsems
0xde2547a4 2457600    oracle     640        154

After allocation of shm

[oracle@orcl19x ~]$ ipcs

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status
0x00000000 313425920  oracle     640        4096       0
0x00000000 313458689  oracle     640        4096       0
0x149f5fc8 313491458  oracle     640        4096       0
0x00000000 314179587  oracle     640        2928640    42
0x00000000 314212356  oracle     640        1560281088 21
0x00000000 314245125  oracle     640        13848576   21
0xc7fedcfc 314277894  oracle     640        12288      21

------ Semaphore Arrays --------
key        semid      owner      perms      nsems
0xde2547a4 2981888    oracle     640        154
0x4761b218 3112961    oracle     640        152
0x4761b219 3145730    oracle     640        152
0x4761b21a 3178499    oracle     640        152

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s