报错原因
[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
