修改Memory_max_target为0出错
来源:互联网 发布:炫踪网络红杉 编辑:程序博客网 时间:2024/06/06 03:48
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 be modified
SQL> alter system set memory_max_target=0 scope=spfile; --
System altered.
SQL> alter system set sga_target=6G scope=spfile;
System altered.
SQL> alter system set pga_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 into account
ORA-00849: SGA_TARGET 6442450944 cannot be set to more than MEMORY_MAX_TARGET 0.
SQL> startup nomount
ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account
ORA-00849: SGA_TARGET 6442450944 cannot be set to more than MEMORY_MAX_TARGET 0.
解决方法:
Symptoms
When trying to set SGA_TARGET using an ALTER SYSTEM command, the following errors are raised:
ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account
ORA-00849: SGA_TARGET 10737418240 cannot be set to more than MEMORY_MAX_TARGET 0.
Changes
MEMORY_MAX_TARGET was set to 0.
Cause
The problem is caused by the MEMORY_MAX_TARGET parameter explicitly 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 the MEMORY_MAX_TARGET=0 and MEMORY_TARGET=0 lines. After that, use the modified PFILE to create a new SPFILE and start the instance with this new setup.
[oracle@bakdbserver dbs]$ vi initbakdb.ora
SPFILE='+DATA/bakdb/spfilebakdb.ora'
memory_max_target=21G
memory_target=21G
[oracle@bakdbserver dbs]$ sqlplus "/as sysdba"
SQL> startup - should the instance be running, then use the following commands to remove the explicit setting of MEMORY_TARGET=0 and MEMORY_MAX_TARGET=0:
alter system reset memory_target;
alter system reset memory_max_target;
[oracle@bakdbserver dbs]$ vi initbakdb.ora
SPFILE='+DATA/bakdb/spfilebakdb.ora'
#memory_max_target=21G
#memory_target=21G
[oracle@bakdbserver dbs]$ sqlplus "/as sysdba"
SQL> startup force
- 修改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出错
- 数据结构实验图论一:基于邻接矩阵的广度优先搜索遍历
- USACO Street Race 解题报告
- POCO C++库学习和分析 -- 线程 (三)
- discuz站点迁移或者更换域名后引起的云平台异常解放方法
- 设置布局问题
- 修改Memory_max_target为0出错
- 取得 APP 自己的版本号 (狠跨 4 个平台)
- WIN32字符串转换
- 内部类 外部类区别与联系
- Java中 内存区域划分
- Java中的异常处理机制的简单原理和应用。
- android应用如何启动另外一个apk应用
- OVS上创建了一个vlan
- [leetcode] Word Ladder