Appendix A:
Revision History
Revision 1.0
Friday February 28, 2014
Roger Lopez
Initial Release
Revision 1.1
Friday February 13, 2015
Roger Lopez
- Updated version of installed Oracle database and Oracle Grid Infrastructure to 12.1.0.2.0
- Added note to set
NOZEROCONF
to yes in Section
3.1
Setting OS Hostname
- Added new kernel parameter requirement: kernel.panic_on_oops = 1. It is set to 1 by
default on RHEL 6.5, but the Oracle Installer requires it to be set in
/etc/sysctl.conf
to pass
the prerequisite checks.
Section
3.3.13
Kernel Panic On OOPS Parameter
shows the
details.
- Changed recommendation to always create partitions when using either Oracle
ASMLib
or
udev
rules in
Section 3.4.2 Partitioning Device Mapper Shared Disks
- Moved NTP configuration under Section
3.3
OS Configuration
- Removed from Appendix C the duplicate 'defaults' entry in
/etc/mutlipath.conf
.
- The value of swappiness is changed from the value of 0 to the value of 1 for RHEL 6.4 or
higher due to the increase risk of a system OOM killing. Bugzillas for more information:
&
- Created a custom oracle tuned profile better suited than the existing enterprise-storage-no-
thp profile within
Section
3.4.4 Optimizing Database Storage using Automatic System
Tuning
- Created a 98-oracle.conf file that sets all the kernel parameters if not using the oracle tuned
profile. File should be placed in
/etc/sysctl.d
-
New
Section
6
Post Installation Cleanup Tasks
that removes setting oracle kernel
parameters from /etc/sysctl.conf once installation is complete and using either the oracle
tuned profile or the 98-oracle.conf to properly set those parameters.
- Added
Appendix
L
Custom Oracle Tuned Profile Scripts
section that includes the Oracle
custom profile scripts
Revision 1.2
Tuesday, March 10, 2015
Roger Lopez
- Updated
Section
3.4.4 Optimizing Database Storage using Automatic System Tuning
by changing the oracle custom profile to be based off the throughput-performance profile
instead of the enterprise-storage profile. Doing so, provides consistency of the profile for both
RHEL6 and RHEL7 deployments.
- The .tar.gz oracle custom oracle profile was modified to be based off the throughput-
performance profile and documented within the CHANGELOG
[email protected]
71
Appendix B:
Contributors
1.
John Herr, content (Subscription Manager)
2.
Balaji Jayavelu, content reviewer
3.
Tom Coughlan, content reviewer
4.
John Boero, content reviewer
5.
Yan Fisher, content reviewer
72
[email protected]
Appendix C:
DM Multipath Configuration
File
# This is a basic configuration file with some examples, for device mapper
# multipath.
# For a complete list of the default configuration values, see
# /usr/share/doc/device-mapper-multipath-0.4.9/multipath.conf.defaults
# For a list of configuration options with descriptions, see
# /usr/share/doc/device-mapper-multipath-0.4.9/multipath.conf.annotated
#
# REMEMBER: After updating multipath.conf, you must run
#
