oracle安裝由於sga設定大報錯

mengbing1990發表於2017-03-22
Oracle

主機記憶體512G，sga_target準備設定為320G，
restore一個資料庫過來測試，rman target /
startup mount 的時候，一直報錯ORA-27102: out of memory

直接使用DBCA預設引數把庫建好後，再次使用命令來修改，報錯依舊。就是與SGA Granule Size相關，設定_ksmg_granule_size=33554432（之前是4M）解決此問題。

文件部分內容：

CAUSE

The cause of this problem has been identified in , which has been closed as not-a-bug. It is caused by the granule size needed for the new SGA size to be different than the one currently in use by the instance at the time the ALTER SYSTEM SET SGA_TARGET command is run.

SOLUTION

This is expected behaviour: the granule size is set based on the size of the SGA. If you set a SGA parameter (such as SGA_TARGET) to a value which exceeds the value of the granule size that was calulcated at instance startup, then you must set the _ksmg_granule_size instance parameter as well to choose a larger granule size. As this parameter is not dynamically changeable, an instance restart is required.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29551564/viewspace-2135864/，如需轉載，請註明出處，否則將追究法律責任。

相關文章