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:
Soln 1: Increase the shared memory segments to resolve the issue. This issue happens because there are no sufficient memory available for other running programs,OS and databases etc..
[root@orcldg grid]# umount tmpfs
[root@orcldg grid]# mount -t tmpfs shmfs -o size=3000m /dev/shmBefore 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
Soln 2: During instance startup, this error triggers sometime
kish@STDBY>startup nomount pfile='/apps01/product/12.1.0/dbhome_1/dbs/initdbx01.ora';
ORA-00845: MEMORY_TARGET not supported on this system
You have to adjust the SGA or PGA size parameters to startup the database instance using pfile
Reduce the memory_target temporarily to start the instance and after adding more memory to the server, the parameter can be dynamically increased
I reduce the memory_target parameter
Post reduction, the instance startup successfully
kish@STDBY>startup nomount pfile='/apps01/product/12.1.0/dbhome_1/dbs/initdbx01.ora';
ORACLE instance started.
Total System Global Area 1577058304 bytes
Fixed Size 2924832 bytes
Variable Size 1073745632 bytes
Database Buffers 486539264 bytes
Redo Buffers 13848576 bytes