欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

Oracle 修改 MEMORY_TARGET

程序员文章站 2022-05-29 23:12:53
...

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

Oracle 修改 MEMORY_TARGET