Oracle Apps Notes

A collection of my random notes, primarily on Oracle Apps

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 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: