70 likes | 236 Views
DBA Topics. Duties, Certification, Resources, and Tools. Database administration. Job duties/tasks (and frequencies) Certification and training Dba scripts and resources DBA utilities SQL*Loader, Export/Import, RMAN, OEM. DBA resources. TONS of lists available (usually very active)
E N D
DBA Topics Duties, Certification, Resources, and Tools
Database administration • Job duties/tasks (and frequencies) • Certification and training • Dba scripts and resources • DBA utilities • SQL*Loader, Export/Import, RMAN, OEM
DBA resources • TONS of lists available (usually very active) • Oracle support – http://metalink.oracle.com • Oracle Technology Network - http://technet.oracle.com/ • Oracle Underground Frequently Asked Questions - http://www.orafaq.com/faq2.htm • DBA FAQ by Kevin Loney - http://www.kevinloney.com/freebies.htm
DBA scripts and resources • The Database Domain's Oracle Tips Page - http://www.dbdomain.com/tips.htm • Oracle Magazine (Tips 2000 and Code Archive) http://www.oracle.com/oramag/oracle/current.html • IToolbox Portal for Oracle - http://oracle.ittoolbox.com/ • User groups! • NCOUG • IOUGA
Oracle consultants • RevealNet Home Page - http://www.revealnet.com/ • http://www.quest-pipelines.com/Pipelines/DBA/archives.htm • Oracle performance tuning = Ixora - http://www.ixora.com.au/home.htm • Jeff Hunter - http://www.idevelopment.info/ • Steve Rea's Oracle Tips, Tricks, and Scripts - http://www.uaex.edu/srea/
Certification • Several tracks • DBA, Developer, Database operator • 9i certifications introduced Associate, Professional and Master levels • Oracle University • http://www.oracle.com/education/certification/ • Study guides, practice exams
DBA Utilities • Oracle error message facility - http://www.desy.de/cgi-bin/oerr • Oracle Enterprise Manager and DBA Studio • SQL*Loader, Export/Import • RMAN • Lots more!