Oracle 修改 MEMORY_TARGET

2014-11-24 18:27:27 · 作者: · 浏览: 0

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