How to become Oracle Apps DBA - Part2

After Reading my first post on “How to Become Oracle Apps DBA” http://oracleinout.blogspot.com/2010/05/how-to-become-oracle-apps-dba-part1.html. 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

http://oracleinout.blogspot.com/2010/05/how-to-become-oracle-apps-dba-part3.html