top of page
Search
  • Writer's pictureSudipta Bhaskar

ORA-00845: MEMORY_TARGET not supported on this system

srvctl start asm

fails with the following error.


[oracle@sbstandby ~]$ srvctl start asm
PRCR-1079 : Failed to start resource ora.asm
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'sbstandby' failed
CRS-5017: The resource action "ora.asm start" encountered the following error: 
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/sbstandby/crs/trace/ohasd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.asm' on 'sbstandby' failed

ohasd_oraagent_oracle.trc shows this


2023-12-21 20:38:03.612 : USRTHRD:1902495488: [     INFO] {0:0:4436} InstConnection::disConnect 100 this:0x7fcc4002f220 get SessionLock 0x7fcc4002aa60 for OCISessionEnd
2023-12-21 20:38:03.613 : USRTHRD:1902495488: [     INFO] {0:0:4436} InstConnection::~InstConnection destructor 999 this pConnxn:0x7fcc4002f220 spid:
2023-12-21 20:38:03.613 :CLSDYNAM:1902495488: [ ora.asm]{0:0:4436} [start] InstAgent::startInstance 380 throw excp what:ORA-00845: MEMORY_TARGET not supported on this system

2023-12-21 20:38:03.613 :CLSDYNAM:1902495488: [ ora.asm]{0:0:4436} [start] InstAgent::start 500 exception OCIException
2023-12-21 20:38:03.613 :CLSDYNAM:1902495488: [ ora.asm]{0:0:4436} [start] ORA-00845: MEMORY_TARGET not supported on this system

2023-12-21 20:38:03.613 :CLSDYNAM:1902495488: [ ora.asm]{0:0:4436} [start] Agent::commonStart Exception OCIException
2023-12-21 20:38:03.613 :CLSDYNAM:1902495488: [ ora.asm]{0:0:4436} [start] clsnUtils::error Exception type=2 string=
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/sbstandby/crs/trace/ohasd_oraagent_oracle.trc".

2023-12-21 20:38:03.613 :    AGFW:1902495488: [     INFO] {0:0:4436} sending status msg [CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/sbstandby/crs/trace/ohasd_oraagent_oracle.trc".
] for start for resource: ora.asm sbstandby 1
2023-12-21 20:38:03.615 :CLSDYNAM:1902495488: [ ora.asm]{0:0:4436} [start] (:CLSN00107:) clsn_agent::start }
2023-12-21 20:38:03.615 :    AGFW:1902495488: [     INFO] {0:0:4436} Command: start for resource: ora.asm sbstandby 1 completed with status: FAIL
2023-12-21 20:38:03.615 :    AGFW:1894090496: [     INFO] {0:0:4436} Agent sending reply for: RESOURCE_START[ora.asm sbstandby 1] ID 4098:219617
2023-12-21 20:38:03.615 :CLSDYNAM:1902495488: [ ora.asm]{0:0:4436} [check] InstAgent::checkState 030 new gimh oracleSid:+ASM
2023-12-21 20:38:03.616 :CLSDYNAM:1902495488: [ ora.asm]{0:0:4436} [check] Gimh::check condition changes to (GIMH_NEXT_NUM) 0(Abnormal Termination) exists

Resolution :


In the server, /dev/shm is 1.8G

[root@sbstandby ~]# df -h /dev/shm
Filesystem      Size  Used Avail Use% Mounted on
tmpfs           1.8G   16K  1.8G   1% /dev/shm

Unmounted and remounted tmpfs.

[root@sbstandby ~]# mount -t tmpfs shmfs -o size=8192m /dev/shm
[root@sbstandby ~]# 

[root@sbstandby ~]# df -h /dev/shm
Filesystem      Size  Used Avail Use% Mounted on
shmfs           8.0G     0  8.0G   0% /dev/shm

Let's restart ASM now.


[oracle@sbstandby ~]$ srvctl status asm
ASM is not running.
[oracle@sbstandby ~]$ srvctl start asm
[oracle@sbstandby ~]$ srvctl status asm
ASM is running on sbstandby

Issue fixed.


Cause :


The Automatic Memory Management functionality uses /dev/shm on Linux for SGA and PGA management. The errors occur if either MEMORY_TARGET or MEMORY_MAX_TARGET is configured larger than the configured /dev/shm size, or if /dev/shm is mounted incorrectly.

9 views0 comments

Recent Posts

See All

How to Convert Physical Standby To Active DataGuard

Standby database SQL> select open_mode , protection_mode , database_role from v$database; OPEN_MODE      PROTECTION_MODE   DATABASE_ROLE -------------------- -------------------- ---------------- MOUN

Post: Blog2_Post
bottom of page