修改Memory_max_target為0出錯
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-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/27036311/viewspace-1300676/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 測試memory_max_target
- memory_max_target/memory_target設定過大報ORA-00845錯誤
- 11g 中MEMORY_MAX_TARGET??
- 加大memory_max_target後,資料庫啟動報ora-00845錯誤處理資料庫
- 轉載 11g 中MEMORY_MAX_TARGET
- 如何為Python新增遠端除錯能力而不修改系統程式碼Python除錯
- [譯] 修改 Git 錯誤的高明方法Git
- 11g的MEMORY_TARGET和MEMORY_MAX_TARGET
- [Linux]修改ubuntu dash為bashLinuxUbuntu
- mantis 修改語言為繁體
- Incorrect MEMORY_MAX_TARGET (> Available RAM) Can Lead To Database HangsAIDatabase
- wmi修改ip返回錯誤值2147942705
- Laravel 修改 validate 提示資訊為中文Laravel
- Ubuntu下修改為永久DNS的方法UbuntuDNS
- iOS修改宣告為readonly的值iOS
- linux修改IP為靜態IPLinux
- Mysql 插入中文及中文查詢 (修改+除錯)MySql除錯
- 微信支付WxpayAPI_php_v3 錯誤修改APIPHP
- AWR 報告修改moving window 出錯分析
- android AVC錯誤修改許可權方法Android
- 修改VS Code的終端為Git BashGit
- mac mysql修改預設時區為 utcMacMySql
- 修改安卓ID為硬體唯一ID安卓
- 修改apt-get和yum為阿里源apt-get阿里
- 批量修改azure內網地址為靜態內網
- Linux 修改本地時間 (centos為例)LinuxCentOS
- 將資料庫修改為歸檔模式資料庫模式
- oracle 修改資料庫為歸檔模式Oracle資料庫模式
- 修改root使用者密碼為root密碼
- update修改為merge(max+decode)
- 修改11g RAC 為歸檔模式模式
- [SVG]修改固定顏色為填充顏色SVG
- 錯字修改 | 佈署1箇中文文文字拼蟹糾錯模型模型
- laravel5.8 如何修改.env路徑?如修改./.env為./env/product.envLaravel
- 解決ubuntu修改密碼 Module is unknow報錯Ubuntu密碼
- 編譯修改*火GPS除錯助手(開源)編譯除錯
- Kong Gateway 修改原始碼完成自定義錯誤返回Gateway原始碼
- ThinkPHP框架下成功、錯誤模板頁面修改PHP框架