首页 > 代码库 > oracle12C rac DBCA报错 ORA-00838: Specified value of MEMORY_TARGET is too small

oracle12C rac DBCA报错 ORA-00838: Specified value of MEMORY_TARGET is too small

安装oracle发现/etc/profile和.bashrc环境变量设置有冲突,oracle用户的$ORACLE_HOME没生效
 
技术分享
 
Question:  After increasing by "processes" parameter (processes 3000), I got the following ORA-00838 error at database startup time.  Note that I am on 12c and I have not set my sga_target or pga_aggregate_target parameter.  After re-setting processes=1000 the ORA-00838 error disappeared.  Why?
 
ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3072M
ORA-01078: failure in processing system parameters
How do I correct the ORA-00838 error?
 
Answer:  The oerr utility  shows the cause and action for the ORA-02097:
 
ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least string
 
Cause: The specified value of MEMORY_TARGET was less than the sum of the specified values for SGA_TARGET and PGA_AGGREGATE_TARGET.
 
Action: Set MEMORY_TARGET to at least the recommended value.
 
In this case the increase of your processes parameter was the root cause of the ORA-00838 error.  As we my know the processes parameter determines the sessions parameter that this must, in turn, indicate to Oracle that additional RAM is required to support the extra sessions.
 
As a workaround, of course, you can increase your memory_target parameter value.
 
由于安装过程中将进程数量由初始值300调到5000导致所需内存增加,保持初始值不变即可顺利安装



oracle12C rac DBCA报错 ORA-00838: Specified value of MEMORY_TARGET is too small