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
    Apps 11i DBA preparation
    Saturday, August 19, 2006
    Register for R12 upgrade
    As I am getting lots of request for how one should prepare for Oracle Apps 11i DBA in
    Technical domain including Sysadmin, I am summing up things you should learn / study in
    order to understand E-Business Suite 11i . The topics mentioned below, which you should
    read in order to become apps DBA or as part of your Oracle Apps DBA training will include
    roles & responsibilities of oracle Apps DBA.

    1. Apps Architecture
    This is key topic & you should be very clear about Oracle Applications/E-Business Suite
    11i components & Architecture. This is base of your knowledge & if you are not clear about
    various components & uses it will be quite difficult in learning Apps.
    Where to find Oracle Applications 11i architecture in Ocean of oracle Application
    technical documentation. Well I agree with you go straight to and go through chapter 1 (Page 13 to Page 32 Just 20 Pages)

    2. Installing Apps 11i
    Next point in apps dba training is Oracle Apps 11i Install using Rapid Install preferably on Linux/Unix
    Where to find Rapid Install 11i Oracle Apps Guide This is guide by Oracle for a start Chapter 1 & 2 are enough page 13 to p 63 is enough to understand Installation)
    Where to find Discs / software for Oracle Apps 11i E-Business Suite : You can download it via or order it via your Metalink account . Once you got CD , please do install Apps atleast once in order to understand & to familiarize your self with Oracle Applications

    3. Apps 11i File System/Software
    Once you installed applications 11i using above guide on Unix/Windows/Linux software then login as Operating System User & check directories while going through document Chapter 2 Applications File System (P39- 48) very important in understanding Database Server & Application Server Tier & various tops like DATA_TOP, ORA_TOP, APPL_TOP, COMN_TOP, AD_TOP....
    If you know your applications 11i File system you know where to find particular component files & logs .

    I think this is enough for keep you going for 10-15 days , pay as much attention you can on these basics as these are building blocks of your careers as Apps DBA. For remaining tips on how & from what to prepare next like AD Utility(patching, adsplice,..), Cloning ... I'll update you tomorrow .

    Now you can raise your doubts/questions/issue in forum at (Dedicated to Apps DBA's)

    Atul Kumar

    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 @ 2:28 PM  
    • At 11:38 AM, Blogger Ramana said…

      Hi Atul

      Thanks a lot for your time and help. I have completed the 3 parts you have mentioned i.e Architecture, installation and file systems. I have done a single node installation on Solaris SPARC server and is working fine.

      Could you pls guide as how to proceed further....Also I would like to create users with access to different modules and so on..Please advise.

      Thanks in advance..

      Best Regards

    • At 4:36 PM, Anonymous Anonymous said…

      awe some work..thank you so much, Its a wondeful guide for all dba's.

    • At 7:01 PM, Blogger Atul Kumar said…

      Thats good news . I think you have done pretty much for a start , Are you working some where on apps. You can start looking into apps patching & cloning now .

      May be upgrade in future .


    • At 7:02 PM, Blogger Atul Kumar said…

      By the way what do you means by... I would like to create users with access to different modules and so on..

      Authorization in apps is controlled by responsibilities.


    • At 9:16 AM, Blogger Ramana said…


      Thanks a lot for your response and encouragement. I have not yet started working on prodn system. I have installed Apps( on my ODC test server and trying to get hands on. I have plans to take up an Oracle Apps DBA assignment soon. As you suggested, will try my hands on patching and cloning.

      When I go through the Apps documentation on responsibiltes I could not find any practical examples. Could you please write an article on "Creating and mananging Users in Apps" as all your articles are very easy to comprehend and are giving a clear understanding, like your various TOPS explanations.

      Keep your good work going.

      Hats Off..


    • At 10:07 AM, Blogger Atul Kumar said…

      Thanks Ramana,
      I'll try to post on creating users & adding reponsibilities under oracle apps security section oin apps system administration section. I am still at Apps DBA sections & lot way to go like

      SSL on apps in Web Server / Forms & database
      Parallel Concurrent Processing &
      Demystifying Autoconfig

    • At 2:18 PM, Blogger satya said…

      hi Atul,
      first of all i want ot congratulate u for providing such a wonderful site.
      I am working for satyam computers from the past 2 yrs(i joined as ELTP).I am having exp in java-j2ee, now i came to know that Oracle fusion which is the upcoming series is built on java/j2ee techs. SO i am planning to learn Oracle Apps. What would be best for me Oracle apps or some self server applications in Oracle.

    • At 2:22 PM, Blogger Atul Kumar said…

      Nice to hear from you. Yes oracle is coming with fusion & in next apps release i.e. Rel 12 , you will see Oc4J & 10g iAS

      It depends on what you want to learn , if you want to beconme developer then OA Framewrok may be good for start .
      If you want to move in Apps DBA soon I am going to cover on Fusion Middle ware , includign SOA ( Service Oriented architecture)


    • At 11:31 PM, Anonymous Amresh said…

      Hi Ramana,

      To create user you have to have system administrator resp and then go to security -->define
      This is the form now you can create user and add responsibility with them


    • At 3:01 PM, Anonymous Anonymous said…

      Hi Atul,

      I think Fusion is not same as Release 12. Fusion is a release planned after Release 12 which will combine Oracle's acquired products like JD Edwards and Siebel

      - Vikram

    • At 3:22 PM, Blogger Atul Kumar said…

      Yes Vikram you are right .

      Fusion Applications is release after Ver 12.

      For Fusion Middleware , which is collection of middleware like 10g AS, Collaboration Suite, SOA Suite , data hub.. its available .


    • At 8:45 PM, Blogger Vikram said…

      Here's an update from Steven Chan: Distinguishing Release 12 from Fusion Applications

      - Vikram

    • At 3:56 AM, Blogger Bhakti said…

      Hi All,

      My name is Bhakti Prasad Dash,
      I am a Oracle DBA working in IBM ,India.
      I have just started my apps studies with the help of Mr. Vikram Das.

      I hope i will get all relevant suggestions from all of you.


    • At 9:23 AM, Anonymous Anonymous said…

      Guru Gr8 Atul ji,
      It is realy a wonderfull help you did for people like me. I'm assigned APPS DBA where the implementation is already going on to way of production and the DBA has done already his installation 3-4 months back and left. I'm newbi to hear this APPS and was having tension "what is apps". Now i'm lucky, Atul Guruji has given me chance to learn this apps and it realy helping me lot. I'm basically oracle core dba expreinced. Thanks, once again to Guru Atul ji!

    • At 6:56 PM, Blogger Sergio said…

      Hi Atul,

      Thanks for all the work and information in this web site. I've just migrated an 11.5.9 instance from 9i non RAC to 10g RAC with two RAC DB nodes with concurrent processing tier and PCP enabled. I also added a third node containing the web and forms services. Now I need to add a fourth node containing the forms and web services to provide fault tolerance and load balancing for that tier.
      Is it possible without using a hardware load balancer ?


      Sergio Chong

    • At 7:44 PM, Blogger Atul Kumar said…

      You can use DNS server as your load balancer.


    • At 8:39 PM, Blogger Vivek said…

      Hello Atul
      You are doing great job, i m Oracle 9i certified DBA and want to enter Apps Field,Can u tell me frm where i can get Apps Software, becz its very heavy software n impossible to download (appox 35 GB). I m trying from the past 1 month to download this from net but failed.So suggest me plzzzzzzzzzzz.
      Thanks a lot

    • At 10:09 PM, Blogger Atul Kumar said…

      You can get CD's from oracle via Metalink

    • At 3:08 AM, Blogger vicky said…

      Hi Atul

      I am unable to find media pack of oracle 11i on metalink. can you send me a link. I have metalink id. plz its urgent for me.



    • At 10:03 AM, Blogger Atul Kumar said…

      link for media pack for 11i is

    • At 10:03 AM, Blogger Atul Kumar said…

      link for media pack for 11i is

    • At 12:08 AM, Blogger Shravan Deekonda said…

      This comment has been removed by the author.

    • At 6:14 AM, Blogger Atul Kumar said…

      For installation you go through installation doc . File system is important in understaning and troubleshooting apps

    • At 7:10 PM, Anonymous Anonymous said…

      Hi Atul,

      I am a budding DBA, am OCA 9i already and would be DBA within a fortnight. My problem is that I am self studied person, and thus have very little hands on experience. As the job market goes its a catch 22 with me, no job--> no experience and vice versa. How can I get some quality experience with 9i as well as upgrade to application 11 i DBA.

    • At 1:46 PM, Blogger aarifhs said…

      Hi Atul,

      I am OCP(DBA) and have just done a course in Oracle Apps DBA.
      I am working as a Technical consultant in Oracle Apps.I am finding it hard to get a job as an Apps DBA, what are your suggestions on how to get one.

      Thanks and regards,

    • At 8:05 PM, Blogger Atul Kumar said…

      Getting first apps dba job is always tough so keep trying and upload CV to job sites and keep contacting companies . good luck for your job hunt

    • At 8:28 PM, Blogger ved said…

      Hi Atul,
      Could you help me?
      i am using the oracle application with windows XP.
      i am facing the problem, when i run the concurrent program
      transfer from AP to Gl.
      concurrent program complete with error. while i using the all things correct for this.
      could you help me>
      thanks in advance

    • At 8:38 PM, Blogger ved said…

      Hi Atul,
      i am using the oracle application with Windows XP.
      when i run the concurrent program
      "Transfer from AP to GL".
      it completed with error. please help me

      thanks in advance

    • At 10:27 PM, Blogger Atul Kumar said…

      Update error log for request failing .

    • At 9:42 AM, Anonymous Anonymous said…

      Hi Atul,

      I am vasu, working in Chennai, India and have been working with 11i for the past 1 year and now when I tried to install R12 on Solaris environment. The staging went on well and while installation is in progress it threw an eror.

      i give below the error displayed.

      Database Availability
      command: su oracle -c "/software/StageR12/startCD/Disk1/rapidwiz/bin/ /data/oracle/VSIN/db/tech_st/10.2.0/VISN_sunapps.env APPS/APPS" started at Sat Oct 20 17:59:58 IST 2007

      Parameters passed are : /data/oracle/VSIN/db/tech_st/10.2.0/VISN_sunapps.env APPS/APPS
      Cannot find environment file /data/oracle/VSIN/db/tech_st/10.2.0/VISN_sunapps.env

      RW-50011: Error: - Database ORACLE_HOME connection test has returned an error: 1 command: su applmgr -c "/software/StageR12/startCD/Disk1/rapidwiz/bin/ /data/oracle/VSIN/inst/apps/VISN_sunapps/ora/10.1.2/VISN_sunapps.env APPS/APPS" started at Sat Oct 20 17:59:59 IST 2007

      Parameters passed are : /data/oracle/VSIN/inst/apps/VISN_sunapps/ora/10.1.2/VISN_sunapps.env APPS/APPS

      The environment settings are as follows ...

      ORACLE_HOME : /application/apps/VSIN/apps/tech_st/10.1.2
      ORACLE_SID :
      PATH : /application/apps/VSIN/apps/tech_st/10.1.2/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/ccs/bin:/software/StageR12/startCD/Disk1/rapidwiz/unzip/Solaris:/usr/ccs/bin:/usr/sbin:/usr/bin:/usr/openwin/bin:/usr/ucb:/usr/ccs/bin:/usr/openwin/bin:/usr/dt/bin:/usr/platform/SUNW,Sun-Fire-280R/sbin:/opt/sun/bin:/opt/SUNWexplo/bin:/opt/SUNWsneep/bin:/opt/rsc/bin
      LD_LIBRARY_PATH : /application/apps/VSIN/apps/tech_st/10.1.2/lib32:/application/apps/VSIN/apps/tech_st/10.1.2/lib:/usr/dt/lib:/usr/openwin/lib:/application/apps/VSIN/apps/tech_st/10.1.2/jdk/jre/lib/sparc:/application/apps/VSIN/apps/tech_st/10.1.2/jdk/jre/lib/sparc/native_threads

      Executable : /application/apps/VSIN/apps/tech_st/10.1.2/bin/sqlplus exiting with status 2

      RW-50011: Error: - Apps ORACLE_HOME connection test has returned an error: 2

      could you kindly let me know what is the problem ?

    • At 6:03 PM, Blogger Atul Kumar said…

      Kindly Use new site

    • At 6:01 PM, Blogger giri said…

      Hi Everybody ,

      This is Girish ... Am an oracle DBA . I want to switch towards Apps DBA ... Please
      suggest some good institutes in Hyderabad & Bangalore

    • At 3:26 PM, Anonymous Anonymous said…


      I am unable to install Oracle Apps 11i. Could anyone please send me a Installation Document on Windows 2003 Platform to


    • At 3:27 PM, Anonymous said…


      I am unable to install Oracle Apps 11i. Could anyone please send me a Installation Document on Windows 2003 Platform to


    • At 3:30 PM, Anonymous Anonymous said…


      I am unable to install Oracle Apps 11i. Could anyone please send me a Installation Document on Windows 2003 Platform to


    • At 7:20 AM, Blogger pavan said…

      Hi atul this is kalyan working as core DBA and wanted to update myself with applications.Jus gone through your site and started the architecture part.Please guide me in this matter.

    • At 7:27 AM, Anonymous Anonymous said…

      Hi atul this is pavan working as a core dba and wanted to upgrade myself with appications jus gone through ur site.Started architecture part.please guide me in this matter

    • At 5:48 PM, Anonymous Anonymous said…

      ur really doin great ..

    • At 5:49 PM, Anonymous Anonymous said…

      hey ur doing really great yaar atul

    • At 3:12 PM, Blogger guna said…

      hai, i want to install oracle 11i apps dba on fedora 7. please tell me how to procede installation on fedora 7

    Post a Comment
    << Home
    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