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