?

?? 1. SQL>?show?sga
　　Total?System?Global?Area?2602007792?bytes
　　Fixed?Size?740592?bytes
　　Variable?Size?335544320?bytes
　　Database?Buffers?2264924160?bytes
　　Redo?Buffers?798720?bytes
　　SQL>?alter?system?set?sga_max_size=5000m?scope=spfile;
　　System?altered.
　　SQL>?shutdown?immediate;
　　SQL>?startup
　　SQL>?show?sga
　　Total?System?Global?Area?5252811728?bytes
　　Fixed?Size?744400?bytes
　　Variable?Size?2986344448?bytes
　　Database?Buffers?2264924160?bytes
　　Redo?Buffers?798720?bytes

?

2.出现如下错误：

ORA-00844 Parameter Parameter not taking MEMORY_TARGET into account, see alert log for more...

解决：

?

This is a issue that commonly occurs in that the dba modified the sga_target parameter to a larger

value, but forgot to modify the parameter memory_target (on 11g database) and the rule is that:

????????????????????????????????memory_target >= sga_target + pga_aggregate_target

?????????and if you have come accross this issue and found your database can not br startup now , don't be

worried, first you should pull out your current parameters using sqlplus :

???? 解决1步： ? SQL> create pfile from spfile;

modify the parameters in the instancename_init.ora as the rule above, then save the file:

?? 解决2步：???? SQL> create spfile from pfile;

then you should be able to startup now:

????????SQL> startup;

????????ORACLE 例程已经启动。

?

3.我的设置的是 *.memory_target=5242880000

?

?

?

4.windows pfile 文件在oracle_home/database下 linux等平台在在oracle_home/dbs下

数据库装载完毕。
数据库已经打开。

?

?