Learn Applications DBA

Tuesday, December 12, 2006

New Author for this blog !!

Today my friend Rajesh has joined this blog to conttribute towards this topic. Hopefully you will see more updates from both of us now !!

cheers
Sandeep

Monday, September 11, 2006

Oracle E-Business Suite Documentation

Learning Oracle Products is always easy !! ..Oracle Technology Network(OTN) is something I have been using ever since its been introduced to learn about Oracle Products & reading articles about Oracle Products to enhance my knowledge.

Oracle Applications Documentation is available on OTN

For lot of people it feels like that documentation is too much to read sometime. But beleive me its the best way to learn any product. It gives you first hand information about what's being included in the software you are going to learn.

Off-course learning more than documentation is by using the product effectively & understand the functionality by experiencing it practically.

There are few things you must start with before you jump on advanced topics :

  1. Oracle Applications Concepts
    • This will provide you first hand information about concepts in Oracle Apps. It includes all the terms & topics you must know before you start your journey towards learning Oracle Apps. I would suggest to read this atleast once before you even see the Oracle Applications on a Machine !!
  2. Oracle Applications Installation Guide: Using Rapid Install
    • This is the documentation which you would read carefully before you Install the Oracle E-Business Suite on your Server. This will provide you all the information you need to install the Applications using Rapid Install on your respective Platform(OS). With Rapid Install, the Oracle Applications Installation is very fast & smooth !! ..If you follow all the pre-reqs, then you will find installation very easy to follow. Overall I have found that all the Oracle Products have very good installation mechanism !!
The above mentioned 2 manuals are the basic is what you need apart from Release Notes for the specific install you are installing. The are some more things you need to access using Oracle Metalink in order to have more information about your installation & any new notes being published about any issues or enhancements.

I will cover some more topics at conceptual level to start learning Oracle Apps in more structured way !!

Your comments are welcome !!

Thursday, September 07, 2006

Oracle E-Business Suite Concepts

Oracle E-Business Suite (also known as Oracle Applications) is a complete Suite of modules having functionlity to support many business functions like Manufacring, Financials, HR, etc.

We will try to cover some technical concepts related to Oracle E-Business Suite.

  • Oracle Applications 11i
    • This is the current latest release (as of Sept-06) family of Oracle E-Business Suite. The latest release is 11.5.10.2. The previous major release before this was 10.7. The Release number 11.5.x denotes the Major 11i release & 11.5.10.x , the “x” denotes the CU (Consolidated Update) version for the release.
  • Oracle Applications Architecture
    • For in-depth understanding of Oracle Applications Architecture, please visit the website(http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/11iconcepts.pdf).
    • Multi-Tier Architecture
      • Desktop Tier
        • This is the Client Interface for Oracle Applications. There are two types of interfaces : HTML Based & Forms Based(uses Java Applet)
      • Application Tier
        • Application Tier or Middle Tier performs the function of hosting of various servers which process the business logic & managing the communication between the Client Tier & Database Tier. There several logical components in this Tier :
          • Web server
          • Forms server
          • Reports server
          • Discoverer server
          • Concurrent Processing server
          • Admin server
      • Database Tier
          • Database Tier is the Oracle Database Server, which contains all the Oracle Applications Data. Also maintains the Online Help Information. There could be various type of Database Tiers :
            • Single Instance
            • Real Applications Cluster(RAC)
      • Oracle Applications Technology Layer
          • This Layer provides function for all the common modules for Oracle Applications. Following are some of the products in this Layer:
            • Oracle Applications DBA (AD)
            • Oracle Applications Object Library (FND)
            • Oracle Applications Utilities (AU)
            • Oracle Common Modules (AK)
            • Oracle Workflow (WF)
            • Oracle Alert (ALR)
            • Oracle Applications Framework (FWK)
            • Oracle XML Publisher (XDO)
All these Tiers can either be in a Single Node(Machine) or seperated in several nodes depending upon the business requirements.

This is just a start for this Topic, I am thinking of making these learning topics small & quick to grasp kind of things. Also would include some practical tips & quesitons/answers in order to understand topics easily. For more reading one can always go for the Oracle Applications Documentation available on OTN.

Please share your comments for me to know what people think about it !!

Monday, September 04, 2006

Focus on Learning Applications DBA

I am starting this blog to focus mainly on learning Applications DBA activities. This would start with understanding the concepts of Applications 11i. Then take the major activities an Applications DBAs need to perform regularly.

I will soon start with Basic Concepts of Applications 11i . Which would help all people who would liek to learn Applications 11i from start !!