Monday, April 15, 2013

Oracle APPS DBA vs Oracle DBA

Name Different In One Thing Apps , Both Are DBA for the same corporation but before going further you need to know what the definition for both of them what APPS DBA mean and What Oracle DBA mean ?

Oracle DBA ( Database Administrator ) is the person who responsible for administration , Monitor , tuning and recover database ( Failure cases ) For Oracle Database this Person Called Oracle DBA.

Lot of Jobs and Tasks for this Person

  • Installing and upgrading the Oracle server and application tools
  • Allocating system storage and planning future storage requirements for the database system
  • Creating primary database storage structures (tablespaces) after application developers have designed an application
  • Creating primary objects (tables, views, indexes) once application developers have designed an application
  • Modifying the database structure, as necessary, from information given by application developers
  • Enrolling users and maintaining system security
  • Ensuring compliance with your Oracle license agreement
  • Controlling and monitoring user access to the database
  • Monitoring and optimizing the performance of the database
  • Planning for backup and recovery of database information
  • Maintaining archived data on tape
  • Backing up and restoring the database
  • Contacting Oracle Corporation for technical support

For More Information Read oracle Documentation Here.

in he big company that required 24/24hr monitor for more than one database therefore you cannot assign everything to this person he will be killed. So two kind of DBA appeared to reduce Tasks 
Development DBA   & Production DBA each one of them has it's own job and Tasks.

Development DBA: 
well from the name you can see it's person who works closely with developers team to make sure database design and performance are working find without any problems.

Production DBA
Person who responsible to ensure that Database for this company is healthy and running without any problem it's not easy job since this type of Database is the main database for company so you have to ensure it's working fine or you will be fired.

I mention before of my blog how to become DBA and what you need to do that ? Good understanding of the Oracle database,  understanding of the underlying operating system ,  how Oracle acquires and manages resources, knowledge of both database and system performance tuning,communication skills , management , and ability to handle multiple projects and deadlines all this Hints to become DBA. Read my Post About "how to become DBA" Here 

After you have small knowledge about DBA tasks and What he is doing ? Let's talk about APPS DBA.

Simply the equation :
ORACLE APPS DBA = Application* + Database.

*Which Application is Fusion Middle Ware Products from Oracle.

If you are aware of all the previous tasks  then you are able to be Oracle APPS DBA, Oracle APPS DBA include all Oracle DBA tasks and it's very huge subject to learn and explorer.

So the Task for APPS DBA :
  • All Oracle DBA tasks.
  • Patching
  • Cloning 
  • Maintenance Oracle Application.
  • Installations Oracle EBS.
So as conclusion Oracle APPS DBA is an Oracle DBA because of this he can switch easliy between this job Role, and don't let this disappointed you also Oracle DBA can switch to APPS DBA but he must read LOT.

Thank you 
Osama Mustafa  


  1. Hello Osama,

    I think if I am not mistaken, you wrote a topic > Poor Man's Dataguard before? How do I search it from here?

    1. Yes , Use the Search Bar in my blog m, if you cannot find it contact me please


  2. this is very good nice article. this is very useful for Oracle Apps DBA students.

    This is very nice article. This is very use ful for Oracle Apps DBA Learners.

    hi sir. i want to do Oracle Apps DBA training.
    Oracle Apps DBA ONlINE TRAINING Thanks for providing valuable information.

  3. Hello Osama,

    can you please share poor man's dataguard article?

  4. This comment has been removed by a blog administrator.

  5. QA Training Hub is best Python Programing Online Training Center in India. Python Online Training provided by real time working Professional Mr. Dinesh. Data Scientist and RPA Expert with 18+ years of industry experience in teaching Python.

    PYTHON Online Training Course concepts:
    Introduction to Script
    Introduction to Python
    Different Modes in PYTHON
    Variables in Python
    String Handling in Python
    Python Operators and Operands
    Python Conditional Statements
    Python LOOPS
    Learning Python Strings
    Sequence or Collections in PYTHON
    Python Lists
    Python TUPLE
    Python Sets
    Python Dictionary
    Python Functions
    Python Modules
    Packages in Python
    Python Date & Time
    File Handling in Python
    Python OS Module
    Python Exception Handling
    More Advanced PYTHON
    Python Class & Objects
    Python Regular Expressions
    Python XML Parser
    Python-Data Base Communication
    Intro to Web scrapping
    Intro to Data Analytics
    Introduction to Machine Learning with PYTHON
    Intro to Data Science
    Intro to Internet of Things

    Please Contact
    Mr. Dinesh Raju
    India: +91-8977262627, USA: : +1-845-493-5018