Oracle 修改 MEMORY_TARGET

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

Oracle 11g在Linux6下安装及报错 C [ld-linux-x86-64.so.2+0x14d70]的解决方法Oracle 缺失INITORCL及Oracle启动过程相关资讯 Oracle基础教程 MEMORY_TARGET

memory_target设置不当导致数据库（10/28/2014 19:58:10）
Oracle块编程返回结果集详解（11/10/2013 10:45:58）
Oracle基础教程之设置系统全局区（08/22/2013 14:24:00）

Oracle初始化参数之memory_target （10/08/2014 13:21:41）
Oracle基础教程之tkprof程序详解（10/22/2013 11:49:50）
Oracle基础教程之sqlplus汉字乱码（07/18/2013 16:30:00）

本文评论查看全部评论（0）