ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
解決步驟如下:
1. startup pfile=/u01/app/oracle/product/11.2.0/dbs/initmydb.ora
2. show parameter sga
3.show parameter mem
4.create spfile from pfile
5.create spfile from memory;
6. shutdown abort
7.startup
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31496956/viewspace-2155909/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00838: Specified value of MEMORY_TARGET is too small
- 11g的MEMORY_TARGET和MEMORY_MAX_TARGET
- OGG-01705 Input checkpoint position is greater than the size of the file
- 關於memory_max_target,memory_target,sga_max_size,sga_target
- memory_max_target,memory_target,pga_aggregate_target,sga_target
- [LeetCode] 2275. Largest Combination With Bitwise AND Greater Than ZeroLeetCode
- [LeetCode] 1343. Number of Sub-arrays of Size K and Average Greater than or Equal to ThresholdLeetCode
- Granules of pga_aggregate_target 494 cannot be more than memory_target (497)
- memory_max_target/memory_target設定過大報ORA-00845錯誤
- java.sql.SQLException: No value specified for parameter 1 異常分析JavaSQLException
- JDBC:The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone.JDBCServerZed
- 異常解決——The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than oneServerZed
- 452 Error writing file: A file cannot be larger than the value set by ulimit.ErrorMIT
- 關於oracle11G的自動記憶體管理MEMORY_TARGET和MEMORY_MAX_TARGETOracle記憶體
- mysql執行報The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one tim......MySqlServerZed
- ORA-32021: parameter value longer than 255 characters 解決方法
- Oracle 11g使用dbca安裝資料庫時報錯"SGA size can not be greater than、ORA-27102"Oracle資料庫
- 如何啟用oracle11g的全自動記憶體管理以及計算memory_max_target及memory_targetOracle記憶體
- 如何基於pfile啟動oracle11g全自動記憶體管理與memory_max_target及memory_targetOracle記憶體
- 測試memory_max_target
- MEMORY_TARGET not supported on this system
- 11g 中MEMORY_MAX_TARGET??
- No input file specified.
- 修改Memory_max_target為0出錯
- DNS: More than just namesDNS
- Why Java is better than .NETJava
- 轉載 11g 中MEMORY_MAX_TARGET
- ORA-00845: MEMORY_TARGET
- SGA PGA MEMORY_TARGET 關係
- MEMORY_TARGET not supported on this system for linuxLinux
- LeetCode之Convert BST to Greater Tree(Kotlin)LeetCodeKotlin
- ORA-00845 MEMORY_TARGET not supported
- Oracle11g修改MEMORY_TARGETOracle
- 執行gedit報No protocol specifiedProtocol
- No input file specified 解決方法
- Kill all sessions of a specified user nameSession
- Centering HTML elements larger than their parentsHTML
- 8 27 組隊賽 Greater New York 2012