ORA-00843,ORA-00849 When Trying To Change SGA_TARGET With MEMORY_MAX_TARGET=0
ORA-00843, ORA-00849 When Trying To Change SGA_TARGET With MEMORY_MAX_TARGET=0 Being Active (文件 ID 1397761.1)
Information in this document applies to any platform.
***Checked for relevance on 25-Sep-2013***
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 and laterInformation in this document applies to any platform.
***Checked for relevance on 25-Sep-2013***
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.
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.
-
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;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/2317695/viewspace-2155811/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- OracleASM關閉AMM,開啟ASMM,修改引數後報ORA-00843 ORA-00849OracleASM
- 關於memory_max_target,memory_target,sga_max_size,sga_target
- memory_max_target,memory_target,pga_aggregate_target,sga_target
- GET ORA-32700 WHEN TRYING TO CREATE DATABASE USING 9.2Database
- 修改Memory_max_target為0出錯
- ORACLE ORA-04030之 out of process memory when trying to allocateOracle
- oracle安裝遇到:CreateFile() error 32 when trying set file timeOracleError
- ORA-600 [13011] when trying to delete a row-28184.1delete
- Can't find the 'libpq-fe.h header when trying to install pg gemHeader
- AIX平臺下報ORA-04030: out of process memory when trying to allocate string bytesAI
- PMON TRYING TO START CJQ0 DURING DATABASE SHUTDOWN-ORA-443&ORA-450Database
- 測試memory_max_target
- ORA-0 encountered when generating server alert SMG-4121Server
- SGA_TARGET Advice
- [20190507]sga_target=0注意修改_kghdsidx_count設定.txt
- sga_target大小調整
- The SGA_TARGET Initialization Parameter (74)
- 11g 中MEMORY_MAX_TARGET??
- Oracle OCP 1Z0 053 Q662(rman change tracking file)Oracle
- sqlserver Change Data Capture&Change TrackingSQLServerAPT
- Trying to hack Redis via HTTP requestsRedisHTTP
- Oracle OCP 1Z0 053 Q78(RMAN&change tracking file)Oracle
- oracle 重設定sga_targetOracle
- Dynamic Modification of SGA_TARGET (103)
- Oracle OCP IZ0-053 Q687(ASM Shutdown immediate when users connected)OracleASM
- Oracle OCP 1Z0 O53 Q78(RMAN block change tracking)OracleBloC
- ORACLE CASE WHEN 及 SELECT CASE WHEN的用法Oracle
- JavaScript change 事件JavaScript事件
- js change 事件JS事件
- jQuery change事件jQuery事件
- Change domain timeAI
- Who is the Last Change?AST
- 轉載 11g 中MEMORY_MAX_TARGET
- Oracle10g修改SGA_TARGETOracle
- sga_target與sga_max_size
- SGA_MAX_SIZE與SGA_TARGET
- sga_target與max_sga_size
- 改sga_target的注意事項