Getting error "ORA-00845: MEMORY_TARGET not supported on this system" while creating a vDB

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Getting error "ORA-00845: MEMORY_TARGET not supported on this system" while creating a vDB

==================
Delphix error msg :


Make sure that the parameters in init<sid>.ora file are valid. Review the Oracle alert log for more details if applicable. 

rm -f $ORACLE_HOME/dbs/spfile${ORACLE_SID}.ora 

DELPHIX>$DLPX_SHELL $DB_SCRIPT_DIR/mount-vdb-instance.sh "restrict pfile='/mn <IPT_DIR/mount-vdb-instance.sh "restrict pfile='/mnt /vTest/datafile/init.ora. <.sh "restrict pfile='/mnt/vTest/datafile/init.ora.r ename'" 

#####DELPHIX_START_ERROR##### 

ERROR : 

ERROR : SQL*Plus: Release 11.2.0.2.0 Production on Wed Jun 15 13:15:35 2016 

ERROR : 

ERROR : Copyright (c) 1982, 2011, Oracle. All rights reserved. 

ERROR : 

ERROR : Connected to an idle instance. 

ERROR : 

ERROR : SQL> ORA-00845: MEMORY_TARGET not supported on this system 

ERROR : SQL> Disconnected 

#####DELPHIX_END_ERROR##### 

MOUNT_DATABASE_ERROR
Photo of K J M RAO

K J M RAO

  • 440 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
If you are provisioning XE database, be aware that Oracle does not allow two XE instances on the same server. Disable any running instances on the Linuxtarget and then provision again.
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
Hi,

If your not in Adam's case, check out your /dev/shm size.

00845, 00000, "MEMORY_TARGET not supported on this system"
// *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux.
// *Action: Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.

Regards,

Mouhssine