Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database
  • Upgarde DB to
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management

  • We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle BPEL Process Manager Overview
    Tuesday, July 24, 2007
    Register for R12 upgrade

    Oracle BPEL Process Manager is component of SOA Suite in Fusion Middleware Family . You can also install standalone BPEL Process Manager with Oracle Application Server (J2EE and Web Type) and its own dehydration store (repository for status data) or can install it with Oracle SOA Suite.

    This post covers broad overview of BPEL Process Manager component and Installation overview.

    BPEL Process Manager Consist of

    - BPEL Server : Server on which you deploy BPEL Process (workflow, technology adapter,
    notification services)
    - BPEL Control : Console from which you deploy, manage and test BPEL process.
    - Database : Also alled as Dehydration store is database to store process status data

    Installation Option of BPEL Process Manager
    Oracle BPEL Process Manager can be installed with
    i) Oracle SOA Suite or
    ii) Oracle AS Middle Tier

    Installing BPEL on Oracle AS Middle Tier
    Pre checks
    -Minimum version of Application Server middle tier is
    -Database (Dehydration Store for BPEL process manager) can be 9i or 10g Oracle Database
    ( or higher, or higher, or higher or XE )
    -Before installing Oracle BPEL manager configure database by running IRCA (Integration
    Repository Creation Assistant

    Install Steps
    i) Install Database for Dehydration Store (You can use already existing database if match
    version prereq.)
    ii) Create BPEL Process manager schema and user using ($installation_software/ install/ soa_schemas /irca)
    iii) Install OAS (J2EE only or J2EE and Web SErver installation type)
    iv) Install BPEL process manager in same oracle home as yu installed J2EE and J2EE Web Server by running ($Installation_Disk/bpel_oc4j/./runInstaller )

    How to monitor BPEL Process Manager and Integration with Applications, coming soon .....

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 8:17 PM   3 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle RAC Part IV : Install Oracle Clusterware and Cluster Database
    Sunday, July 22, 2007
    Register for R12 upgrade
    This is fourth and last post for installing Oracle RAC Database on single machine using VMWare virtual machines. For previous posts visit

    Are you scared of Oracle RAC Database
    Install Oracle RAC Database I
    Install Oracle RAC Database Part II
    Install Oracle RAC Database Part III

    In this part we will install oracle clusterware and rac database

    Copy Oracle RAC and Oracle Database Software to RAC1

    Create a directory software in $HOME and copy clusterware and database zip files downloaded


    This will create directory clusterware (for clusterware software) and database (for database software)

    Verify all prereq. for clusterware installation

    cd /home/oracle/softwar/clusterware/cluvfy

    Make sure
    --Second Machine/Node RAC2 is up
    -- You have configured and changes hostname and network IP of RAC2
    -- RAC1 can ping RAC2 and vice versa
    -- User equivalency is set for user oracle on RAC1 and RAC2
    -- You can connect to rac2 from rac1 as user oracle without prompting password and vice versa

    ./ stage –pre crsinst –n rac1,rac2

    Make sure Node reachable and User Equivalency is met, rest other checks (related memory) can be ignored

    Once RAC1 and RAC2 can ping each other and oracle user can connect to other machine's oracle user without prompting password then start clusterware installation from user oracle.

    Change directory to location where you have unzipped clusterware software and start clusterware installation by running runInstaller


    Ignore memory related prereq.

    Add second node rac2 by clicking on Add link

    Change subnet as per your network configuration as you did while configuring network card.

    Make one public and another private (Private interconnect for clusterware)

    Specify ocr location like /apps/oracle/oradata/ocr (or as per your naming convention)

    Specify voting disk location like /apps/oracle/oradata/votingdisk (or as per your naming convention)

    Click on Install to install clusterware.
    After clusterware installation, Install Database

    Install RAC Database
    Go to location where you unzipped database disks
    ./runInstallerignoreSysPrereqs (this is required as our memory is less (below 900MB) required, if your machine spec is higher you can ignore using ignoreSysPrereqs)

    Specify database oracle_home (make this different from clusterware oracle_home installed in previous step)

    Enter database name of your choice

    Select ASM

    Ignore any warnings and click on OK

    Define location of ASM as /dev/raw/raw3 and make redundancy as external

    Click on Install
    Why number of voting disks should always be odd number only ?
    How to troubleshoot RAC database and clusterware issue ?
    .. Coming in future posts

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 9:33 PM   31 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Orcale RAC Part III - Clone RAC1 to RAC2 and User Equivalency
    Sunday, July 15, 2007
    Register for R12 upgrade
    This is fourth post on step by step building Oracle RAC Database on your desktop / laptop using VMWare (Virtual Machine)

    For previous three posts visit

    Try installing Orcale RAC on your laptop
    RAC Part I - Install Virtual Machine and Linux
    RAC Part II - Install Virtual Disk and Network Card

    In this post you will

    --Clone RAC1 to RAC2 and change IP address of RAc2
    --Configure User equivalency for Orale Clusterware installation

    Clone RAC1 to RAC2

    - Make sure virtual linux machine is shutdown
    -Copy folder rac1 to folder rac2 in c:\Atul\VMWARE (This is on windows laptop/machine)

    --In both RAC1 and RAC2 folder open “Red Hat Enterprise Linux 3.vmx” (This is virtual machine configuration file) using notepad or wordpad

    --Add following lines (This will avoid locking for shared files and two linux machines RAC1 and RAC2 can start together using shared files votingdisk, crs and asm)

    disk.locking = "FALSE"
    diskLib.dataCacheMaxSize = "0"
    diskLib.dataCacheMaxReadAheadSize = "0"
    diskLib.dataCacheMinReadAheadSize = "0"
    diskLib.dataCachePageSize = "4096"
    diskLib.maxUnsyncedWrites = "0"

    --Now on vmx file of RAC2 “Red Hat Enterprise Linux 3.vmx” change following lines from displayName = "RAC1" to displayName = "RAC2"

    --On VMWare Server Console, Click on File and Open or “Ctrl + O”

    --Click on Browse and select “red hat enterprise linux 3.vmx” from RAC2 directory

    --Now you should see two linux machines RAC1 and RAC2 on VMWare Console

    Start RAC1 and RAC2 and when you get below warning on RAC2, select create and click OK

    Make sure you can start both machine at same time, if you get message like unable to lock files, check you have added following lines in both machines vmx files mentioned above (regarding disk locking)

    Change Network Settings (IP) on RAC2

    Login as ROOT user in RAC2 machine and click System Setting -> Network

    Select eth0 and click on Edit

    Change Address from to

    Click on Hardware Device Tab and Click on Probe button

    --Repeat steps for second network card eth1 and change its IP from to

    Make sure you clicked probe on eth1 as well as shown above

    Activate both network cards by clicking on Activate as shown below

    If you get error message that eth0 has different MAC address expected as shown below; make sure you have clicked on probe on “Bind to Mac Address” on “Hardware Device” mentioned above.

    Make sure both network cards are active now, as shown below

    Add following entry in /etc/hosts file of both RAC1 and RAC2

    #### loalhost.localdomain localhost rac2 rac2-vip rac2-priv rac1 rac1-vip rac1-priv


    Now trying to ping RAC2 machine from RAC1 and RAC1 machine from RAC2

    Change Host Name of newly cloned RAC2


    Follow below step on how to change hostname on RAC2 (newly cloned) Linux machine
    Open file /etc/sysconfig/network and edit line like : HOSTNAME=XXXXX i.e. from

    Configure User Equivalency


    User equivalency for user oracle is required so that user oracle from RAC1 can communicate to user oracle on RAC2 machine without prompting for password for clusterware to work properly.

    --Login as user oracle in machine RAC1
    --Make sure sshd daemon is running (pgrep sshd), If not start it from root user like “service start sshd
    --Create RSA and DSA key on each node
    -From oracle user go to user home directory by “cd $HOME” or type cd and press enter
    -mkdir .ssh (note that there is dot before ssh which means this is hidden directory)
    -chmod 700 .ssh
    -ssh-keygen –t rsa
    -ssh-keygen –t dsa
    press enter when prompted for file to save the key and passphrase (check screenshot for more information)

    Repeat this on both the nodes i.e. RAC1 and RAC2

    Add keys to authorized key file (authorized_keys)
    -cd .ssh
    -touch authorized_keys
    -ls (You should see authorized_keys, id_dsa,, id_rsa, Here pub files are dsa and rsa public key file and id_dsa and id_rsa are private key files)
    ssh rac1 cat /home/oracle/.ssh/ >> authorized_keys
    ssh rac1 cat /home/oracle/.ssh/ >> authorized_keys
    ssh rac2 cat /home/oracle/.ssh/ >> authorized_keys
    ssh rac2 cat /home/oracle/.ssh/ >> authorized_keys
    Send authorized_keys from RAC1 to RAC2
    scp authorized_keys rac2:/home/oracle/.ssh

    From RAC1 machine as user oracle
    exec /usr/bin/ssh-agent $SHELL

    Test User Equivalency (User oracle can login to other machine without password prompt)
    ssh rac1 date
    ssh rac2 date

    Test this from both nodes RAC1 and RAC2 (You should not be prompted for oracle user password)

    For more information on User Equivalency visit chapter 2 (Page 51 to 53) of clusterware and rac installation guide

    Coming Next :
    Installing clusterware on RAC1 and RAC2
    Installing RAC database on RAC1 and RAC2 linux machines using ASM

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 9:42 AM   15 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Building Oracle RAC Part II , Install virtual disk and network card
    Thursday, July 12, 2007
    Register for R12 upgrade
    This is Part II of Step by Step RAC configuration on your laptop/desktop without investing anything extra on hardware (Free) using virtual server, virtual hard disk and virtual network cards.

    For first two posts visit
    Try installing Orcale RAC on your laptop
    RAC Part I - Install Virtual Machine and Linux

    In this Part II, We will install required linux operating package for clusterware & database, additional hard disk (voting disk, ocr and ASM), network card for interconnect and configure newly added hard disk and network card.

    Install rpm’s

    Install following rpm’s (These rpm’s are in Red Hat ES CD’s or download them from ) and install them using root account

    (compat-glibc-7.x-, gnome-libs-, sysstat-4.0.7-4.EL3.3.i386.rpm )

    rpm –ivh compat-glibc-7.x-
    rpm –ivh gnome-libs-
    rpm –ivh sysstat-4.0.7-4.EL3.3.i386.rpm

    Create Shared Disk on Virtual Machine for Cluster Registry, Voting Disk and ASM
    --Shutdown linux machine RAC1 (installed in part I) as “shutdown now” (from root user)
    --Create folder “shared” in location “c:\atul\VMWARE” (or any other location of your choice)
    --From VM Ware Console Press Ctrl + D to see Virtual Machine Settings

    Or from screen

    Click on Edit Virtual Machine Setting

    Click on Add

    Click on Next

    Select Hard Disk as shown here and click Next

    Select Create a New Virtual Disk and click Next

    Select SCSI and click Next

    Select 5.0 GB for voting disk and 5.0 GB for ocr (add second disk of 5 GB for ocr using same method) and 8 GB for asm (add third disk of 8 GB for ASM using same method)

    Enter location and disk file name in folder shared created above.
    Note* Select votingDisk for disk one created , ocr for second disk created and asm for third disk created . This name doesn't matter and this is for our understanding only.
    Click Finish

    Repeat above step of adding disk for ocr and asm. Finally you should see Hard Disk 2,3,4
    Hard Disk 2 : for votingDisk (5 GB)
    Hard Disk 3 : for ocr (5 GB)
    Hard Disk 4 : for ASM (8GB)

    This completes addition of hard disk (How to configure and share these hard disks coming next ..)

    Adding Network Card for Interconnect
    Next step is to create network card, there is already an existing network card which is used as public connection for connecting to this machine and database isnatance on this machine and new card will be used oracle clusterware as private inerconnect between two nodes of RAC i.e. RAC1 and RAC2. This private interconnect is used for clusterware talking to all remote nodes in cluster.
    From VMWare Console press Ctrl + D

    Select Ethernet Adapter this time and click Next

    Select Bridged and click Finish

    Now Start your linux Virtual Machine

    On start of linux Virtual Machine you linux machine will detect newly added network card which you can configure now (at boot time only) or you can configure later as well.

    Press Any Key to enter into setup part of network card

    Select Configure and click enetr or you can configure it later as well

    Enter following details
    IP Address -----------------
    Netmask -------------------
    Default Gateway ---------
    Primary Nameserver ----

    and select OK and press enter

    Login as Root User when prompted to login
    Above we configured newly added network card eth1 (used for interconnect).
    With below method we will configure original network card (for public connection)

    Syetem Setting -> Network

    select eth0 and click Edit

    Add entry like
    Subnet Mask
    Default Gateway Address

    Click OK and activate this netowrk card

    Activate eth0 by clicking on Activate button

    Click on Yes, when prompted to save network configuration

    Now you should see both network card eth0 and eth1 as Active

    ifconfig , from root should show you result as shown in screenshot

    Format and Configure Virtual disks (voting disk, ocr and asm )

    In this step We will format and configure Virtual Disks created above.

    From user root

    fdisk –l (This is to see list of disks, You will see entry like /dev/sdb, /dev/sdc, /dev/sdd doesn’t contain valid partition table)

    fdisk /dev/sdb (Means we are dealing with /dev/sdb)
    n (Create new disk)
    p (Of type primary partition)
    1 (First Cylinder)
    Enter (carriage return)
    Enter (carriage return)
    w (Save table to disk and exit)

    (For more information check man fdisk or below screenshot)
    Repeat above step for /dev/sdc and /dev/sdd

    So now fdisk –l you should details of /dev/sdb, dev/sdc, dev/sdd
    --Add These disks as raw devices in file /etc/sysconfig/rawdevices as
    /dev/raw/raw1 /dev/sdb1
    /dev/raw/raw2 /dev/sdc1
    /dev/raw/raw3 /dev/sdd1
    --Restart rawdevices service as service rawdevices restart

    Create directory /apps/oracle/oradata (For storing voting disk, ocr and ASM) as

    mkdir –p /apps/oracle/oradata (From Root Account)

    -->Create symbolic link pointing to these raw devices so that we know which one is for what (Optional)

    ln –s /dev/raw/raw1 /apps/oracle/oradata/ocr
    ln –s /dev/raw/raw2 /apps/oracle/oradata/votingdisk
    ln –s /dev/raw/raw3 /apps/oracle/oradata/asm
    --Change ownership of these directories to oracle:oracle
    chown oracle:oracle /dev/raw/raw1
    chown oracle:oracle /dev/raw/raw2
    chown oracle:oracle /dev/raw/raw3

    Shutdown this machine as this is now ready to clone and to create RAC2 machine.
    Coming Next
    -Cloning RAC1 to RAC2
    -Changing RAC2 network and hostname details
    -Configuring user equivalency
    -Installing clusterware
    -Installing Oracle rac database
    -Tips and Tricks of troubleshooting Oracle RAC Database and clusterware.....

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 11:52 PM   21 Comments
    About Me

    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Only search this Blog
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Add On

    Add to Technorati Favorites



    Add to Google


    Add to My AOL


    Subscribe in Bloglines


    Subscribe in NewsGator Online

    Powered by

    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Copyright © 2006 All rights reserved Presented by Atul Kumar