ORA-00837: Specified value of MEMORY_TARGET greater than MEM

报错原因

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!