Coopers Consulting Solutions Limited

Looking at the notes i’d written when i did this i thought it best to break this up into 2 parts.

This first part looks at the installation and configuration of the server. Part 2 will focus on the install of R12 and the post install steps.

Right-o let me set the scene. This install is onto a 1-node-1-user machine; i.e. a laptop
I’ve done the install before, and that was onto a laptop with Oracle Enterprise Linux (OEL) 4.7. However this time i wanted to step away from the usual enterprise distro’s and go with one of the more common respin’s.

For the uninitiated, CentOS is based on Red Hat enterprise – So 5.2 (or 5.3 in this case) is built on RHEL 5.2

Hardware

For this install, i am using a Dell Vostro 1710 laptop that i bought for the sole purpose of putting Linux and my linux development toolkit onto. The core specs are as follows:

• CPU: Intel Core 2 Duo T5870 (2.0 GHz, 800MHz FSB, 2MB cache)
• Display: 17in widescreen WUXGA (running an impressive 1900×1200 resolution)
• Graphics: The usual Dell fare of NVIDIA GeForce 8600M GS (featuring 256MB DDR2)
• Memory: 4Gig – 667MHz DDR2 Dual channel
• Hard Drive: 500GB (Dual 250GB Seagate Momentus G-Force 7200rpm 16MB cache SATA) – This was not standard on the Dell configurator so was a post deliver mod
• Network:  Fairly standard Realtek RTL8168C PCI-E Gigabit ethernet, which fits nicely with my wired Gigabit network at home
• Optical Drive: 8x DVD+/-RW/RAM Drive

It came shipped from Dell with a downgrade to XP. The XP install lasted long enough for me to boot it to verify that all hardware was present and correct before the whole lot was wiped.

OS Install

The media for the install was a free DVD supplied with the December edition of linux format magazine. I’d already tried it out under Virtual Box, running on my OEL4.7 install on the same hardware, and had been impressed that it had nailed the Soundcard and Wireless card straight away (unlike the OEL install).

Anyway, booting up from the DVD i went through the partioning configurator and set up the following:

• The dual HDD’s were configured as a single logical volume (500GB)
• The boot partition /boot was configured to be 15MB fixed size
• The swap partition /swap was configured to be 4096MB (ie same size as the installed memory)
• The root partition / was configured to fill the remaining available disk space. I had to double check this, as my first attempt using automatic partitioning did not fill the remaining space and i was left with a large area effectively closed off from the OS!

Important!
Make sure that you elect to have NO firewall, and that the “Enable SELinux?” option is set to DISABLED. This is advice given in the original notes i followed when doing the OEL install last year. Aparently it causes issues later on when you come to install EBS R12.

Package Groups

During the OS install you will face the package manager. Presenting you with an array of scintillating choices. As i had disk space to play with i went a bit mad and selected the following:

• X Window System (required for EBS)
• GNOME Desktop environment (also required for EBS)
• Editors (your choice – i’m a big fan of Vi )
• Graphical internet
• Server configuration tools
• Development tools
• Administration tools

• System Tools

Required Packages

This list is taken from the Metalink note 402310.1 – Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux 32-bit

The following are required packages for EBS R12 (running on OEL 5 but also for CentOS). All versions are minimum required versions (except where stated):

• compat-glibc-2.3.4-2.26
• gcc-4.1.2-14.el5
• gcc-c++-4.1.2-14.el5
• glibc-2.5-12
• glibc-common-2.5-12
• glibc-devel-2.5-12
• libgcc-4.1.2-14.el5
• libstdc++-devel-4.1.2-14.el5
• libstdc++-4.1.2-14.el5
• make-3.81-1.1
• gdbm-1.8.0-26.2.1
• libXp-1.0.0-8.1.el5
• libaio-0.3.106-3.2
• libgomp-4.1.2-14.el5
• sysstat-7.0.0-3.el5
• compat-libstdc++-.296-2.96-138
• compat-libstdc++-33-3.2.3-61

In addition, i needed to pull the following files from the Oracle compatability project archive, which is found at http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux

• openmotif21-2.1.30-11.EL5.i386 (this must be this version exactly!)
• xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386
• binutils-2.17.50.0.6-6.0.1.i386

In checking whether you have all the required packages, you can query each package individually using:
rpm -q glibc
etc

or you could query all packages and put the output into a text file, and then view this file to search for each package:
rpm -qa >rpm_files.txt

view rpm_files.txt

For the files downloaded from Oracle, i placed then into a separate directory and them manually installed them using rpm:
rpm -Uvh libaio-0*

Software requirements

The following maintenance tools must also be installed and their locations specified in the PATH of the account that will run Rapid Install. Both times i’ve done this install these programs have (a) been installed, and (b) present in the path.

• ar
• gcc
• g++
• ld
• ksh
• make
• X Display Server

You can easily verify these by using the which command:
which make
>> /usr/bin/make

My final step to finish off the OS install itself was to run the automatic updater yum update as this applied a load of patches to take the OS to 5.3.

Onto the home straight now for the server config…

Kernel Settings

I then had to edit the file /etc/sysctl.conf to configure my kernel settings. The following table is taken from the metalink note i referred to earlier.

kernel settings for EBS R12 on Linux

DNS resolver parameters

Two Domain Name System (DNS) resolver parameters are set by default to low values when the OS is installed. These low values may cause attempted network connections to an Oracle database to fail. It is reccomended that these minimum settings are set in the /etc/resolv.conf file:
options attempts:5
options timeout:15

Verifying Host Names

I verified that the /etc/hosts file was formatted as follows:
127.0.0.1 localhost.localdomain localhost
<ip_address> <node_name>.<domain_name> <node_name>

I then had to verify that the /etc/sysconfig/network file was formatted as follows:
HOSTNAME=<node_name>.<domain_name>

If the /etc/sysconfig/networking/profiles/default/network file exists then delete it! No such file existed on my install so i skipped this step.

I then restarted my laptop (again).!

Other settings

I modified the /etc/security/limits.conf file to ensure the values for “hard” and “soft” open file descriptor limits were at least the minimum as given below:

* hard nofile 65536
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047

It states in the install notes (metalink) that if any of these values are already higher then not to lower them!

Oracle HTTP Server Patch

This step was originally missed out when i first tried this install. Shame on me, as it caused no end of troubles. It was only when i looked back at the metalink notes that i realised i’d missed it and it was rather important!

I needed to download and install the patch 6078836 from Oracle Metalink. It fixes an issue with the Oracle HTTP server that is bundled with EBS. Its only applicable to OEL5 or RHEL5, but as we’ve established, CentOS is a RHEL respin so needed to apply as well. For those wondering….I have a Metalink account so was able to do this. In fact i actually have 2 accounts; i have one linked to the site that i’m currently contracted to, and i also have a personal account linked to an OEL license pack that i purchased last year. Probably the best $100 my company has spent in ages

Once i’d studiously followed the patch install instructions, i then had to perform the following task; essentially this is a patch post-install step to link the Motif library for OAS 10.1.2 – this needed to be done as root:

unlink /usr/lib/libXtst.so.6
ln -s /usr/X116R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

And there you have it. End of part one. We have a configured server waiting for an install of EBS