Transcript Oracle Database Administration - 331 IT

Oracle Database Administration
course objective
After completing this course you should be able to:




install, create and administrate an Oracle DB
configure the DB for an application
employ basic monitoring procedure
implement a backup and recovery procedure
CAP 364
Rana Almurshed
2
DBA Course Info

Website


Reference books



http://331IT.wordpress.com/
Oracle Database 11g DBA Handbook
Beginning Oracle Database 11g Administration: From Novice to
Professional
DBA grades


CAP 364
Evaluation 5%
Final lab 5%
Rana Almurshed
3
Outline

Learn about Database administration


Database administration
Database administrator


CAP 364
Task, Role, Skills…
Identify the main DBA tools in the Oracle10g
software suite
Rana Almurshed
4
Database Administration
Managing the Data is crucial
IT 331
Rana Almurshed
6
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
CAP 364
Rana Almurshed
7
Database Administration

Database Administration


Size and Role varies from company to company
DBA’s function is very dynamic




CAP 364
Distributed Databases
Internet Databases
Object Oriented databases
Sophistication and Power of the DBMS packages
Rana Almurshed
8
DBA

A database administrator (DBA) is a person
responsible for the design, implementation,
maintenance and repair of an organization's database.
CAP 364
Rana Almurshed
9
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
CAP 364
Rana Almurshed
10
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
CAP 364
Rana Almurshed
11
DBA Role
Liaison with:

Management





CAP 364
enterprise objectives
time constraints for development
budget constraints
future plans
organizational changes
Rana Almurshed
12
DBA Role
Liaison with:

Users






CAP 364
data requirements
application priorities
ownership of data
archiving requirements
documentation
response times
Rana Almurshed
13
DBA Role
Liaison with:

Application Development Staff






CAP 364
security/privacy controls
education/training
data integrity rules
housekeeping programs
information about the database
test plans etc.
Rana Almurshed
14
DBA Role
Liaison with:

Operations Staff





CAP 364
availability requirements
batch job priorities
security procedures
error recovery requirements
performance monitoring etc.
Rana Almurshed
15
DBA Role
Liaison with:

Software Vendors





CAP 364
Education/training needs
Hardware requirements
documentation
service support & maintenance
utilities etc.
Rana Almurshed
16
DBA Role
Liaison with:

Hardware Vendors






CAP 364
hardware capabilities
expansion capability
incompatibility with any existing
hardware
servicing requirements
training
equipment failure
Rana Almurshed
17
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
CAP 364
Rana Almurshed
18
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
CAP 364
Rana Almurshed
19
DBAs possess good problem solving
skills
IT 331
Rana Almurshed
20
DBA tools in the Oracle10g
Oracle10g

The Oracle10g RDBMS software suite includes
everything you need to build/maintain a relational
DB

The basic software:




CAP 364
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
22
Overview of DBA Tools

Many of these tools become integrated in:





Tools give you a way to work on the database


CAP 364
Central workspace
Enterprise Manager console
Database Control
Grid Control
In a Windows-style environment
You must also understand how to work directly
from the command line
Rana Almurshed
23
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
CAP 364
Rana Almurshed
24
References








http://en.wikipedia.org/wiki/Database_administrator
http://www.acs.org.au/ictcareers/index.cfm?action=show&con
ID=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
CAP 364
Rana Almurshed
25