typical tasks or assignments for an App DBA

Hi,

I am an Oracle DBA with 3 years of DBA experience. However, I am new to Oracle Application. Our company is going to use Oracle App in the near future. To start my practice and learning, I installed 11.5.4 on a testing Win2000 machine and the installation is just fine. Now I can start the application GUI and start doing my practice.

Could some serior AppDBAs please share some of your experience and help with these questions:

1. What are the typical tasks or assignments for an App DBA to do when setting up the initial environment for the company?

2. What are the daily routine tasks for an App DBA?

3. What are the resource to look for?

Thank you!

DBA_Lisa,

Apps DBA is a technical position. The following are basic responsibilities of Application DBA:

1. Application installation/upgrade
2. Application patches, Database patches, upgrade patches, Interoperability patches etc.
3. Web Server Administration.
4. Concurrent Manager Administration/tuning.
5. System Administration. This includes creating a new Apps user, responsibility, definition of menus, forms, reports etc.
6. Other jobs similar to Oracle DBA.

For list of books and technical documentation:
Go to http://www.osborne.com. and search for Oracle e-Business Financials Administration.
The book has a good section for managing Oracle Application. Also check for oracle documentation at:
http://docs.oracle.com/DOCS_DOT_PDF_Storage/a90130.pdf. You will need metalink access.
http://www.appsdba.com --> good scripts here and check out the reference link for some great sites.
A list of other good 11i books:
1. Oracle E-Business Suite Financials administration by Shankaran Iyer

2. Oracle E-Business Suite Manufacturing & Supply Chain Management by Bastin Gerald, Nigel King, and Dan Natchek

3. Oracle E-Business Suite Financials Handbook by David James, Graham Sebiert, and Simon Russel
These books can be purchased at the following places:
Oracle store, Oreilly, Amazon websites

See below few tips(questions) I got from dbasupport.com concerning Application DBA job skills

* have you ever installed Oracle apps ?
* what are the pre-requisites to install them?
* what are the component involved in Oracle Apps installation from the Oracle technology Stack ?
* Have you applied maintenance patches before ?
* How are they apllied ?
* What is the difference between a patch and a minipack ?
* how can you determine that you need a maintenance patch and how can you get it ?
* Have you used metalink before , could you open an iTar ?
* Have you installed printers on the system before ?
* What are the data you need in order to install the applications properly ?
* What are the post installation steps ?
* Is it possible to create more than one certificate for the apps?
* Have you made mutinode installation before ?
* How can you start and stop the apps and in what order do you start and stop its components ?
* Is it possible to add rollbacks , redo log files to its database or you must stick with the original components ?
* If you encountered a failed worker while applying a patch how are you going to solve the situation and how can you be sure of the consequences ?
* Where can you find logs generated from the applied patches ?
* How can you configure personal homepage on the system ?
* How can you formulate the Data Access Descriptor DAD for the applications ?
* can you use adadmin tool ?
* what is the MKS toolkit ?
* it is possible to relink ad executables through adadmin utility ?
* what is the purpose of using adsplicer ?
* is it possible to move the database to another server through export ?
* can you change the apps & the database characterset after installing the apps ?
* Can you create and enroll users on the systems ?
* What is the Minimum hardware required to run Oracle Apps at a reasonable performance ?

some more questiosn with answers!
-----------------------------------------

11i Questions

1. In a two-node install, does $APPL_TOP get installed on each node?

2. In a multi-node install, which nodes get an $APPL_TOP, and is it the full $APPL_TOP?

3. On a two-node install, where the first node is UNIX and the second node is NT, are the NT requirements listed in Installing OA, p.2-2, required (MS C++ V6 SP3, MKS Toolkit V6.1a, and gnu make V3.7.7)?

4. On a two-node install, where the first node is UNIX and the second node is NT,where do the following components reside?
WebDB 2.5?
Reports Review Agent?
TCF Socket Server?
Apache Server?

5. What is the Administration Server, (Installing OA, p4-1)?

6. What does the RAPIDWIZ option “Do not install database” do? Would it allow us to pre-create the database to our own specifications? How would the database get populated?

7. Are the product data and index datafiles created for all products, even if only some products are chosen?

http://www.appsdba.com --> good scripts here and check out the reference link for some great sites.
http://www.oaug.com/ --> join the excellent DBA listserver here. You may get alot of mails, but if you have a lot of questions about APPS DBA stuff, chances are they will be answered here.
http://www.geocities.com/SiliconValley/Network/9828/
http://docs.oracle.com/index.html

Good Luck

C. K.
11i Applications DBA
_______________________________
In all you're doing, seek divine wisdom

Hi C.K

Can u list some book which covers configuration of Oracle Web Server 3.0.1 & Workflow in Oracle Apps Release 11.0.3
or can u recommend some URLs other than metalink

Thanx

C. K,

Thank you. I will try to find the answers for those questions!

Meanwhile, do you know how the job is coordinated between a "Functional Consultant" and a "Technical Consultant" (App DBA)?

Thanks a lot!

Hi shaan,

I think that metalink has pretty much good info on how to configure web servers. Otherwise check some books on web application and databases.

For DBA_Lisa,

You must have a project manager/director who really understands the roles of the functional and technical consultants for the project to be successful. The technical consultant can further be grouped into developers/programmers, system Administrator and Application DBAs.

C. K.
11i Applications DBA
_______________________________
In all you're doing, seek divine wisdom

These links might help

http://www.dbasupport.com/forums/sho...threadid=10936

Hi

Just curious what do the Oracle eCrm forms developed in . Oracle Forms or any other front end .

Cheers
Afshin