Oracle Apps DBA

What is Applications DBA

An Application Database Administrator is one who not only takes care of administrating the Oracle Database (9i, 10g) but also administers the Oracle Applications (11i / R12) . Thus the responsibility of an Applications Database Administrator is wider in scope as he is more than a regular DBA. An Application Database Administrator has to know the administrating the Oracle Database plus he has to know the administration of the Oracle Applications .

What is Oracle Applications

Oracle Applications is the E-Business Suite provided by Oracle. The latest version of Oracle Applications is Release 12 . Oracle Applications consists of two things One Oracle Database and second the Application software. The two when combined makes Oracle Applications or Oracle E-Business Suite as a whole. Thus the architecture of Oracle Applications is three tier. One tier consists of the database, second the middle tier consists of the application tier and the third the client desktop

Responsibilities of Apps DBA

Take care of the Oracle Database

Take regular backups of the Oracle Database

Identifying the day to day issues coming in managing the database and fixing them

Recovering the database whenever applicable

Tuning the database whenever there is a performance issue

Install Oracle Applications

Upgrade Oracle Applications

Cloning of Oracle Applications

Applying patches

Using Adutliites for day to day maintenance

Managing all the middletier components like Apache Forms Concurrent Managers Reports

Book on Oracle Applications DBA

Tata Mc Graw hills have just now launched a book on Oracle Apps DBA. This book has already been released in India and expected to release worldwide in a couple of months. This book covers both 11i and R12 and maintains a well balance between them. This book is embellished with over 350 screenshots and illustration making the manage of complex Oracle Applications system in an easy way.

Chapter Details

The book contains the following chapters

1. Oracle E-Business Suite: An Overview

2. Oracle Application Architecture

3. Oracle Application File System

4. Installing Oracle Applications

5. Checking and Configuring Oracle Applications

6. Managing Oracle Applications

7. Concurrent Processing and Concurrent Manager

8. Patching Oracle Applications

9. AD Utilities

10. Cloning

11. Oracle Application Manager

12. Upgrading Oracle Applications

13. Printer Setup

14. Managing Application Security

Main Menu

See Also

Main Menu