Under the Linux operating system, the increase in Oracle DB 11g Memory_max_target and Memory_target should be noted:
[[email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.1.0.7.0-production on Tue Jul 01:12:24 2015Copyri Ght (c) 1982, D, Oracle. All rights reserved. Connected to:oracle Database 11g Enterprise Edition Release 11.1.0.7.0-productionwith The partitioning, OLAP, Data Minin G and Real application testing optionssql> show parameter Instname TYPE VALUE--- --------------------------------------------------------------------------Active_instance_count INTEGERCL Uster_database_instances integer 1instance_groups stringinstance_name String Orclinstance_number integer 0instance_type string R Dbmsopen_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 404Ms hared_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 at this time is as follows:
Tue Jul 01:15:13 2015Starting ORACLE Instance (normal) warning:you is trying to use the Memory_target feature. This feature requires THE/DEV/SHM file system to is mounted for at least 2046820352 bytes. /DEV/SHM is either isn't mounted or is mounted with available space less than this size. Please fix the memory_target can work as expected. Current available are 1595297792 and used is 0 Bytes.memory_target needs larger/dev/shmtue Jul 01:21:45 2015Starting OR ACLE 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 = 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 "
Reference article:
Ora-00845-which value FOR/DEV/SHM is needed to startup database without ORA-00845 (document ID 1399209.1) ORA-00845 raised Whe N Starting Instance (document ID 465048.1)
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Linux operating system, Oracle DB 11g to increase the memory_max_target and Memory_target should be noted