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 Apps DBA Training Institues in India
    Tuesday, August 28, 2007
    Register for R12 upgrade
    Looking at mails in my inbox from DBA's and freshers looking for Oracle Apps DBA training Institutes/courses, I decided to dedicate this post for Training Institutes providing Oracle Apps DBA Training.

    Few things you should check before joining Training

    --Formal Training is always good to quickly get an overview of product but not enough; to become good Oracle Apps DBA lot of practice & hands on experience is very important. Look for Institutes which provide lots of hands on and give enough time for practice

    --Ask for previous students detail and Check with them about quality of training.

    -- Check about Instructor and his/her expertise

    -- For Oracle Apps DBA training; apart from basics look for at least Installation, Patching and Cloning.

    Oracle University
    ********************** check for course "D17423GC51 11i Install, Patch, and Maintain Oracle Applications"

    Institutes mentioned here are in alphabetical Order and I don't personally recommend any training Institute.


    Human Base India Inc.
    Software Development Centre
    Royal ArcadeNo.6, 4th Floor,
    80 Ft RoadKoramangala, Industrial Layout
    Bangalore – 560 095
    Tel: 91- 80-25531221, 25532440, 25535429e-

    Q-Soft Systems & Solutions (P) Ltd.
    #253/19, 1st & 2nd Floor,
    Kanakapura Road,
    Jayanagar 7th Block,
    Tel : +91 80 26639207, 26544135
    Fax : +91 80 26637692
    URL :
    E-Mail :


    Crest Of Technolgies
    No. 64, A.R.R. Complex,
    North Usman Road, T.Nagar,
    Chennai - 600017.
    Ph : +91 44 55634550, 55634551

    Ikon Infotech
    II Avenue, II Floor,
    Near Blue Star Signal Annanagar,
    Chennai - 40
    Ph : +91 44 26214127 , 42611909

    Ora Solution
    10th Main Road II Avenue,Annanagar,
    Chennai - 600 040
    Ph : +91 44 42612461 , 9841148256


    Ducat India
    A-52 & A-43 Sector-16,
    Noida U.P : 201301, INDIA
    Tell: +91-0120-4646400-430
    Mob: +91-9999036441 9871055180-81


    Above ICICI BANK
    MIG :214 ,

    Applsys Solutions

    1st Floor, Plot# 26,
    Beside Lotus Lap School
    HUDA Shopping Complex
    Kothapet, Hyderabad-500035
    Tel# +91-9949969953; +91-(40) 24050503

    Trans Global Solutions
    Near Harsha Mess,
    Opp. Swarna Jayanthi Complex,
    Ameerpet, Hyderabad

    Vennela Technologies Pvt Ltd
    24/A, 2CNandanavanam Complex
    S.R. Nager
    Ph : +91-40-55982662



    Spider Systems Pvt. Ltd.
    Lunkas Towers , Ganpati Chowk
    Vamman Nagar, Pune

    If you know any other Oracle Apps DBA training institutes kindly leave Institute details here as comments


    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:57 PM   53 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Staging/Cloning 10g AS Prod to Test
    Sunday, August 19, 2007
    Register for R12 upgrade
    This is second post w.r.t. cloning Oracle 10g Application Server. For first post on overview of 10g Application Server Middle Tier cloning visit

    This post covers basic understanding of staging (cloning) 10g Application Server both infrastructure and middle tier.

    Assumptions with this cloning
    1. You have 10g Application Server Middle Tier (Portal or BI type) and Infrastructure tier (OID, SSO, MR)
    2. You have source instance (PROD) which you wish to clone to target instance (DEV/Test)

    Broad Level Steps

    A. Export Data from source Instance
    1. Install Target Instance (Dev/Test) Infrastructure tier (Try to keep same OID realm as source instance prod)
    2. Export User data from source OID Instance (using ldifwrite)
    3. Export Group data from source OID Instance (using ldifwrite)
    4. Export DAS data from source OID Instance (using ldifwrite )
    5. Copy password file from source OID using ldap search command (Do this step if you want to retain similar password policy on target instance as source)
    6. Export portal, portal_app, portal_public, discoverer5 and various other custom schemas from source instance
    7. Export SSO data using ssomig utility from source instance
    8. Export EUL (End User Layer) discoverer data from source using eulapi

    B. Install Target Instance
    1. Install Infrastructure tier (Keep OID realm similar to source instance)
    2. Install Middle Tier

    C. Clean/Clear/Delete Target Instance Data
    1. Delete Users/Groups from target Instance using (OID script)
    2. Drop portal, portal_public, discoverer5 and various other schemas

    D. Load data from source to target Instance
    1. Load User/Groups from source to target using (OID script)
    2. Import SSO data using ssomig utility with option -import
    3. Create portal & portal_public user using script wdbisys.sql & cruser.sql resp.
    4. Create discoverer5, portal_app and various other custom schema
    5. Import portal and other schema data using database IMP
    6. Create any custom OC4J and deploy application from source to target instance
    7. Import EUL data using eulapi

    For step by step procedure on creating replica / clone of 10g Application Server Production Instance to Test Instance visit

    Issue in Documentation
    : Oracle Document mentioned above doesn't cover discoverer5 schema import/export so if you hit any issues with discoverer import discoverer5 schema

    Cloning E-Business Instance integrated with 10g AS Portal,Discoverer, OID and SSO coming soon ...


    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 @ 10:15 PM   3 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Cloning / Staging Oracle 10g Application Server
    Friday, August 17, 2007
    Register for R12 upgrade

    This post is useful for those who are using 10g Application Server and want to clone 10g Application Server (Portal, BI or Forms and Reports) from Production to Test or Vice Versa.
    For cloning Oracle Applications 11i / E-Business Suite check

    Key points for cloning 10g Application Server (as of 19 August 2007)

    -You can clone middle tier installation of 10g AS (J2EE & Webcache, Portal & Wireless and BI & Forms)
    -You CANNOT clone
    ----i)Infrastructure Tier (MR & IM)
    ----ii)OAS Integration, BPEL Process Anaytics or BPEL process manager
    ----iii) Developer kit and SDK
    ----iv) Installation that includes workflow

    There is manual method to create replica of source instance in to target instance; called as Staging source infrastructure instance to target infrastructure instance.
    - Middle tier cloned instance must have different Instance Name than source instance name.
    - You can clone MT (Middle Tier) that is member of OracleAS Cluster or Farm but you must remove instance from OracleAS Cluster before beginning cloning operation.
    - Middle tier Cloning process does not configure Load Balancer. If you use one, you have to configure it manually including invalidation port

    - If in source instance, webcache is member of cache cluster, then target webcahe should be manually added in to cache cluster (or delete other cache cluster member info manually if you don't wish to target cloned instance as cache cluster)

    -During 10g AS middle tier cloning, source ORACLE_HOME is copied to destination ORACLE_HOME , then a set of scripts is used to update information in key configuration files of oracle application server middle tier (like hostname).

    Oracle 10g AS Middle Tier cloning process

    i) On source instance run (in $OH/clone/bin) (This script parses files, create archives using DCM, backs up required files, and run wireless clone assistant if wireless is enabled)

    ii) Copy ORACLE_HOME to destination location

    iii) On target instance run (this step invokes OUI which repeats all actions done during source instance installation)

    iv) In post clone phase, also does following post clone steps to make target cloned instance to a working state. These are
    ---a) setting new ORACLE_HOME in DCM
    ---b) update configuration file
    ---c) calls chgiphost command to change hostname and IP address in cloned instance
    ---d) If source instance was connected to OID (Portal/BI) then add information about clone in OID
    v) After cloning and starting services on target instance on unix you have to run (from root user)

    I hope by now its clear to you that cloning of middle tier on 10g Application Server is still not as mature as cloning Apps/E-Business Suite (11i or R12).
    In coming post I'll cover creating replica or staging 10g Application Server (Portal or BI) production instance to test instance so that users/groups, portal, BI, SSO and DAS data can be migrated from source instance to target instance for as close as possible copy of production instance.



    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 @ 10:02 PM   8 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Blogoversary : One Year Journey of becomeAppsDBA Blog
    Friday, August 03, 2007
    Register for R12 upgrade

    436,268 Views, 171,067 hits, 1374 Comments, 744 email subscribers and 157 posts to finish one year Journey of this blog.

    One Year ago on 30 July 2006, I posted first topic on this blog with a Vision to share my experience as an Oracle Applications DBA and to help other budding DBA's/administrator who want to explore Oracle Applications (E-Business Suite, Application Server, Collaboration Suite and Oracle Identity Management).

    On this occasion I want to thank few people without whom this blog would not have been such a success.
    Steven Chan whose post inspired me to start this blog (I admire his dedication for Apps Community), Harmeet Kocchar (Senior Manager @ Oracle, my mentor) who gave me direction to learn Apps, Khushi (My Wife) for her support and patience, Anil Passi (Famous blogger among Apps Techno Functional consultant) for his friendly advice and innovative ideas, Fadi Hasweh for nominating me for Oracle ACE, Subba Rao, Ramnik and other members answering budding apps dba's queries at forum and finally to my readers for making this blog such a Success.


    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 @ 1:38 AM   12 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