Unable To Start ASM (ORA-838、4031) On 11.2.0.3 If OS CPUs # > 64-1416083.1
In this Document
Symptoms |
Cause |
Solution |
Community Discussions |
References |
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.
Symptoms
1) ASM 11.2.0.3 configuration on Solaris SPARC T4-4 Server with 128 CPUs
& RAM = 128 GB.
2) If the 128 CPUs are enabled, then ASM instance
is unable to start due to the next errors:
ORA-01078: failure in processing system parameters
3) But if only 64 CPUs are enabled, then ASM instance starts without
problems.
4) On release 11.2, ASM uses Automatic Memory Management (AMM) by default, therefore MEMORY_MAX_TARGET & MEMORY_TARGET have the default values = 272 MB (in the ASM instance):
MEMORY_TARGET = 272M
5) And so, the SGA in the ASM instance has the same value (900
MB):
Total System Global Area 283930624 bytes
Fixed Size 2227664 bytes
Variable Size 256537136 bytes
ASM Cache 25165824 bytes
Cause
Solution
SQL> alter system set MEMORY_TARGET=1536m scope=spfile;
2) Restart the ASM instances to apply the changes.
3) Then
enable all the CPUs (e.g. total = 128) in your system:
128
Important Note:
In 11.2.0.3, we increase the default PROCESSES based on the number of CPU
cores, and the default MEMORY_TARGET is based on PROCESSES. If in 11.2.0.2,
customers explicitly set MEMORY_TARGET to some value that may not be big enough
for 11.2.0.3, when they upgrade to 11.2.0.3, ASM will fail to start with error
"memory_target is too small". We should add additional check for
MEMORY_TARGET during the upgrade prerequisite check.
You can unset
MEMORY_TARGET so that ASM can use the default value, but if MEMORY_TARGET is
explicitly set, please make sure it's large enough, following the next
rules:
1) If PROCESSES
parameter is explicitly set:
The MEMORY_TARGET should be
set to no less than:
256M + PROCESSES * 132K (64bit)
or
256M + PROCESSES * 120K (32bit)
2) If PROCESSES parameter is not
set:
The MEMORY_TARGET should be set to no less than:
256M +
(available_cpu_cores * 80 + 40) * 132K (64bit)
or
256M + (available_cpu_cores * 80 + 40) * 120K (32bit)
======================================================
Community Discussions
Still have questions? Use the communities window below to search for similar discussions or start a new discussion on this subject. (Window is the live community not a screenshot)
Click here to open in main browser window
References
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-763571/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- CRS-215 Srvctl unable to start ASM, Listener, RDBMS ResourcesASM
- 11.2.0.3 ASM例項出現ORA-4031導致資料庫歸檔失敗ASM資料庫
- ORACLE 11.2.0.3配置ASMOracleASM
- Unable to start HTTP server after restoreHTTPServerREST
- 11.2.0.3 ASM例項出現ORA-4031錯誤導致資料庫歸檔失敗ASM資料庫
- Oracle 11.2.0.3 管理ASM例項OracleASM
- Oracle 11.2.0.3管理ASM例項OracleASM
- RAC 11.2.0.3 ASM管理 (一) 引數ASM
- android studio Error:Unable to start the daemon process【轉】AndroidError
- Start of resource “ora.asm -init” failed -ASMAI
- OEL5.6+oracle11.2.0.3+ASM安裝OracleASM
- oracle asm Unable to mount ASMlib driver filesystemOracleASM
- Change AUTO_START in ASM Resource Oracle ClusterwareASMOracle
- 分析11.2.0.3 rac CRS-1714:Unable to discover any voting files
- springcloud和Eureka整合時報錯:Unable to start embedded TomcatSpringGCCloudTomcat
- the application was unable to start correctly 0xc000007bAPP
- 安裝ORACLE 11.2.0.3 ASM for AIX HA (Non-RAC)OracleASMAI
- Unable To Create Database Using ASM ORA-15055DatabaseASM
- 啟動Tomcat 失敗(Unable to start cluster)及解決方法Tomcat
- 11.2.0.3 RAC 全過程--6.Configure ASMASM
- Master Note For ASM For OS Administrators [ID 1345562.1]ASTASM
- ASM例項出現ORA-4031錯誤導致例項崩潰ASM
- Unable To Recreate DG Fast Start Failover Configuration With DGMGRL-454418.1ASTAI
- oracle 11.2.0.3 rac資料庫線上新增ASM儲存空間Oracle資料庫ASM
- oracle 11.2.0.3 單機 asm 儲存打psu 10補丁OracleASM
- ASM & Shared Pool (ORA-4031) (文件 ID 437924.1)故障解決一例ASM
- Can't debug c++ project because unable to static library start program *.libC++Project
- 【ASM】ASM資料檔案和OS檔案(FILESYSTEM)轉移方法總結ASM
- ORA-15055 Unable to Connect to ASM When Starting an InstanceASM
- 建立asm磁碟 報錯 oracleasm-write-label: Unable to clear deviceASMOracledev
- CLSRSC-184 CLSRSC-258: Failed to configure and start ASMAIASM
- linux下asm裡如何找到asm disk和os device的對應關係LinuxASMdev
- ORA-15183 Unable to Create Database on Server using 11.2 ASMDatabaseServerASM
- Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2DatabaseASM
- SUSE 11.1 安裝ORACLE 11.2.0.3 ASM非RAC雙機過程紀要OracleASM
- stop/start The CRS, OHAS, ASM, RDBMS & ACFS Services on RAC 11.2_1355977.1ASM
- DBCA建立ASM報錯ORA-27125: unable to create shared memory segmentASM
- ASM例項啟動報錯:ORA-29701 :unable to connect to Cluster ManagerASM