Sunday, December 12, 2010

Ready for installation of EBS R12.1.1

After the Guest Additions were enabled and the shared disk mounted succesfully I repeated the work I had done a couple of months ago:

First REBOOT (Log Out / Login as ROOT)
Now you can also copy and paste from Windows 7 to Linux

==== Required packages
Installed the remaining installed packages downloaded from http://oss.oracle.com:
- openmotif21-2.1.30-11.EL5.i386.rpm
- xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

==== Kernel Settings
Added the following lines to /etc/sysctl.conf:
# lines added to /etc/sysctl.conf for installation of EBS R12
kernel.sem = 256 32000 100 142
kernel.shmmni = 4096
kernel.msgmni = 2878
kernel.shmmax = 2147483648
fs.file-max = 131072
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

Notes:
- kernel.shmmax is already in /etc/sysctl.conf but with a value way to high. I commented that line out and added a new entry as you can see above. The new value
is the minimum value value for this parameter, but already more than physical memory assigned to VirtualBox.
- kernel.shmall = 4294967296 (not edited; 2097152 in [ID 761566.1])
- kernel.msgmax = 65535 (not edited; 8192 in [ID 761566.1])
- kernel.msgmnb = 65535 (not edited; same as in [ID 761566.1])

==== Domain Name System (DNS) Resolver Parameters
Added the following lines to /etc/resolv.conf
options attempts:5
options timeout:15

==== Verifying Host Names
/etc/hosts file is Ok
/etc/sysconfig/network file is Ok
No file /etc/sysconfig/networking/profiles/default/network (is Ok)

==== Modifying the Number of Open File Descriptors
Added the following lines to /etc/security/limits.conf
# Added for installation of EBS R12
* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047

=== REBOOT
System > Logout ROOT
Login as ROOT again

=== OS Library Patch for Oracle HTTP Server
Tried to do it, but this patch is at My Oracle Support only available for Linux x86.
Moreover it s replacing the file /usr/lib/libdb.so.2 which doesn't exist at my system

=== Link to Motif library in Oracle Application Server 10.1.2 (on Oracle Linux 5 and RHEL 5 only)
unlink /usr/lib/libXtst.so.6
ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

=== OPMN port conflict
check use of port 6000: netstat -a | grep 6000
Not used -> no potential conflict = OK

=== Ready for installation of EBS R12.1.1
I made a snapshot in VirtualBox of this moment! You should do it too.

Last weekend I spent a lot of time on recreating a virtual disk. Last week I was already almost at this point, but than I entered the command 'shutdown -r now' and I lost everything! I wanted to start all over again (yes again) and tried to create a new virtual machine with a new virtual disk. But creating a new virtual disk would take me 16 hours and at a next try more than a whole day. Finally I created a dynamic virtual disk instead of a static disk of 300 Gb. See where this ends up.

Wednesday, December 8, 2010

At metalink (oracle support) I found a document "Linux OS Installation with Reduced Set of Packages for Running Oracle Database Server" [ID 728346.1]. In this document it stated that no additional tasks should be included when installing Enterprise Linux. So, this time I also didn't check 'Software Development' (besides Web Server, Clustering and Storage Clustering).

Now, At a next step, when trying to install the VirtualBox Guest Additions I got the message "Building the VirtualBox Guest Additions kernel modules [FAILED]". The content of /var/log/vboxadd-install.log:
Makefile:23: *** Error: unable to find the sources of your current Linux kernel.
Specify KERN_DIR= and run Make again..


As a result, I was not able to mount a shared drive. So I had to solve this first. I installed all packages from the Oracle Linux 5 distribution media mentioned in the document "Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64" [ID 761566.1]:

cd /media/Enterprise Linux dvd 20100405/Server
rpm -i --nodeps --replacefiles xxx where xxx stands for

