linux操作系统下,oracle db 11g中增大memory_max_target和memory_target应该注意的：
[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 instNAMETYPEVALUE———————————— ———– ——————————active_instance_countintegercluster_database_instancesinteger1instance_groupsstringinstance_namestringorclinstance_numberinteger0instance_typestringRDBMSopen_links_per_instanceinteger4parallel_instance_groupstringparallel_server_instancesinteger1SQL> show parameter memNAMETYPEVALUE———————————— ———– ——————————hi_shared_memory_addressinteger0memory_max_targetbig integer 404Mmemory_targetbig integer 404Mshared_memory_addressinteger0SQL> 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 memoryNAMETYPEVALUE———————————— ———– ——————————hi_shared_memory_addressinteger0memory_max_targetbig integer 404Mmemory_targetbig integer 404Mshared_memory_addressinteger0SQL> SQL> SQL> show spparameter memorySIDNAMETYPEVALUE——– —————————– ———– —————————-*hi_shared_memory_addressinteger*memory_max_targetbig integer 2G*memory_targetbig integer 2G*shared_memory_addressintegerSQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORA-00845: MEMORY_TARGET not supported on this systemSQL>
此时的alert日志如下：
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"
参考文章：
ORA-00845 – Which value for /dev/shm is needed to startup database without ORA-00845 (文档 ID 1399209.1)ORA-00845 Raised When Starting Instance (文档 ID 465048.1)
版权声明：本文为博主原创文章，，未经博主允许不得转载。
所有欺骗中，自欺是最为严重的
