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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [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
- java.sql.SQLException: No value specified for parameter 1 異常分析JavaSQLException
- 異常解決——The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than oneServerZed
- ORA-65294: PDB's compatible parameter value (12.2.0.1.0) is higher than CDB's
- JDBC:The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone.JDBCServerZed
- mysql執行報The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one tim......MySqlServerZed
- MEMORY_TARGET not supported on this system
- 538-Convert BST to Greater Tree
- LeetCode之Convert BST to Greater Tree(Kotlin)LeetCodeKotlin
- No input file specified.
- DNS: More than just namesDNS
- Incorrect MEMORY_MAX_TARGET (> Available RAM) Can Lead To Database HangsAIDatabase
- 解決辦法:ORA-00845: MEMORY_TARGET not supported on thi
- 執行gedit報No protocol specifiedProtocol
- kafka 錯誤: larger than available brokersKafkaAI
- CTF-safer-than-rot13-writeup
- [Leetcode學習-c++&java]Next Greater Element I ~ IIILeetCodeC++Java
- 解決IDEA Error:Output directory is not specifiedIdeaError
- Failed to configure a DataSource: ‘url‘ attribute is not specified and no embeddedAI
- 頁面報錯 No input file specified
- More than one file was found with OS independent path
- Poster stopped: message is larger than configured max size
- OpenKruise 2021 規劃曝光:More than workloadsUI
- golang multiple-value xxx in single-value contextGolangContext
- LeetCode演算法題-Next Greater Element I(Java實現)LeetCode演算法Java
- [20231103]sqlplus column new_value old_value.txtSQL
- [20230303]sqlplus column new_value old_value.txtSQL
- The following instances are in the device manifest but not specified in framework compatibility matrix:devFramework
- ORA-00054: resource busy and acquire with NOWAIT specifiedUIAI
- no input file specified 三種解決方法
- Table is specified twice, both as a target for 'UPDATE' and as a separate source
- JavaScript select valueJavaScript
- @ConfigurationProperties和@Value
- Better than better,白山EC2.0釋出
- gem5 CPU ISA level is lower than requiredUI
- Oracle分析函式-first_value()和last_value()Oracle函式AST
- Web 伺服器顯示 no input file specifiedWeb伺服器