11.1資料庫版本修改memory_target引數應避開4的倍數
11.1資料庫版本修改memory_target引數應避開4的倍數
實驗環境：
RAC叢集，memory_target自動記憶體管理。
firstnode:
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA_DB/orcl/spfileORCL.
ora
SQL> show parameter mem
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 50G
memory_target big integer 50G
shared_memory_address integer 0
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 50G
sga_target big integer 0
SQL> alter system set memory_max_target=40G scope=spfile sid='*';
System altered.
SQL> alter system set memory_target=40G scope=spfile sid='*';
System altered.
SQL> alter system set sga_max_size=40G scope=spfile sid='*';
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 304 bytes (PCursor,kglob)
告警日誌報錯：
Reconfiguration complete
Thu Dec 12 15:53:31 2013
LCK0 started with pid=74, OS id=18994
Thu Dec 12 15:53:31 2013
Starting background process RSMN
Thu Dec 12 15:53:31 2013
RSMN started with pid=77, OS id=18996
ORACLE_BASE from environment = /u01/oracle
Thu Dec 12 15:53:33 2013
Errors in file /u01/oracle/diag/rdbms/orcl/orcl1/trace/ORCL1_ora_18997.trc (incident=1640240):
ORA-04030: out of process memory when trying to allocate 304 bytes (PCursor,kglob)
Incident details in: /u01/oracle/diag/rdbms/orcl/ORCL1/incident/incdir_1640240/ORCL1_ora_18997_i1640240.trc
Thu Dec 12 15:53:35 2013
NOTE:Loaded library: System
Thu Dec 12 15:53:36 2013
Trace dumping is performing id=[cdmp_20131212155336]
Thu Dec 12 15:53:36 2013
SUCCESS: diskgroup DATA_ZKF was mounted
Errors in file /u01/oracle/diag/rdbms/orcl/ORCL1/trace/ORCL1_mmon_18884.trc (incident=1640656):
ORA-04031: unable to allocate 393288 bytes of shared memory ("large pool","unknown object","large pool","ASM map operations hashtable")
Incident details in: /u01/oracle/diag/rdbms/orcl/ORCL1/incident/incdir_1640656/ORCL1_mmon_18884_i1640656.trc
Thu Dec 12 15:53:38 2013
Errors in file /u01/oracle/diag/rdbms/orcl/ORCL1/trace/ORCL1_ping_18844.trc:
Trace dumping is performing id=[cdmp_20131212155340]
Errors in file /u01/oracle/diag/rdbms/orcl/ORCL1/trace/ORCL1_mmon_18884.trc (incident=1640657):
ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [4031], [], [], [], [], [], []
ORA-04031: unable to allocate 393288 bytes of shared memory ("large pool","unknown object","large pool","ASM map operations hashtable")
Incident details in: /u01/oracle/diag/rdbms/orcl/ORCL1/incident/incdir_1640657/ORCL1_mmon_18884_i1640657.trc
節點2：
SQL> show parameter mem
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 50G
memory_target big integer 50G
shared_memory_address integer 0
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 50G
sga_target big integer 0
SQL> alter system set memory_max_target=42G scope=spfile sid='*';
System altered.
SQL> alter system set memory_target=42G scope=spfile sid='*';
System altered.
SQL> alter system set sga_max_size=42G scope=spfile sid='*';
System altered.
節點1：
$ ps -ef |grep smon
root 2541 1 0 Dec 11 ? 0:00 /etc/opt/resmon/lbin/emsagent
orazkf 18876 1 0 15:52:55 ? 0:00 ora_smon_ORCL1
root 3045 1 0 Dec 11 ? 0:00 /etc/opt/resmon/lbin/p_client
grid 3612 1 0 Dec 11 ? 0:01 asm_smon_+ASM1
orazkf 19539 18437 0 15:55:29 pts/1 0:00 grep smon
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 12 15:55:35 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected.
SQL> shutdown immediate
ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 304 bytes (PCursor,kglob)
SQL> exit
Disconnected
$ ps -ef |grep smon
root 2541 1 0 Dec 11 ? 0:00 /etc/opt/resmon/lbin/emsagent
orazkf 18876 1 0 15:52:55 ? 0:00 ora_smon_ORCL1
root 3045 1 0 Dec 11 ? 0:00 /etc/opt/resmon/lbin/p_client
grid 3612 1 0 Dec 11 ? 0:01 asm_smon_+ASM1
orazkf 19551 18437 1 15:55:55 pts/1 0:00 grep smon
$ kill -9 18876
再嘗試啟動：
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 12 15:57:19 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 4.4896E+10 bytes
Fixed Size 2119288 bytes
Variable Size 2.3951E+10 bytes
Database Buffers 2.0938E+10 bytes
Redo Buffers 4362240 bytes
Database mounted.
Database opened.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24500180/viewspace-1063482/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- DM7修改資料庫引數資料庫
- 關於修改資料庫引數的測試資料庫
- 修改資料庫的NLS_DATE_FORMAT引數資料庫ORM
- 天翼雲RDS資料庫如何修改資料庫引數資料庫
- 將rac資料庫改為單機資料庫需要修改的引數資料庫
- pg14資料庫引數修改方式小結資料庫
- ORACLE 11.2 RAC修改資料庫靜態引數Oracle資料庫
- 【引數】ORACLE修改資料庫名之完整版Oracle資料庫
- MySQL資料庫引數MySql資料庫
- hp unix中nfile引數的修改案例(rac模式的資料庫)模式資料庫
- 轉:tsm版本控制_的4個引數
- 調整資料庫引數資料庫
- 9i資料庫下修改session_cached_cursors引數資料庫Session
- 【YashanDB知識庫】yac修改引數後關閉資料庫hang住資料庫
- oracle資料庫修改連線數Oracle資料庫
- 顯示資料庫所有引數資料庫
- Oracle 資料庫引數調整Oracle資料庫
- Oracle資料庫系統中的引數Oracle資料庫
- Oracle資料庫中的系統引數Oracle資料庫
- 資料庫易混淆引數名以及引數檔案啟動資料庫到nomount狀態資料庫
- postgresql資料庫重要引數說明SQL資料庫
- Mysql 5.5 設定資料庫引數MySql資料庫
- MySQL 5.7資料庫引數優化MySql資料庫優化
- Nagios資料庫引數配置分析iOS資料庫
- Oracle 資料庫應急寶典(二)_引數檔案篇Oracle資料庫
- Oracle資料庫系統中的引數（續）Oracle資料庫
- Thread pool引數引起的程式連線資料庫響應慢thread資料庫
- linux引數修改Linux
- 動態引數與靜態引數的判斷、修改
- expdp/impdp 使用version引數跨版本資料遷移
- 達夢資料庫引數調整方法資料庫
- oracle 資料庫兩種引數檔案Oracle資料庫
- 使用SQL來分析資料庫引數（二)SQL資料庫
- RCU-資料庫初始化引數資料庫
- 配置資料庫非同步I/O引數資料庫非同步
- 關於資料庫標識類引數資料庫
- MySQL資料庫innodb_fast_shutdown引數MySql資料庫AST
- Oracle12c中配置例項引數和修改容器資料庫（CDB）及可插拔資料庫（PDB）Oracle資料庫