ERPstuff - Oracle EBS Community

Hi All,

Can Anyone explain in detail about the Apps DBA Responsibilities and Functions a APPs DBA.....

What are the roles performed by the DBA......

What a DBA does?? What are the work to be taken care of a DBA????

Is there any way to do the activities of DBA as remote? What are the services can be offered by a remore DBA?


Thanks
Uma

Installation
Administration
Patching
Cloning
Performance tuning

and other general troubleshooting to ensure the smooth operation of the appliation

Hi,
Thanks for the reply,

by the by Administration means what sort of administration is it???

Regards,
Uma

administrator installs and configures database software
for the development environment; creates the various databases
required during the development life-cycle (for example, the data
dictionary, unit testing, system testing, training); and maintains
database access controls. Additionally, this project role provides
consultation on performance; monitors growth and fragmentation of the
development database; and provides database backup and recovery.


The system administrator is responsible for administering a
development system. This project role?s responsibilities include
ensuring hardware is correctly configured; installing, configuring, and
maintaining operating and development software; and ensuring daily
backups of the system are performed. The system administrator
designs and maintains the system?s security; for example, establishing
system accounts.
The system administrator provides first-line support for development
system problems and makes sure faults are quickly rectified. This
project role may perform the set-up and initial maintenance of a
production system or advise the client?s operational staff on these tasks.
The system administrator works with the project team to optimize
system performance.


APPS DBA is mixture of above two

Hi Zeenat Khan,

Thanks and Thats Great...

I would like to know what kind of work can be done by a DBA when the project is Offshore Support in Apps.....

DBA Activities in OFFSHORE PROJECT......


Regards,
Uma

Check Log files on DB, Forms, Apache, Concurrent manger
Check work flow errors.
Release error activity from work flow
Check performance and space usage of the database
Work with application-maintenance to resolve issues
Work with system-maintenance to resolve issues
Participate in projects, or discuss requested changes.
Test and apply patches
Test and install new customizations
Tune concurrent manager
Tune Apache Server

Hi,
Thanks for your valuable inputs.