Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux: oraclememorytarget

Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux: oraclememorytarget

Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux:

[oracle@hosta ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.1.0.7.0 - Production on Tue Jul 14 01:12:24 2015Copyright (c) 1982, 2008, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> show parameter instNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------active_instance_count                integercluster_database_instances           integer     1instance_groups                      stringinstance_name                        string      orclinstance_number                      integer     0instance_type                        string      RDBMSopen_links_per_instance              integer     4parallel_instance_group              stringparallel_server_instances            integer     1SQL> show parameter memNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------hi_shared_memory_address             integer     0memory_max_target                    big integer 404Mmemory_target                        big integer 404Mshared_memory_address                integer     0SQL> alter system set memory_max_target=2048M scope=spfile;System altered.SQL> alter system set memory_target =2048M scope=spfile;System altered.SQL> show parameter memoryNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------hi_shared_memory_address             integer     0memory_max_target                    big integer 404Mmemory_target                        big integer 404Mshared_memory_address                integer     0SQL> SQL> SQL> show spparameter memorySID      NAME                          TYPE        VALUE-------- ----------------------------- ----------- ----------------------------*        hi_shared_memory_address      integer*        memory_max_target             big integer 2G*        memory_target                 big integer 2G*        shared_memory_address         integerSQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORA-00845: MEMORY_TARGET not supported on this systemSQL> 

 

The alert Log is as follows:

Tue Jul 14 01:15:13 2015Starting ORACLE instance (normal)WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 2046820352 bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. Current available is 1595297792 and used is 0 bytes.memory_target needs larger /dev/shmTue Jul 14 01:21:45 2015Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 2Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DESTAutotune of undo retention is turned on.IMODE=BRILAT =18LICENSE_MAX_USERS = 0SYS auditing is disabledStarting up ORACLE RDBMS Version: 11.1.0.7.0.Using parameter settings in server-side spfile /u01/app/oracle/product/11.1.0/db_1/dbs/spfileorcl.oraSystem parameters with non-default values:  processes                = 150  memory_target            = 2G  memory_max_target        = 2G  control_files            = "/u01/app/oracle/oradata/orcl/control01.ctl"  control_files            = "/u01/app/oracle/oradata/orcl/control02.ctl"  control_files            = "/u01/app/oracle/oradata/orcl/control03.ctl"

References:

ORA-00845-Which value for/dev/shm is needed to startup database without ORA-00845 (Document ID 1399209.1) ORA-00845 Raised When Starting Instance (Document ID 465048.1)

 

 

 

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.