How to become Oracle Apps DBA - Part2

After Reading my first post on “How to Become Oracle Apps DBA” Now its time to understand Roles and Responsibilities of Oracle APPS DBAs.

I am trying to summarize the Roles and Responsibilities of Oracle Apps DBA.  Once you understand R&R of Oracle Apps DBA then you can follow the correct learning path.
  1. Understanding Oracle Application Architecture. You must be familiar with Oracle Applications file system, Login URLs, Single node multi node etc.
  2. Start and Stop (In Real world its called bouncing Oracle applications services: May differ)  -Please check my post on this How to start and shutdown oracle applications
  3. Check if the Oracle applications are working fine (Checking services,Database,Listeners) 
  4. Frequent Application of Security patches, RDBMS Patches, Functional Patches. 
  5. Applying latest releases of the application patches(with/without hot patch option) from Oracle to the instance to resolve few application issues.
  6. Upgrades from lower version of oracle application and databases to higher versions
  7. You MUST be familiar with all AD utilities. More you know these utilities a better DBA you are.  What are AD utilities in Oracle Apps
  8. You should know about the OATM (Oracle application tablespace Model) Management and OATM conversion.
  9. JDK upgrade and Jinitiator upgrades. Sun JRE in R12
  10. In Depth Pre Patching Analysis
  11. Cloning the instances regularly using RAPID CLONE.
  12. Database refresh (You must be familiar with Profile options and Profile Values)
  13. Creation of users and responsibilities
  14. Troubleshooting  of concurrent manager, concurrent requests related issues
  15. Work Flow Mailer configuration and trouble shooting
  16. Miscellaneous tasks such as printer related issues, scheduler tasks etc
  17. Regular use of adadmin activity for various maintenance tasks.
  18. Regular Usage of Utilities like FNDLOAD, WFLOAD, f60gen, adctrl, adpatch.
  19. Running Autoconfig and also fixing autoconfig related issues
  20. Code migrations
  21. Liaison with Oracle Support to resolve various application and database issues.
  22. Configuring and troubleshooting mobile server Applications
  23. Performance Tuning -resizing init.ora parameters for various performance issues.
  24. If you have technical and functional knowledge in Business , Then its Extra Advantage.
  25. You will work with lot of 3rd party products with Oracle Applications. Please refer to my post  List of third party software for Oracle apps
More coming : Next suggested read is How to become Oracle Apps DBA - Part3

1 comment:

  1. Hi
    This is syed here.I would like to know as a Apps DBA how many server can handle in real time envirnment