Oracle Apps Notes

A collection of my random notes, primarily on Oracle Apps

Category Archives: VirtualBox

Installing Oracle 11gR2 on RHEL 5(running on Oracle VirtualBox)

Finally completed installing Oracle database 11gR2(11.2.0.1.0) on a VirtualBox virtual machine running RHEL 5 after having postponed it for a number of times. I followed this document by Zahid Karim but there were some minor differences since his was a RHEL 5.5 system while mine is RHEL 5. Below are some notes regarding my installation process:

1. The RHEL 5 virtual machine was created with 20GB storage and 1.5GB memory

2. The allocations for the swap space and various partitions:

swap – 2250 MB
/tmp – 2048 MB
/boot – 100 MB
/root – 7168 MB
/u01 – 7168 MB

The minimum recommended space required in /tmp is 1GB. But note that the installer will check for 1GB available space in /tmp only after it is invoked, by which time the OS and the installer itself has used more than 300MB of space in that partition. This factor should be taken into consideration while creating the partition.

3. Pre-requisite packages elfutils-libelf-devel-0.125-3.el5.i386.rpm and elfutils-libelf-devel-static-0.125-3.el5.i386.rpm are dependent on each other and hence have to be installed together


[root@db11gr2 Server]# rpm -Uvih elfutils-libelf-devel-0.125-3.el5.i386.rpm elfutils-libelf-devel-static-0.125-3.el5.i386.rpm
warning: elfutils-libelf-devel-0.125-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
[root@db11gr2 Server]#

4. The version of the sysstat package in RHEL 5 is of a lower version. Had to download and install the minimum required version, sysstat-7.0.2-1.el5.i386.rpm.

5. Other packages whose higher versions has to be installed are:

glibc-headers-2.5-24.i386.rpmglibc-devel-2.5-24.i386.rpmglibc-common-2.5-24.i386.rpmglibc-2.5-24.i386.rpm. These are dependent on each other and had to be installed in the same way as the elfutils* packages in step#3.

PS: The 10g client works fine with a 11g server.

Oracle E-Business Suite 11i on Oracle VirtualBox

Sometime ago I had to recover my Windows 7 laptop and had to format it along the way. Not much of a problem that except that I had this Oracle E-Business Suite(EBS) 11i instance running on VMware and I forgot to back up the virtual machine. Thankfully it was a Vision instance and I had not done much on it, hence the loss was negligible. I had been planning to re-install EBS 11i since then but never managed to find the time until today. In the meantime I have been trying out Oracle VirtualBox on both Windows 7(64-bit) and Windows XP hosts and found it to be much better than VMware for most of my purposes. As of now, I have

  • Ubuntu, Debian, Fedora, Chrome OS and RHEL 4(with a Oracle 10g database installed on it) guests running on the Windows XP host
  • RHEL 4.5(with Oracle EBS 11i installed on it) guest running on the Windows 7(64-bit) host

OK, enough rambling already. I had an earlier installation of a RHEL 4 update 5 guest on the Windows 7(64-bit) system using Oracle VirtualBox(4.0.2). This document seemed to be quite perfect for the Oracle EBS 11i installation today. After applying all the the required patches and creating the users and groups, I saw that version 4.0.8 of VirtualBox was available. Upgrading from 4.0.2 to 4.0.8 was easy, just download the installer from http://www.virtualbox.org/wiki/Downloads and run it. It will upgrade the existing version.

The laptop I am using has 3GB of RAM(pathetic isn’t it) . I decided to allocate exactly half of the available memory for the virtual machine(VM). Having used more than half the system memory for one of my VMs earlier and having seen the way in which VirtualBox Manager hung during the installation, I knew better. I allocated around 120GB of dynamic storage for the VM since I would not be using a staging area for the EBS installation. Note that dynamic storage here indicates that the storage space can only increase. For instance, if I allocate 120GB to my VM and it uses 10GB initially, then only 10GB of space will be used up in the actual hard drive. When the VM swells up to 120GB then the actual hard drive will also show a usage of 120GB. However, if at a later stage I delete files from the VM so that it decreases in size to 50GB, the hard drive will still show that 120GB of space has been taken up in the hard drive. Also note that RHEL4 guests require IDE controller in order to work properly. Check here for supported VirtualBox guests.

The rest of the installation follows the document mentioned earlier. Instead of creating a staging directory, I installed from the ISO images to save around 24GB of space in the VM. There was this issue while using ISO images though.

VirtualBox could not unmount the previous ISO image each time I tried to use a new one, I had to select the force option. Using the CD/DVD drive from the host also leads to the same problem.

With the installation done, I needed to make sure that I could access Oracle EBS from the Windows 7(64-bit) host. This should be very easy if you use the ‘Host Only Adapter’ option for networking. But since I has not patched up my system to the required level, I had to tweak Internet Explorer 8 so that I could open Oracle EBS 11i Forms without the browser crashing each time. Following are the list of changes I had to make:

  1. Disabled each and every add-on
  2. Added the Oracle EBS URL to the list of Trusted Sites
  3. Ran Internet Explorer as administrator
  4. Unchecked the ‘Enable memory protection to help mitigate online attacks’ option in Internet Explorer.

Update: Using JInitiator 1.3.1.26 seems to be offer a more glitch-free experience 🙂