linux作業系統下,oracle db 11g中增大memory_max_target和memory_target應該注意的，oraclememorytarget

linux作業系統下,oracle db 11g中增大memory_max_target和memory_target應該注意的，oraclememorytarget

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 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> 

 

此時的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)

 

 

 

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。