You are here:

Oracle/Working with Oracle Database

Advertisement


Question
QUESTION: I have just started working with Oracle Database and Oracle EBS application and I have 7 months of experience. So I would like to enhance my skills and be able to master DBA activities so what should I do if I want to be a good DBA?

ANSWER: Hi Daniel,

Welcome to the world of Oracle! The work of a DBA is never ending, and can touch various areas within the System development life cycle (SDLC) (e.g. from concept, design, to implementation).

There are 2 things that you would need to keep in mind: Oracle database administration, and how Oracle EBS interacts with the DB.

To learn about the Oracle DB: there is a several free refernece from Oracle:
- Database Concepts: http://www.oracle.com/pls/db112/to_toc?pathname=server.112/e25789/toc.htm
- 2-Day DBA: http://docs.oracle.com/cd/E11882_01/server.112/e10897/toc.htm

Some more advance reading and information:
- Adminsitrator's Guide: http://www.oracle.com/pls/db112/to_toc?pathname=server.112/e25494/toc.htm
- Refernce: http://www.oracle.com/pls/db112/to_toc?pathname=server.112/e25513/toc.htm
- Performance Tuning: http://www.oracle.com/pls/db112/to_toc?pathname=server.112/e16638/toc.htm

Understanding how EBS works
- EBS Developer's Guide: http://docs.oracle.com/cd/E18727_01/doc.121/e12897/toc.htm
- EBS System's Administrator Guide-Configuration: http://docs.oracle.com/cd/E18727_01/doc.121/e12893/toc.htm
- EBS Concepts: http://docs.oracle.com/cd/E18727_01/doc.121/e12841/toc.htm

Hopefully this information will be able to help you get a head start in your new guest to explore and learn more abou Oracle!

Peter


---------- FOLLOW-UP ----------

QUESTION: Thanks alot with the answer I received. And next year I want to write Oracle DBA certification exams but I don't have any study materials, where can I find the study materials?

Answer
Hi Daniel,

Sybex publishes a single OCA/OCP kit or 2 separate books (OCA AND OCP) that you can use as a study guide.

http://ca.wiley.com/WileyCDA/Section/id-610886.html?sort=DATE&sortDirection=DESC

There are also a number of courses that you can take in your locale through an authorized Oracle education location or some colleges/university also offer the courses with the OCA/OCP exam at the end of the session.

I hope this helps.

Peter

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Peter Choi

Expertise

I am a senior Oracle DBA, PeopleSoft HCM specialist and Project Manager with 15+ years experience. I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i - 11gR1). I also have experience with the configuration and administration of PeopleSoft's Internet Architecture (PIA) and the Oracle 11g Fusion Middleware and Oracle Business Intelligence (OBI).

©2016 About.com. All rights reserved.