Tuesday, January 22, 2013

Installing EBS R12.1.3 using Oracle VM Template without VM Server & Manager (Part 1 of 4)

Let’s start with installing EBS R12.13 instance using Oracle VM Template. Using the guided steps any one will be able to have its own vision instance. The prerequisites will take most of your time (I would say 80-90%), otherwise the installation will take just an hour or so. This is divided into 5 sections.
  • Section 1 –  Hardware and Software Pre-requisites
  • Section 2 –  Downloading software and making it available to use
  • Section 3 –  Configuring Database Tier Template
  • Section 4 –  Configuring Application Tier Template
  • Section 5 –  Using Oracle Applications 12.1.3
Section 1 – Hardware and Software Pre-requisites

It’s a best to have two different machines to (one for database server and another for application server), but spending on two physical machines is very costly and just to practice and use oracle application I don’t think any once is willing to pay much. So I thought of using virtualization and used Virtual Box to install oracle application.

I have used my personal laptop to implement this guide and it works fine. My laptop runs on Windows 7, I used virtual machines inside my Host OS to install EBS 12.1.3 visions instance. We can use this guide even we have Host Operating System as Linux, just we need to install the Linux version of Virtual Box / VM Ware.

Hardware Requirement

Recommended configuration
Processor
Intel Dual Core / Core2Duo 2.5 Ghz
RAM
6 GB of RAM (we can live with 4 GB but that will be too tight fit)
HDD
500 GB of HDD (We need extra 300 GB of HDD to convert VM template image to Virtual Box readable format)
Network
Network adapter

Used configuration
Processor
Intel Core i5 2.5 Ghz
RAM
8 GB
HDD
500 GB internal HDD + 500 GB external HDD
Network
Network adapter

Software Requirement
Virtualization
Oracle Virtual Box / VM Ware Player
Operating System
Oracle Enterprise Linux Release5 Update6
EBS Software
R12.13 OVM Template
Other Software
CygWin, Unzip Utility

Section 2 – Downloading software and making it available to use

§ Downloading Software