gcc-4.1.2-48.el5.x86_64.rpm
gcc-c++-4.1.2-48.el5.x86_64.rpm
glibc-2.5-49.i686.rpm 1)
glibc-2.5-49.x86_64.rpm 1)
glibc-common-2.5-49.x86_64.rpm 1)
glibc-devel-2.5-49.i386.rpm
glibc-devel-2.5-49.x86_64.rpm
libgcc-4.1.2-48.el5.i386.rpm 1)
libgcc-4.1.2-48.el5.x86_64.rpm 1)
libstdc++-devel-4.1.2-48.el5.i386.rpm
libstdc++-devel-4.1.2-48.el5.x86_64.rpm
libstdc++-4.1.2-48.el5.i386.rpm 1)
libstdc++-4.1.2-48.el5.x86_64.rpm 1)
make-3.81-3.el5.x86_64.rpm 1)
gdbm-1.8.0-26.2.1.i386.rpm
gdbm-1.8.0-26.2.1.x86_64.rpm 1)
libXp-1.0.0-8.1.el5.i386.rpm
libXp-1.0.0-8.1.el5.x86_64.rpm
libaio-0.3.106-5.i386.rpm 1)
libaio-0.3.106-5.x86_64.rpm 1)
libgomp-4.4.0-6.el5.x86_64.rpm
sysstat-7.0.2-3.el5.x86_64.rpm
util-linux-2.13-0.52.el5_4.1.x86_64.rpm 1)
compat-libstdc++-296-2.96-138.i386.rpm 1)
compat-libstdc++-33-3.2.3-61.i386.rpm 1)
compat-libstdc++-33-3.2.3-61.x86_64.rpm 1)
elfutils-libelf-devel-0.137-3.el5.x86_64.rpm
elfutils-libelf-devel-static-0.137-3.el5.x86_64.rpm
libaio-devel-0.3.106-5.x86_64.rpm
unixODBC-2.2.11-7.1.i386.rpm
unixODBC-devel-2.2.11-7.1.i386.rpm
unixODBC-2.2.11-7.1.x86_64.rpm
unixODBC-devel-2.2.11-7.1.x86_64.rpm
kernel-headers-2.6.18-194.el5.x86_64.rpm

1): were allready installed (message).

After installing all those packages I still got the same error message. Surfing on the internet I found out that I had to install the kernel-devel-2.6.18-194.el5.x86_64.rpm (not mentioned in [ID 761566.1]). After installation of that package, I managed to install the VirtualBox Guest Additions.

Also see my page "Installation of Oracle Enterprise Linux 5.5 in VirtualBox". I added it some weeks ago, but as I am still preparing the Oracle Linux environment for installation of EBS R12.2, the document is still under construction.

Wednesday, November 17, 2010

Started all over again

It's been a while since I've been working on this personal project. Last weekend I picked up again. I have downloaded the latest version of Oracle's Virtual Box (version 3.2.10) and again installed Oracle Enterprise Linux 5.5 as guest OS. This time, the simplest way possible. Soon I will add pages with screenshots, including installing the Guest Additions in Oracle's Virtual Box, necessary to share a disk with the host OS (Windows 7).

Now I have to apply some patches to Linux before I can install EBS R12.1.1. Half a year ago, I already downloaded the sources of EBS R12.1.1 from E-Delivery (about 70 Gb). Downloading them again would take some time, so I compared the MD5 hash of each file with the value printed on E-Delivery (under the button 'Digest'). For this I used MD5sums for Windows. From only two files I had to download a newer version. That was easy.

To be continued soon ....

Sunday, June 13, 2010

Added a new page to my blog

Writing a blog is also new to me. Today I managed to add a page with some screen captures to my blog. It is about Installation of Oracle VM VirtualBox. It is not that complex after all, but it can be enlightening for people that are new to Oracle VM VirtualBox. I also want to make a page like that for creating a VM VirtualBox Machine with Oracle Enterprise Linux and another for preparing OEL 5.5 for installation of EBS R12.

I noticed the transation of Sun VirtualBox to Oracle VM VirtualBox, or is it just me that notices this only now?

Continuing perparing OEL5.5 for EBS R12 installation

I still did not finish preparing Oracle Enterprise Linux 5.5 for installation of EBS R12. Two weeks ago I made some progress but had no time to blog it. Here a short notice from my activities while continuing 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]':

==== > JavaSE (JDK) 6
I spent quite some time on downloading and installing JDK 6 for OEL 5.5, but at the end collegea Arnoud Roth told me that this was not necessary. This will be installed when installing EBS!

