在測試oracle 10.2.0.4更新到10.2.0.5 patch set的過程中，遇到一個核心參數檢查失敗的問題，具體錯誤資訊如下所示
實驗環境：
作業系統：oracle linux server release 5.7
記憶體：4g
資料庫版本：10.2.0.4.0
有點納悶，為什麼這些參數在10.2.0.1安裝和更新到10.2.0.4的時候都通過檢測，但是在應用更新檔10.2.0.5時反而不能通過了呢？我們先看看原先的值
1：checking for file-max=101365; found file-max=65536. failed <<<<
這個失敗，很好了解，因為processes為
150，而參數65536 = 512*128 , 我們的程序數為150，大于128（fs.file-max = 512 x processes
(for example 65536 for 128 processes) ，是以系統給了一個推薦值（具體怎麼計算，還沒弄清楚）
2：checking for ip_local_port_range=9000 - 65500; found ip_local_port_range=1024 - 65000. failed <<<<
這個參數，官方文檔推薦就是
net.ipv4.ip_local_port_range = 9000 65500 ，也沒啥好說的。 the runinstaller
(oui) checks may expect this to be the old guidance of "1024 65000". the
new guidance from oracle development is "9000 65500". please allow the
runinstaller (oui) to proceed with the new guidance from oracle
development.
3：關鍵是下面這幾個參數為啥會失敗，有點納悶？
checking for rmem_default=1048576; found rmem_default=262144. failed <<<<
checking for rmem_max=1048576; found rmem_max=262144. failed <<<<
check complete. the overall result of this check is: failed <<<<
在官方文檔requirements for installing oracle10gr2 on rhel 5/oel 5 (x86_64) (文檔 id 421308.1)裡面有下面介紹，也是上面的配置值
4. set the kernel parameters
add the following the lines in the file /etc/sysctl.conf
kernel.shmall = physical
ram size / pagesize for most systems, this will be the value 2097152.
see note 301830.1 for more information.
kernel.shmmax = 1/2 of
physical ram. this would be the value 2147483648 for a system with 4gb
of physical ram. see note 567506.1 for more information.
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 512 x processes (for example 65536 for 128 processes)
development recommends a minimum of 327679 for active systems.
net.ipv4.ip_local_port_range = 9000 65500
(the runinstaller (oui) checks may expect this to be the old guidance of 1024 65000.
the new guidance from oracle development is 9000 65500.
please allow the runinstaller (oui) to proceed with the new guidance from oracle development.)
net.core.rmem_default = 262144
net.core.rmem_max = 2097152
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
後面在官方文檔 requirements for installing oracle10gr2 on rhel 5/oel 5 (x86_64) (文檔 id 421308.1) 裡面看到，這個是oracle的一個bug來的，可以忽略這個錯誤，具體見截圖