Oracle database administration
This presentation is the property of its rightful owner.
Sponsored Links
1 / 25

Oracle Database Administration PowerPoint PPT Presentation


  • 100 Views
  • Uploaded on
  • Presentation posted in: General

Oracle Database Administration. course objective. After completing this course you should be able to: administrate an Oracle DB configure the DB for an application employ basic monitoring procedure implement a backup and recovery procedure. DBA Course Info. Website

Download Presentation

Oracle Database Administration

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Oracle database administration

Oracle Database Administration


Course objective

course objective

After completing this course you should be able to:

  • administrate an Oracle DB

  • configure the DB for an application

  • employ basic monitoring procedure

  • implement a backup and recovery procedure

Rana Almurshed


Dba course info

DBA Course Info

  • Website

    • http://331IT.wordpress.com/

  • Reference books

    • Oracle Database 11g DBA Handbook

    • Beginning Oracle Database 11g Administration: From Novice to Professional

  • DBA grades

    • Evaluation 5%

    • Final lab 5%

Rana Almurshed


Outline

Outline

  • Learn about Database administration

    • Database administration

    • Database administrator

      • Task, Role, Skills…

  • Identify the main DBA tools in the Oracle10g software suite

Rana Almurshed


Database administration

Database Administration


Managing the data is crucial

Managing the Data is crucial

Rana Almurshed


Database administration1

Database Administration

  • Database Administration: A technical function that is responsible for physical database design and for dealing with technical issues such as security enforcement, database performance, and backup and recovery

Rana Almurshed


Database administration2

Database Administration

  • Database Administration

    • Size and Role varies from company to company

    • DBA’s function is very dynamic

      • Distributed Databases

      • Internet Databases

      • Object Oriented databases

      • Sophistication and Power of the DBMS packages

Rana Almurshed


Oracle database administration

DBA

  • A database administrator (DBA) is a person responsible for the design, implementation, maintenance and repair of an organization's database.

Rana Almurshed


Dba tasks

DBA tasks

  • Install and upgrade the DBMS software on the server

  • Optimize database performance

  • Create and maintain user accounts

  • Monitor data storage space

  • Start and shut down the database

  • Perform backup and recovery operations

Rana Almurshed


Dba tasks1

DBA tasks

  • Install and upgrade developer client utilities

  • Deploy finished database applications to users

  • Assist developers in designing and creating database tables

  • Assist developers in designing and creating form and report components and integrated database applications

  • Assist in testing and debugging new applications

  • Assist in training developers and users

Rana Almurshed


Dba role

DBA Role

Liaison with:

  • Management

    • enterprise objectives

    • time constraints for development

    • budget constraints

    • future plans

    • organizational changes

Rana Almurshed


Dba role1

DBA Role

Liaison with:

  • Users

    • data requirements

    • application priorities

    • ownership of data

    • archiving requirements

    • documentation

    • response times

Rana Almurshed


Dba role2

DBA Role

Liaison with:

  • Application Development Staff

    • security/privacy controls

    • education/training

    • data integrity rules

    • housekeeping programs

    • information about the database

    • test plans etc.

Rana Almurshed


Dba role3

DBA Role

Liaison with:

  • Operations Staff

    • availability requirements

    • batch job priorities

    • security procedures

    • error recovery requirements

    • performance monitoring etc.

Rana Almurshed


Dba role4

DBA Role

Liaison with:

  • Software Vendors

    • Education/training needs

    • Hardware requirements

    • documentation

    • service support & maintenance

    • utilities etc.

Rana Almurshed


Dba role5

DBA Role

Liaison with:

  • Hardware Vendors

    • hardware capabilities

    • expansion capability

    • incompatibility with any existing hardware

    • servicing requirements

    • training

    • equipment failure

Rana Almurshed


Knowledge and skills

Knowledge and Skills

  • DBAs :

    • keep up with the complexities of database technologies

    • have well-developed interpersonal and communication skills

    • have an ability to understand data and how it will be used

    • possess good process management and problem solving skills

    • enjoy working within a team

Rana Almurshed


Knowledge and skills1

Knowledge and Skills

  • DBAs :

    • are customer focused

    • enjoy troubleshooting

    • are critical thinkers and can use logic and reason to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems

    • are active listeners and can give full attention to what people are saying and take the time to understand the points being made

Rana Almurshed


Dbas possess good problem solving skills

DBAs possess good problem solving skills

Rana Almurshed


Dba tools in the oracle10 g

DBA tools in the Oracle10g


Oracle10g

Oracle10g

  • The Oracle10g RDBMS software suite includes everything you need to build/maintain a relational DB

  • The basic software:

    • Runs the database engine

    • Manages the data storage for all information in the database

    • Provides tools to manage users, tables, data integrity, backups, and basic data entry

    • Includes additional tools and utilities that help monitor the performance and security of the database

Rana Almurshed


Overview of dba tools

Overview of DBA Tools

  • Many of these tools become integrated in:

    • Central workspace

    • Enterprise Manager console

    • Database Control

    • Grid Control

  • Tools give you a way to work on the database

    • In a Windows-style environment

  • You must also understand how to work directly from the command line

Rana Almurshed


Tools for administering an oracle database

Tools for Administering an Oracle Database

  • Oracle Universal Installer

  • Database Configuration Assistant

  • Database Upgrade Assistant

  • Oracle Net Manager

  • Oracle Net Configuration Assistant

  • Oracle Enterprise Manager

  • Server Control Utility

  • SQL *Plus

  • Recovery Manager

  • Data Pump

  • SQL *Loader

Rana Almurshed


References

References

  • http://en.wikipedia.org/wiki/Database_administrator

  • http://www.acs.org.au/ictcareers/index.cfm?action=show&conID=200707200948211895

  • Oracle 10g Database Administrator: Implementation and Administration

  • Modern Database Management

  • Database Administration

  • A Guide to Oracle 9i

  • Database Users & Administration

  • Oracle 11g Student Guide

Rana Almurshed


  • Login