Standby MRP crashing due to ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K
Cause :
SQL> show parameter 16k
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
db_16k_cache_size big integer
0 <<<<<<<<<<< Not set value
Cause :
SQL> show parameter 16k
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
db_16k_cache_size big integer
0 <<<<<<<<<<< Not set value
SQL>
Solution :
1.)
SQL> alter system set db_16k_cache_size=512M scope=SPFILE;
System altered.
Note: value of this parameter must in multiple of 16k.
2.)Restart DB
>>>> Note : To take effect of this parameter value, DB restart is required.
Solution :
1.)
SQL> alter system set db_16k_cache_size=512M scope=SPFILE;
System altered.
Note: value of this parameter must in multiple of 16k.
2.)Restart DB
>>>> Note : To take effect of this parameter value, DB restart is required.
No comments:
Post a Comment