==== Patching Oracle Applications
Here the manual was very confusing. It stated 'Note: When querying for Oracle Applications Release 12 patches on My Oracle Support and selecting Linux x86-64 in the Platform dropdown list, it will re-direct you to a Linux x86 patch. This patch may be applied to both 32-bit and 64-bit Linux operating systems.' I looked at Oracle Support for a patch but could not find one.
Finally I posted a message in the E-Business Suite forum 'Technology - LCM: R12 Install/Upgrade'. Helios answered this this is just a note that when a patch is needed I have to think about the version and I don't need to care about this NOTE for my installation. Thanks Helios.

==== Kernel Settings
Added the following lines to /etc/sysctl.conf
# lines added to /etc/sysctl.conf for installation of EBS R12
kernel.sem = 256 32000 100 142
kernel.shmmni = 4096
kernel.msgmni = 2878
fs.file-max = 131072
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

==== Domain Name System (DNS) Resolver Parameters
Added the following lines to /etc/resolv.conf
options attempts:5
options timeout:15

==== Verifying Host Names
/etc/hosts file is Ok
/etc/sysconfig/network file is Ok
No file /etc/sysconfig/networking/profiles/default/network (is Ok)

==== Modifying the Number of Open File Descriptors
Added the following lines to /etc/security/limits.conf
# Added for installation of EBS R12
* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047

REBOOT!

==== OS Library Patch for Oracle HTTP Server
Looking for patch 6078836
On My support look for Platform is Linux x86 (you won’t find it using platform Linux x86-64)

Download patch. Unzip the file.
cp libdb.so.2 /usr/lib

==== Link to Motif library in Oracle Application Server 10.1.2

TO DO

Monday, May 24, 2010

Setting up the environment

I Installed the newest version from Sun VirtualBox 3.2.0 for Windows hosts (http://www.virtualbox.org/). I created a virtual environment:
- OS type: Red Hat (64 bit)
- Base memory: 1999 MB
- Processors: 1
- Storage: Fixed, 300GB

Inside this virtual environment I installed Oracle Enterprise Linux Release 5 Update 5. I downloaded from http://edelivery.oracle.com/linux the x86 64 bit version. Choose the 'Enterprise Linux Release 5 Update 5 for x86_64 (64 Bit) - DVD' (V20665-01). That is a 3.3G iso-file that can be used when starting up the virtual environment. It was pretty much pressing next, next, next, ... but I installed some extra's I thought of it would be necessary / usefull, but I have no evidence if that is really the case. My extra's:
- Sets of software: Software Development and Web Server (KE, Java Development, DNS Name Server, FTP Server, Mail Server, Windows File server
- Firewall: FTP, Mail (SMTP), SSH, Samba
- Created a user oracle/oracle

It took me a lot of time to instal the Guest Additions in the VirtualBox. This was necessary because I had already downloaded 51.3 GB from http://edelivery.oracle.com for installing EBS R12 (Oracle E-Business Suite Release 12.?.? Media Pack v? for Linux x86-64-bit). It was on 26 february 2010. So I don't know the exact version it is. I don't think it will be 12.1.1, but I will see.
Without the Guest Additions it is not possible to share folders! The trick was to enable the VBoxGuestAddtions.iso at the CD/DVD devices. Afer that I was able to install the VBoxLinuxAdditions-amd64.run. To share a folder you heave to set this up in the VirtualBox: Devices > Shared Folders... Add a shared folder and 'Make Permanent'. In Linux create a folder (e.g. /tmp/share) and mount the share to it: mount -t vboxsf Share /tmp/share (Share is the name of the Share folder). I made screenprints. I will post them later.

After OEL 5.5 was installed I downloaded from support.oracle.com the latest Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]. So now Iam preparring the environment for installation of Oracle EBS. Until now I added two additional packages (downloaded from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/):
rpm --install --replacefiles --nodeps openmotif21-2.1.30-11.EL5.i386.rpm
rpm --install --replacefiles --nodeps xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i38.rpm

To be continued

Thursday, May 13, 2010

BEGIN

Welcome to my blog. This is my first post. I want to start with installing EBS R12 in a Sun VirtualBox with Oracle Enterprise Linux as guest OS. First I have to find out what are suitable parameters for memory size and disk size. My Lenovo T61 laptop is running 64 bits Windows 7 with 4 GB of internal memory and I want to use a 1 TB external disk (Western Digital My Book).