修改Memory_max_target为0出错
来源:互联网 发布:php empty和! 编辑:程序博客网 时间:2024/05/21 06:24
SQL> connect / as sysdba
Connected.
SQL> alter system set memory_target=0;
System altered.
SQL> alter system set memory_max_target=0;
alter system set memory_max_target=0
ERROR at line 1:
ORA-02095: specified initialization parameter cannot bemodified
SQL> alter system set memory_max_target=0scope=spfile; --
System altered.
SQL> alter system set sga_target=6Gscope=spfile;
System altered.
SQL> alter system setpga_aggregate_target=2112M;
System altered.
SQL> alter system set shared_pool_size=0;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00843: Parameter not taking MEMORY_MAX_TARGET intoaccount
ORA-00849: SGA_TARGET 6442450944 cannot be set to more thanMEMORY_MAX_TARGET 0.
SQL> startup nomount
ORA-00843: Parameter not taking MEMORY_MAX_TARGET intoaccount
ORA-00849: SGA_TARGET 6442450944 cannot be set to more thanMEMORY_MAX_TARGET 0.
解决方法:
Symptoms
When trying to set SGA_TARGET using an ALTER SYSTEM command, thefollowing errors are raised:
ORA-00843: Parameter not taking MEMORY_MAX_TARGET intoaccount
ORA-00849: SGA_TARGET 10737418240 cannot be set to more thanMEMORY_MAX_TARGET 0.
Changes
MEMORY_MAX_TARGET was set to 0.
Cause
The problem is caused by the MEMORY_MAX_TARGET parameterexplicitly being set to 0. In case AMM should not be used,MEMORY_MAX_TARGET should not be set at all.
Solution
The solutions to the problem are:
- create a PFILE from the SPFILE being used and remove theMEMORY_MAX_TARGET=0 and MEMORY_TARGET=0 lines. After that, use themodified PFILE to create a new SPFILE and start the instance withthis new setup.
- should the instance be running, then use the following commandsto remove the explicit setting of MEMORY_TARGET=0 andMEMORY_MAX_TARGET=0:
altersystem reset memory_target;
alter system reset memory_max_target;
- 修改Memory_max_target为0出错
- 修改Memory_max_target为0出错
- 修改Memory_max_target为0出错
- RAC中修改memory_max_target为0
- Oracle无法修改memory_max_target,memory_target的值
- 参数MEMORY_MAX_TARGET 和MEMORY_TARGET 的修改
- MEMORY_TARGET/MEMORY_MAX_TARGET
- Oracle的memory_max_target和memory_target修改和ORA-00845: MEMORY_TARGET not supported on this system错误解决
- Oracle的memory_max_target和memory_target修改和ORA-00845: MEMORY_TARGET not supported on this system错误解决
- 设置了memory_max_target
- 修改数据时出错
- ip修改第二位出错
- 安装.net Framework2.0出错,提示内容为:Error 25015
- 数据库异常 从varchar转换为int出错[0x80040a07]
- netconn_accept返回值为0,OSQCreate出错 lwip uocsii
- 解决ajax请求出错状态码为0的问题
- Maven工程修改pom.xml里的packaging标签值为pom后出错,没任何提示的解决方案
- 修改Hostname导致netca出错
- 银行卡密码的加密、MAC计算
- Dataguard启停顺序
- WARNING: REMOTE HOST IDENTIFICAT…
- linux/solaris下增加swap分区(全)
- rsync命令
- 修改Memory_max_target为0出错
- Solaris 常见问题问答
- 光纤跳线相关知识
- Solaris资源监控命令
- URAL 2018 The Debut Album(DP)
- LOG GAP检测和解决
- 拉式物料和推式物料
- Linux下安装 JDK1.6
- DB File Size limit