ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET

最新推荐文章于 2017-07-26 12:09:12 发布

转载最新推荐文章于 2017-07-26 12:09:12 发布 · 669 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/siiiso/blog/849233

文章标签：

#数据库

本文介绍了在增加Oracle宿主机内存后遇到的ORA-00837错误，并提供了详细的步骤来调整Oracle动态内存大小，确保其不超过最大内存限制。

为什么80%的码农都做不了架构师？>>>

报错原因

[oracle@Oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 2 10:31:06 2017

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> alter system set memory_target=26G scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET

增加Oracle宿主机内存后，修改Oracle动态内存大小超过最大内存大小，故报ORA-00837错误。

解决方法

[root@Oracle ~]# find / -name init.ora.*
/u01/app/oracle/admin/orcl/pfile/init.ora.62620151323

[oracle@Oracle ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 2 10:35:16 2017

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup pfile='/u01/app/oracle/admin/orcl/pfile/init.ora.62620151323';
ORACLE instance started.

Total System Global Area 2605551616 bytes
Fixed Size		    2211488 bytes
Variable Size		 1879048544 bytes
Database Buffers	  671088640 bytes
Redo Buffers		   53202944 bytes
Database mounted.
Database opened.

SQL> show parameter sga;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
lock_sga			     boolean	 FALSE
pre_page_sga			     boolean	 FALSE
sga_max_size			     big integer 2496M
sga_target			     big integer 0

SQL> show parameter memory;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address	     integer	 0
memory_max_target		     big integer 2496M
memory_target			     big integer 2496M
shared_memory_address		     integer	 0

SQL> create spfile from memory;

File created.

SQL> shutdown abort
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 2605551616 bytes
Fixed Size		    2216184 bytes
Variable Size		 2164264712 bytes
Database Buffers	  369098752 bytes
Redo Buffers		   69971968 bytes
Database mounted.
Database opened.

SQL> show parameter sga;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
lock_sga			     boolean	 FALSE
pre_page_sga			     boolean	 FALSE
sga_max_size			     big integer 2496M
sga_target			     big integer 0

SQL> show parameter memory;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address	     integer	 0
memory_max_target		     big integer 2496M
memory_target			     big integer 2496M
shared_memory_address		     integer	 0

转载于:https://my.oschina.net/siiiso/blog/849233