Oracle 修改 MEMORY_TARGET

Oracle 修改 MEMORY_TARGET，内存减小导致ORACLE启动不了，扩展内存后，按pfile启动，但sfile修改不了。

1.内存减小导致oracle启动不了
 
last login: sun nov  4 15:09:06 2012 from 192.168.5.222
[oracle@h1 ~]$ sqlplus "/as sysdba"
 
sql*plus: release 11.2.0.1.0 production on sun nov 4 15:26:59 2012
 
copyright (c) 1982, 2009, oracle.  all rights reserved.
 
connected to an idle instance.
 
sql> startup pfile=/app/oracle/admin/orcl/pfile/init.ora.103201271612
ora-00845: memory_target not supported on this system
sql> shutdown abort     
oracle instance shut down.
sql> startup pfile=/app/oracle/admin/orcl/pfile/init.ora.103201271612 force
ora-00845: memory_target not supported on this system
sql> exit
disconnected
 
#---------解决：扩展内存
 
#--------pfile位置：$oracle_base/admin/[$oracle_sid]/pfile/init.ora.*
 

2.扩展内存后，按pfile启动，，但sfile修改不了
 
SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 4 16:00:25 2012
 
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup pfile=/app/oracle/admin/orcl/pfile/init.ora.103201271612 force
ORACLE instance started.
 
#----------按ORACLE PFILE 启动
 
Total System Global Area 1219260416 bytes
Fixed Size                  2212856 bytes
Variable Size            738200584 bytes
Database Buffers          469762048 bytes
Redo Buffers                9084928 bytes
Database mounted.
Database opened.
SQL> alter system set memory_max_target=1258200M scope=both;
alter system set memory_max_target=1258200M scope=both
                *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
 

SQL> alter system set memory_max_target=1258200M scope=spfile;
alter system set memory_max_target=1258200M scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use//spfile文件可能不存在
 
#-------------/app/oracle/product/11.2.0/dbhome_2/dbs/----------------存放spfile