Oracle 8i/9i Database Administration

AUDIENCE: This course is for support staff who need to be able to provide the day to day administration of an Oracle 9i based system. The course is also relevant to Oracle 8i installations.
PREREQUISITES: The participant should have a strong understanding of using an Oracle based system, good knowledge of SQL*Plus and (preferably) PL/SQL, or previous attendance of the Oracle SQL and PL/SQL courses, or their equivalents from other training providers.
DURATION: 5 days. Hands on.
OBJECTIVES: This course provides students with the skills to describe the architecture of an Oracle system and the creation, maintenance and configuration of databases. Students will also gain the ability to administer users, perform backups, recover a database, use the data and design distributed databases. It is highly interactive and consists of theory coupled with plenty of hands on practical sessions. On completion the delegate will understand the responsibilities of a DBA and be able to perform the tasks associated with this role. Delegates will be provided with the skills to describe the architecture of an Oracle system and the creation, maintenance and configuration of databases. They will also gain the practical experience to administer users, roles and privileges, perform both cold and online backups and fully recover a damaged database.
COURSE CONTENT:
Overview Of Oracle

Database Creation, Startup and Shutdown
Initialisation file
Database creation
Database startup
Database shutdown
Alert log
Exercise and quiz

SGA and Background Processes
Introduction
Buffer cache
Redo log buffer
Shared pool
Program global area
Background processes
Transaction processing

Tablespaces
Design considerations
Tablespace creation
Locally managed tablespaces
Table creation
Constraints

Internal and External Files
Datafiles, segments
Rollback segments
Control files
Redo logs
Checkpoint processing
Archiving REDO logs

Performance Issues
Rollback segments
Lock & users
Sorts
Redo log buffer
Buffer cache
Shared pool
Disk I/O
UTLBSTAT & UTLESTAT

Users, Roles and Profiles
User creation
Profiles
System privileges
Object privileges
Roles
Auditing

Backup and Recovery
Cause of data loss
Structures used
Offline backups
Archiving redo logs
Online backups
Complete recovery
Incomplete recovery

Networking and NET*8
Client/Server architecure
Net*
TNSNAMES.ORA / LISTENER.ORA

Oracle Utilities
Export
Import
SQL Loader

PPJ07/01