Thursday, January 31, 2008

Steps Involved in Cloning R12 e-Business Suites Environment (Single Node)

Cloning is the process of creating an identical copy of an existing Oracle Application System. The new and existing systems must have component versions and platform type identical for cloning.

I am going to discuss the steps involved to Clone a Single Node system in R12 EBS.

Source Instance Name :
Target Instance Name :

Preparation to clone the Oracle Application System (Source).

1) sudo su - appl
<sid> user.

2) execute the Consolidated Applications enviornment file.


3) zip utility should be in your PATH.

$ PATH=$PATH:<Location of zip utlity installed on your system>
$ export PATH

4) Stop all Apps Tier Server processes.

$ cd $INST_TOP/admin/scripts
$ APPS/<passwd of APPS user>

5) Verify latest Rapid Clone patches on metalink and apply if required.(Not applicable)

6) On Apps Tier run AutoConfig and after that on Database Tier.

Apps Tier:

$ cd $INST_TOP/admin/scripts

DB Tier:

$ cd $ORACLE_HOME/appsutil/scripts/<context_name>

  • Pre-Clone Steps Starts from Here

  • 1. DB Tier preparation for Cloning :

    On Source System:

    a) login in as Oracle user : $ sudo su - oracle

    b) Run the following commands:


    $ cd $ORACLE_HOME/appsutil/scripts/<context_name>
    $ perl dbTier

    2. Verify the errors and warnings in the log.


    Location of the log file StageDBTier_

    Sunday, January 27, 2008

    Where is Administration Server Component in R12 EBS

    Pre-11i & 11i DBA's now say goodbye to Administration Server component.Administration Server in R12 is now a history or the right way to say "Obsolete".

    There no such component in R12 Architecture and by default any application tier node used to perform the below operations.

  • Apply DB patches to Apps: In Oracle application most of the time you will observe in most of the patches consists of files and scripts that update the file system and DB objects. To apply these patch (i.e, which includes cumulative and minipacks and maintenance packs patches). You use adpatch utility (also called AutoPatch utility) to perform any updates.

  • Maintain Apps:AD Administration Utility (adadmin) require maintenance to optimize system performance and enables you to perform other file system and database maintenance tasks.
  • Saturday, January 26, 2008

    R12 Java Servlet Access using HTML Applications

    In this post I am going discuss access path use by HTML interface module when using a JSP.

    a)User access a function on a browser (HTML hyperlink access)
    b)then the browser generate a URL request to the web server.
    c)Web listener talk to servlet engine (Jserv)then runs a JSP.
    d)JSP then contact Application tables to obtain contents and use metadata dictionary information to build a HTML page.
    e)The HTMP page which is build in previous step sent back to the browser with the help of web server.

    R12 Oracle Application Framework

    In this post I am going to discuss about R12 Oracle Applicaiton Framework Components and it processing.

    Oracle Application Framework is the development platform for HTML-based applications. It consist of a java-based application tier framework and associated services. It designed to facilitate the rapid deployment of HTML-based applications.

    Oracle Application Framework uses below components:


  • It provides the OAF with underlying security and applicaiton Java Services.Also OAF with its connection to the DB and with application-specific functionality for e.g attachments and flexfields.

  • BC4J

  • JDeveloper incluedes BC4J. Java Business components are created by BC4J for representing business logic. It seperates the business logic from UI by mapping the relational tables to java objects.

  • Java Controller

  • It processes the programmatic UI definition.

  • Metadata UI Definition

  • Apache Jserv module provides the Java servlet engine uses metadata dictionary to to construct the Framework UI.

  • HTML Generator UIX

  • UIX , the HTML Generator

    HTML-based applicaiton uses the following path with OAF on application Tiers. The steps are discussed below.

    a)User click a function on browser (HTML hyperlink access).
    b)URL request to the web listener sent by browser.
    c)User access validated by AOL/J.
    d)Page definition is loaded from the metadata dicitionary on the DB tier into the application Tier (i,e. Metadata UI definition)
    e)BC4J objects that contain the application logic and access the database are instantiated.
    f)Java controller programatically manipulates the page definition as necessary, based on dynamic UI rules.
    g)HTML UI Generatior (UIX)interprets the page definition. It creates the related HTML based on UI standards, and send the page to the browser.

    Sunday, January 13, 2008

    Step By Step Installation of VMWARE on WinXP Professional - Part I

    In this post I am going to discuss about Step by Step Installation of DB11gR1 Clusterware on OL4 Update 5 using VMWare (Virtual Servers) on WinXP. I tested this configuration on my laptop.

    Objective: This installation procedure for learning and testing purpose. This kind of configuration is not suitable for any Production and Test Environment.

    Hardware Requirements

    Lenovo Thinkpad Laptop
    Windows XP Professional 5.1.2600,Service Pack 2 (Host O/S)
    Intel(R) Core(TM)2 Duo CPU
    T7300 @2.00 GHZ
    200 GB HDD (Actual Installation required by one node is 35 GB + 10 GB to Stage Software required by you and for future use)
    2 GB RAM
    Note: As far as my experience with this installation you should have minimum 3GB RAM. I faced few issues like one node goes down and if you are running any memory intensive program. Better to have minimum 3 GB RAM. I used 800 MB for each node and rest for host operating system.
    Oracle Enterprise Linux 4 (Update 5) (Guest O/S)
    VMWare Server 1.0.4

    Software Requirements


    Follow the sequence to Install RAC11g+ASM on clusterware using OL4 update 5(On VMWare).

    • Step By Step Installation of VMWARE on WinXP Professional - Part I

    • Step by Step Installation of Oracle Enterprise 4 Update 5 using VMWare on WinXP Professional - Part 2

    • Step by Step Installation of Oracle Enterprise 4 Update 5 using VMWare on WinXP Professional - Part 3

    • Step by Step Installation of Clusterware11gR1 on Oracle Linux 4 Update 5 using VMWare on WinXP - Part 4

    • Step By Step Installation of ASM and Oracle DB11gR1 on Oracle Enterprise Linux 4 Update 5 using VMWare on WinXP - Part5

    Step By Step Installation of VMWARE on WinXP Professional - Part I - Start Here

    Start the installation by double clicking the VWWare software you downloaded from VMWare Site. There is free Trial product key is allocated for you to use this product. Screen Shots are Self Explantory to Install VMWare. Please Follow the snapshots. If you are not able to read the text inside the snapshot please click on snapshot and it will take you to picasa web album and you can see slide show to view more clearly.

    Step By Step Installation of VMWARE on WinXP Professional - Part I - End Here

    VMWare Virtual Machine Configuration- Start Here
    Configure the First Virtual Host - rglinux1
    Follow the self explantory snapshots to install your first Virtual host "rglinux1". You can give any name to your vitual machine

    To Start "VMWare Server Console" click on your VMWare shortcut on your desktop - Select the default option "Local Host"

    To Configure Virtual Machine Select "New Virtual Machine" under Virtual Machine Options

    The "New Virtual Machine Wizard" will start, Click Next

    Select "Custom" under Virtual Machine Configuration

    Select "Linux" under Guest Operating System and change the version to "RedHat Enterprise Linux 4"

    Name the Virtual Machine "rglinux1" under Virtual Machine Name. Enter the Location "C:\vms\rglinux1" (Single Node Configuration). To Configure Linux Cluster (Multi-Node Configuration) for RAC configuration. You can change the path as "C:\vms\RAC\ASM11g\rac1" and Machine Name for RAC Setup is ASM_11gRAC1

    Set Access Rights - Uncheck this option. The default is shown in snapshot

    startup/Shutdown Options - Select Default "User that powers on the virtual machine"

    Select "Number of Processor" depending on your machine - Default is one - I select as Two as per my machine configuration

    Memory for Virtual Machine - I configured initially with 824 MB. The best for RAC11g configuration is 3GB and you can allocate 1024 Machine for each Virtual Machine and rest for Host Operating system (WinXP

    Select Network Type as "Use Bridged Networking"

    Select I/O Adapter Types as "LSI Logic"

    Select a Disk as "Create a new Virtual Disk"

    Select a Disk Type as "SCSI"

    Specify Disk Capacity - Select the second option as split disk into 2GB disks. Uncheck the first option shown in snapshot - I just Enter 35GB to configure other products of oracle on same box. Ref 11g RAC docs for Disk Space Requirement

    Enter virtual disk filename (rglinux1.vmdk in snapshot). I changed for my RAC configuration to localdisk.vmdk.

    Creating a Disk - This is for Single Node Installation not for RAC Configuration on Linux Clusters. This step can be skipped if you are configuring Linux Cluster for RAC11g.

    View of First Virtual Machine name "rglinux1" or You can give name as ASM_11gRAC1 for linux cluster for RAC11g Configuration.

    VMWare Virtual Machine Configuration- End Here

    To Install Linux on Your First Virtual Machine. Please follow the post "Step by Step Installation of Oracle Enterprise 4 Update 5 using VMWare on WinXP Professional - Part 2"

    Step by Step Installation of Oracle Enterprise 4 Update 5 using VMWare on WinXP Professional - Part 2

    In my previous post we Configure the First Virtual Machine as rglinux1 or ASM_11gRAC1.In this post I am going to discuss further configuration of First Virtual Machine and then we will Install Linux on First Virtual Machine.

    For RAC11g Configuration First we need to Add the Shared Disks and an additional Network Card (to handle private network for interconnect). Select "Edit Virtual Machine from VMWare Server Console". A new pop-up windows of Virtual Machine Settings will come. Select Add to "Add New Hardware". Select "Ethernet Adpater" to configure private Interconnect (2nd NIC or Ethernet Card). Select "Next" to go for next screen of "Network Type" and Select option as "Host-Only:A private network shared with the host". Please verify that "connect at power on" should be selected.

    Again start the "New Hardware Wizard" to configure Disk for RAC11g Configuration.

    You need to configure based on below information provided for database file,OCR and Voting disk.

    Disk Table
  • Database files => 3Gb => SCSI 1:0 =>datadisk1.vmdk

  • Database files => 3Gb => SCSI 1:1 =>datadisk2.vmdk

  • Database files => 3Gb => SCSI 1:2 =>datadisk3.vmdk

  • OCR => 300Mb =>SCSI 1:3=>ocrdisk.vmdk

  • Voting Disk => 300Mb => SCSI 1:4=>votingdisk.vmdk

  • Select "Hard Disk" to add a new Hard Disk. Click on "Next" to go to next screen to select a Disk. Select "Create a new Virtual Disk" then Select Disk Type as "SCSI". Click on "Next" to go to next screen to allocate Disk Space mentioned above for Database files. Please select "Allocate all disk space now" option to configure these disks. On next screen Specify data file please give name of this disk as "datadisk1.vmdk" and browse the path to share directory under "C:\vms\RAC\ASM11g\share" to save this file. Once the Disk is create then select the same harddisk and click on Advanced configuration to change the virtual device node as mentioned above in "Disk Table". Change Virtual Device node from existing value to SCSI 1:0. and select "Indepedent" and "persistent" disk option. You can repeat this step for all other disk to configure disk for RAC11g configuration.

    When all disk are configured. Close the "Virtual Machine Settings" to confirm the changes to Virtual Machine configuration file.Now edit the virtual machine confiuration file (i.e, Red Hat Enterprise Linux 4) and the parameters where # sign is shown. Remove this # sign to use these parameters as part of you configuration file.
    Configuration File - Start Here
    config.version = "8"
    virtualHW.version = "4"
    numvcpus = "2"
    scsi0.present = "TRUE"
    scsi0.virtualDev = "lsilogic"
    memsize = "900"
    scsi0:0.present = "TRUE"
    scsi0:0.fileName = "localdisk.vmdk"
    ide1:0.present = "TRUE"
    ide1:0.fileName = "D:"
    ide1:0.deviceType = "cdrom-raw"
    floppy0.present = "FALSE"
    Ethernet0.present = "TRUE"
    displayName = "ASM_11gRAC1"
    guestOS = "rhel4"
    priority.grabbed = "normal"
    priority.ungrabbed = "normal"

    #disk.locking = "FALSE"
    #diskLib.dataCacheMaxSize = "0"
    #diskLib.dataCacheMaxReadAheadSize = "0"
    #diskLib.dataCacheMinReadAheadSize = "0"
    #diskLib.dataCachePageSize = "0"
    #scsi1.sharedBus = "virtual"

    scsi1.present = "TRUE"
    scsi1:0.present = "TRUE"
    scsi1:0.fileName = "C:\vms\ASM11g\share\datadisk1.vmdk"
    scsi1:0.mode = "independent-persistent"
    #scsi1:0.deviceType = "disk"

    scsi1:1.present = "TRUE"
    scsi1:1.fileName = "C:\vms\RAC\ASM11g\share\datadisk2.vmdk"
    scsi1:1.mode = "independent-persistent"
    #scsi1:1.deviceType = "disk"

    scsi1:2.present = "TRUE"
    scsi1:2.fileName = "C:\vms\RAC\ASM11g\share\datadisk3.vmdk"
    scsi1:2.mode = "independent-persistent"
    #scsi1:2.deviceType = "disk"

    scsi1:3.present = "TRUE"
    scsi1:3.fileName = "C:\vms\RAC\ASM11g\share\ocrdisk.vmdk"
    scsi1:3.mode = "independent-persistent"
    #scsi1:3.deviceType = "disk"

    scsi1:4.present = "TRUE"
    scsi1:4.fileName = "C:\vms\RAC\ASM11g\share\votingdisk.vmdk"
    scsi1:4.mode = "independent-persistent"
    #scsi1:4.deviceType = "disk"

    scsi1.virtualDev = "lsilogic"
    ide1:0.autodetect = "FALSE"
    Ethernet1.present = "TRUE"
    Ethernet1.connectionType = "hostonly"

    scsi0:0.redo = ""
    scsi1:0.redo = ""
    scsi1:1.redo = ""
    scsi1:2.redo = ""
    scsi1:3.redo = ""
    scsi1:4.redo = ""
    ethernet0.addressType = "generated"
    ethernet1.addressType = "generated"
    uuid.location = "56 4d f6 04 91 f9 39 2c-b9 3f 19 f1 c4 af 8a 39"
    uuid.bios = "56 4d f6 04 91 f9 39 2c-b9 3f 19 f1 c4 af 8a 39"
    ethernet0.generatedAddress = "00:0c:29:af:8a:39"
    ethernet0.generatedAddressOffset = "0"
    ethernet1.generatedAddress = "00:0c:29:af:8a:43"
    ethernet1.generatedAddressOffset = "10"

    ide1:0.startConnected = "TRUE"

    tools.syncTime = "TRUE"

    workingDir = "."

    Configuration File - End Here

    Linux Installation - Start Here

    "Edit The Virtual Machine Setting" under VMWare Server Controls

    Select The "CD-ROM" under Hardware Tab

    Change the Connection on right Pane of CD-ROM from Use Physical Drive to Use ISO Image. You can place you Linux ISO Image on your Hard Drive Or copy the ISO Image on CD-ROM. I Staged the Oracle Enterprise Linux on my Hard Drive C:\Software.

    Select the Second option "Use ISO Image" under Connection.

    Browse the First ISO Image of Oracle Enterprise Linux (disc1) under "Use ISO Image" and Click on "OK"

    Click on "Start this Virtual Machine and You will see Linux boot: Prompt. Press Enter to Continue with Linux Installation.

    Linux Driver Installation Screen

    Linux O/S is test CD on this step. Press Tab to Skip this test

    Probing for Video Card

    Click Next to Continue with Linux Installation

    Linux O/S Language Selection - By Default "English(English)"

    Select appropriate Keyboard for the System (U.S English). Click "Next" and a Warning Message will display. Press "Yes" to Continue.

    Keep Default selection on this page and Select "Next" to Continue with Linux Installation.