patternMinor
What makes an Oracle Applications DBA different from an Oracle DBA?
Viewed 0 times
fromwhatmakesapplicationsdifferentdbaoracle
Problem
All Oracle databases support some type of application that the Oracle DBA would need to have some knowledge of. What makes an Oracle Applications DBA different than this? Does the term mean that they support the Oracle Applications and not the database, or does it include responsibilities for both the Oracle Applications and the database. If the latter then this seems to be done differently than every other type of application that can run with an Oracle back end. For example, you don't see Oracle .NET DBAs. Can someone clear up my limited understanding on this topic?
Update:
It seems very clear from the two answers so far that I did not word the question well enough. My context is not Application DBA in the Developer DBA sense vs. Production DBA. I am asking about the particular job title of "Oracle Applications DBA" or "Oracle Apps DBA". Do a search for the phrase and you'll get results like the following:
http://becomeappsdba.blogspot.com/
http://appsdba.info/
http://teachmeoracle.com/interview.html
etc.
The best explination I have found so far is from http://www.club-oracle.com/articles/what-is-oracle-applications-259/ which says:
Oracle Applications is an Enterprise Resource Planning Software, which
is run by large industries to control their industry-wide operations.
This software involves separate segments known as modules for separate
business processes. Each module is basically a collection of forms
(with some data displaying reports) where at each stage of the
business process, data needs to be entered. The forms enforce industry
best-practices controls on data input and process flow.
Update:
It seems very clear from the two answers so far that I did not word the question well enough. My context is not Application DBA in the Developer DBA sense vs. Production DBA. I am asking about the particular job title of "Oracle Applications DBA" or "Oracle Apps DBA". Do a search for the phrase and you'll get results like the following:
http://becomeappsdba.blogspot.com/
http://appsdba.info/
http://teachmeoracle.com/interview.html
etc.
The best explination I have found so far is from http://www.club-oracle.com/articles/what-is-oracle-applications-259/ which says:
Oracle Applications is an Enterprise Resource Planning Software, which
is run by large industries to control their industry-wide operations.
This software involves separate segments known as modules for separate
business processes. Each module is basically a collection of forms
(with some data displaying reports) where at each stage of the
business process, data needs to be entered. The forms enforce industry
best-practices controls on data input and process flow.
Solution
As your own question answers: "Oracle Applications is an [ERP]." An "Oracle Apps DBA" will be someone who is experienced in working with the particular schema and tooling around this ERP. There are hundreds (if not thousands) of packages, tables, stored procedures, and interfaces that are specifically built for the ERP. It is not a trivial database to admin. You can get a brief glimpse into some of the things in their ERP by looking around - for example, this blog - or by logging into a Metalink account as someone who is a customer of their ERP solution, where you can get ERDs and other documentation.
Context
StackExchange Database Administrators Q#4881, answer score: 4
Revisions (0)
No revisions yet.