Download the Oracle virtual machine template form Oracle Software delivery could (https://edelivery.oracle.com/linux). Make sure to select ‘Oracle Linux/VM’ from Cloud Portal LOV on the right hand side.

Login to Oracle software delivery cloud Delivery portal using your credentials and search for ‘Oracle VM Template’, select your platform. I opted for 64 bit as to extract maximum performance out of my hardware.

a – OVM Templates

From the list select Oracle VM Templates for Oracle E-Business Suite Release 12.1.3 Vision Media Pack for x86 (64 bit) and download all the 11 files under it (V25323-01 to V25330-01 for database server and V25331-01 - V25333-01 for application server).

b – Oracle Linux Release5 Update6

Also down Oracle Oracle Linux Release 5 Update 6 Media Pack for x86_64 (64 bit) ISO disk from oracle software cloud. We need this to first boot the virtual machine and configure the operating system provided by oracle in template. We could have done with later releases but I don’t want to take a chance as OVM templates are built on Oracle Linux Release 5 Update 6.
c – CygWin

Download and install Cygwin from internet (http://cygwin.com/install.html)

§  Extracting Template files

Unzip OVM Templates - Unzip all the 11 files we download. We can use any window tool like winzip / winrar to perform this activity or we can down load CygWin to create unix like environment under Windows and use unzip command to unzip the files. I have used CygWin to perform the extraction.

Upon completion we will get two set of files (one for db template and one for apps template) like this –

OVM_OL5U6_X86_64_EBIZ12.1.3_DB_VIS_PVM.tgz.0-7 (8 Files – Database tier)
OVM_OL5U6_X86_64_EBIZ12.1.3_APPS_VIS_PVM.tgz.0-2 (3 Files – Application tier template)

Concatenate and decompress OVM Template files– Once done the unzip we need to concatenate the files which are in .tgz format along with decompressing it. Oracle splitted entire DB and APPS image into smaller chunks and compressed it. I browsed to the directory where files were place or you can provide the path as well.

[root@ultimatix]# cat OVM_EL5U3_X86_64_EBIZ12.1.3_APPS_VIS_PVM.tgz.0 \
OVM_EL5U3_X86_64_EBIZ12.1.3_APPS_VIS_PVM.tgz.1 \
OVM_EL5U3_X86_64_EBIZ12.1.3_APPS_VIS_PVM.tgz.2 | tar –xz
[root@ultimatix]# cat OVM_EL5U3_X86_64_EBIZ12.1.3_DB_VIS_PVM.tgz.0 \
OVM_EL5U3_X86_64_EBIZ12.1.3_DB_VIS_PVM.tgz.1 \
OVM_EL5U3_X86_64_EBIZ12.1.3_DB_VIS_PVM.tgz.2 \
OVM_EL5U3_X86_64_EBIZ12.1.3_DB_VIS_PVM.tgz.3 \
OVM_EL5U3_X86_64_EBIZ12.1.3_DB_VIS_PVM.tgz.4 \
OVM_EL5U3_X86_64_EBIZ12.1.3_DB_VIS_PVM.tgz.5 \
OVM_EL5U3_X86_64_EBIZ12.1.3_DB_VIS_PVM.tgz.6 \
OVM_EL5U3_X86_64_EBIZ12.1.3_DB_VIS_PVM.tgz.7 | tar -xz
This will create 2 directories-
OVM_EL5U3_X86_64_EBIZ12.1.1_DB_VIS_PVM’ (2 Image files, 1 config file and 1 readme file)
OVM_EL5U3_X86_64_EBIZ12.1.1_APPS_VIS_PVM’ (2 Image files, 1 config file and 1 readme file)

Convert the disk to Virtual Machine readable format – To use the .img files that we got after concatenating and decompressing we need to convert them into some readable format that can be read by Virtual machines. The native file format of Virtual Box is ‘.vdi’ but I opted to convert the files into .vmdk (VM Ware native format) since Virtual Box supports .vmdk files and if I wish I can use it in VM Ware as well.

Before proceeding with guide please follow the below link to understand how to download and install Oracle Virtual Box


Virtual Box provides a utility called ‘VBoxManage’ that will be used to convert the file format. We can find the utility inside the installation folder where Virtual Box is installed. To make use of it either we can browse inside the directory or we can add the path into environment variables. To do this goto -> System Properties
Click on Environment Variables to update the path:
Select the Path and click on Edit…
Add the directory path of Virtual Box installation where VBOXManage.exe is located
Now covert the .img files to .vmdk files. While converting I have changed the names of the files so that I can easily identify it.

Apps Server Files
=================
VBoxManage.exe convertfromraw g:\OracleVM\Apps-VM\ebs1211apps.img d:\OracleVM\Apps-VM\EBIZ12.1.3_APPS_VIS\ebs1213apps.vmdk

VBoxManage.exe convertfromraw g:\OracleVM\Apps-VM\System.img d:\OracleVM\Apps-VM\EBIZ12.1.3_APPS_VIS\ebs1213appsroot.vmdk

DB Server Files
===============
VBoxManage.exe convertfromraw g:\OracleVM\DB-VM\ebs1211db.img d:\OracleVM\DB-VM\EBIZ12.1.3_DB_VIS\ebs1213db.vmdk

VBoxManage.exe convertfromraw g:\OracleVM\DB-VM\System.img d:\OracleVM\DB-VM\EBIZ12.1.3_DB_VIS\ebs1213dbroot.vmdk
*** Above steps are performed on Windows system, you can find equivalent command for other Operating System if your HOST Operating System is different.
Please follow the below link to understand how to Create Virtual Machine in Virtual Box

Configuration for Virtual Machines
Database Server
Application Server
Processor/CPU
1
Processor/CPU
1
RAM
3 GB
RAM
1.5 GB
Operating System
Oracle Linux 64bit
Operating System
Oracle Linux 64bit
Boot Order
CD-ROM, Hard Disk
Boot Order
CD-ROM, Hard Disk
Storage
Oracle Linux R5U6 ISO, IDE Controller to attached two .vmdk files
Storage
Oracle Linux R5U6 ISO, IDE Controller to attached two .vmdk files
Network
1-Host-Only Adapter, 1-NAT Adapter
Network
1-Host-Only Adapter, 1-NAT Adapter

Data Base Server & Application Server Virtual Machine Final Configuration

Once we done with creating pre-requisites and virtual machine creation now we will move to next section.

Next -: Section 3 –  Configuring Database Tier Template

21 comments :

  1. Does the EBS 12.1.3 in VM contains PIM?

    ReplyDelete
    Replies
    1. Hi Paritosh,

      Sorry, I am not sure about PIM if its in there or not.

      Delete
    2. Dear Tauseef, can you remotely help me installing R12 VM.

      Best Regards,
      Hussam
      hymurad@yahoo.co.uk

      Delete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. Dear Tauseef, can you remotely help me installing R12 VM.

    Best Regards,
    Hussam
    hymurad@yahoo.co.uk

    ReplyDelete
    Replies
    1. Hello Hussam,

      I will try to help you with installation. Please follow the blog and let me know what issue you are facing. Advise is to first go thru the steps from start to end and then start installation.

      Delete
  4. Hi Tauseef,

    Currently oracle e delivery has been removed 12.1.3 vmware template which you have shown screenshot in your blog,can you please cross check the oracle e delivery website and update the same in your blog.

    ReplyDelete
  5. Hello,

    I just checked on edelivery.oralce.com and I see its still there.

    Oracle VM Virtual Appliances for Oracle E-Business Suite (12.1.3) Media Pack for x86 64 bit 12.1.3.0.0 B78931-01 AUG-14-2014 32 /110G

    Regards
    Tauseef

    ReplyDelete
    Replies
    1. Thanks for your reply,Please let me know the list of files from the above 110G.Do you want me to download all the single node files(14 files).

      Delete
  6. Hello... You should be looking for following files.

    V46557-01 Part 1 of 2 3.9G
    V46557-01 Part 2 of 2 3.9G
    V46558-01 Part 1 of 2 3.7G
    V46558-01 Part 2 of 2 3.7G
    V46559-01 Part 1 of 2 3.8G
    V46559-01 Part 2 of 2 3.9G
    V46560-01 Part 1 of 2 3.8G
    V46560-01 Part 2 of 2 3.8G
    V46561-01 Part 1 of 2 3.8G
    V46561-01 Part 2 of 2 3.7G
    V46563-01 Part 1 of 2 4.0G
    V46563-01 Part 2 of 2 3.1G
    V46562-01 Part 1 of 2 3.7G
    V46562-01 Part 2 of 2 4.0G

    Regards
    Tauseef

    ReplyDelete
  7. I will download above mentioned files..will try to follow your methods...

    ReplyDelete
    Replies
    1. Hello Sai,

      This is little different and fairly simpler. Now you have file "E-Business-Suite-12.2.3-VISION-INSTALL.ova" with you.

      Open VM Virtual Box, Goto File -> Import Appliances and browse the above file.

      This will import the and create virtual machine. Now before doing that make sure your VM preferences are correct and correct virtual directory is set which has enough space to extract the files.. Roughly its 300 GB.

      Regards
      Tauseef

      Delete
  8. Thanks for your quick reply,will you please tell me the VM Preferences and directory settings for this installation.

    Regards,
    Sai

    ReplyDelete
  9. Hi,

    Goto File -> Preferences and choose a folder in Default Machine folder section. Make sure you do not have any space in directory path have 300 GB space.

    Regards
    Tauseef

    ReplyDelete
  10. Hi,

    Thanks for your reply,till now i performed the below activities.

    1)Downloaded the below files from e delivery.
    Enterprise-R5-U6-Server-x86_64-dvd.iso
    Enterprise-R5-U6-Server-src-dvd.iso
    the 14 files 12.1.3 vm template appliances.
    2)concatenated 14 files.
    3)Installed vmware latest version.
    4)Imported applicances concatenated single file.
    5)I didnot installed linux till now.
    Can you please let me know the full process.my email id.
    psaisap@gmail.com.

    Regards,
    Sai

    ReplyDelete
  11. Hi,

    Can you please let me know the full and clear process steps for this activity.

    Regards,
    Sai

    ReplyDelete
  12. Hi Tauseef,

    Please post new installation process as per vm ware template appliances.Since edelivery is providing appliances and It will be use full for all.

    Regards,
    Sai,

    ReplyDelete
    Replies
    1. Hi Sai,

      You can follow the below post which talks about installing single node installation. Only thing is that is 12.2.4. You can follow the same steps...

      http://www.oracleappsnfusion.com/2014/12/installing-e-business-12.2.4.html

      Hope that helps.

      Tauseef

      Delete
  13. Hi Tauseef,

    I followed the steps of 12.2.4 for12.1.3,i imported appliances without any issue.but after importing,it has generated 255gb single file and i configures dbconfig and apps config,added host details in windows->system32->drivers->etc->host file.but Iam unable to open the login page.will you please let me know what is the next step.I followed your tutorial but it is not working for 12.1.3.

    Thanks

    ReplyDelete
    Replies
    1. Hi,

      There could be multiple issue.. may be the services didn't start properly, network issue i.e guest network is not accessible or windows firewall is restricting it.

      - What is the guest network type in the virtual machine config?
      - What is the network config on guest for IP.. Static / Dynamic?
      - If dynamic there is possibility it assigned different IP address which is not same as what is assigned in host.
      - You can also try skipping it from firewall.

      Regards
      Tauseef

      Delete
  14. both network type is static

    Thanks,
    Sai

    ReplyDelete

SeachBox