Oracle Validated Configurations をちゃんと読むその2

Oracle Validated Configurations をちゃんと読む - tmpfile::memoで色々書いたら、結構英語に翻訳している人がいるみたいだなぁと思っていたのと、ちょっと面白いことがあったので。

vc_hpdl585-oel4-evaだけに kernel.sysrq=1 が明記。また set to a value half the size of physical memory や rmem_max can be tuned based on workload to balance performance vs lowmem usage の親切な注釈付き。

とか書いたせいではないだろうけれど、現時点で最新の Publication Date: June 18, 2007 な "Oracle Database 10g (10.2.0.3) Single Instance and Oracle Real Application Clusters (RAC) on Oracle Enterprise Linux 4 Update 4 and Red Hat Enterprise Linux 4 Update 4 AS/ES x86-64 using ASM + Dell PowerEdge 6950 + Dell EMC CX3-80" Tue, 19 Jun 2007 17:56:01 GMTには、

kernel.sysrq=1
# rmem_max can be tuned based on workload to balance performance vs lowmem usage

おおっ！

ただ、結局のところOracle Validated Configurations をちゃんと読む - tmpfile::memoで引用してた "Oracle Database 10g (10.2.0.3) Single Instance and RAC on Oracle Enterprise Linux 4 x86-64 and Red Hat EnterpriseLinux 4 AS/ES x86-64 using Automatic Storage Management (ASM) + HP ProLiant DL585 Server series + HP StorageWorks 4000 EVA"Published: March 7, 2007からコピーしたらしい。
Dell+EMCはこんなんで良いのかいな．．．

Configuration Feedbackより、 "Oracle Database 10g (10.2.0.3) Single Instance and Oracle Real Application Clusters (RAC) on Oracle Enterprise Linux 4 Update 4 and Red Hat Enterprise Linux 4 Update 4 AS/ES x86-64 using ASM + Dell PowerEdge 6950 + Dell EMC CX3-80" Tue, 19 Jun 2007 17:56:01 GMTで変わった点だけ書きます。

4593892 repeated warnings in dmesg about lost ticks (it 80129/bz 139376)
affects: usually seen on x86-64, both Intel and Opteron based systems
symptom: dmesg will have errors like:
warning: many lost ticks.
Your time source seems to be instable or some driver is hogging interupts
rip __do_softirq+0x4d/0xd0
workaround: none at the moment

が

solution: fixed in U5

し、しかし、

Linux Distribution Details
OEL4 Update 4 x86_64 (default install)
kernel-largesmp-2.6.9-42.0.0.0.1.EL.x86_64.rpm or higher

RHEL 4 AS/ES Update 4 x86-64 (default install)
kernel-largesmp-2.6.9-42.EL.x86_64.rpm or higher

ってことで、U5(REHL4.5)で試してはいないようで、何を根拠に Fixなんだろう。
139376 – Repeated warnings in dmesg about lost ticksも更新されてないし。しかし Issue Trackerは見えないし。もんもん。

次、

5017352 warning messages in trace files during certain workloads with async io turned on
affects: performance
symptom: Following warnings in trace files
WARNING: ORACLE PROCESS RUNNING OUT OF OSKERNEL I/O RESOURCES
workaround: none at the moment

が

solution: apply patch 5452672

し、しかし、 Oracle Software Details にこのパッチのことがまるっきり書いてない。
これも試していないのかな．．．

結局何が Varidated ?

おまけ。
"Oracle Database 10g (10.2.0.3) Single Instance and Oracle Real Application Clusters (RAC) on Oracle Enterprise Linux 4 Update 4 and Red Hat Enterprise Linux 4 Update 4 AS/ES x86-64 using ASM + Dell PowerEdge 6950 + Dell EMC CX3-80" Tue, 19 Jun 2007 17:56:01 GMTなのに

5693201 Application does not detect EL4 as RHEL4
affects: Installation of HP PSP on EL4
symptoms: PSP installation fails with error "Please check /etc/redhat-release for correctness"
workaround: echo "Red Hat Enterprise Linux AS release 4 (Nahant Update 4)" > /etc/redhat-release

いくらなんでもこれまでコピーしなくても良いのに。

REHL4.5かOracle'sEL4.5とapply patch 5452672の結果を報告してくれる Oracle Validated Configuration 待ちですね。