Oracle Database 10g: Administration I

This course has been superseded

We suggest the following instead:
Oracle Database Administration Course

Course Description

The overall objective of this course is to allow the participant to gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting for Oracle database administrators and also sets the foundation for advanced administrator training and certification.

View other Oracle Courses available
5 days
€2195.00
 

Prerequisites

Mandatory prerequisites for this course: ORACLE DATABASE 10G: INTRODUCTION TO SQL – COMPLETE LIBRARY,ORACLE DATABASE 10G: PROGRAM WITH PL/SQL – PART II

INSTALLING ORACLE 10G DATABASE SOFTWARE

• identify database system requirements
• the optimal flexible architecture (ofa)
• configure the installation environment
• installation using the universal installer
• more about enterprise manager

EXPLORING THE ORACLE DATABASE ARCHITECTURE

• general database architecture
• database instance memory architecture

DATABASE INSTANCE PROCESS ARCHITECTURE

• about the instance process architecture
• instance background processes
• sql execution processes

CREATING AN ORACLE DATABASE

• create a database
• configure & drop a database
• manage dbca templates
• manually creating a database

CONTROLLING THE DATABASE ENVIRONMENT

• starting & stopping database control
• starting & stopping isql*plus
• starting & stopping the database listener
• starting & stopping the database
• more about the database files
• handling parameter files & parameter settings

STORAGE STRUCTURES: TABLESPACES

• about tablespaces
• tablespace management

STORAGE STRUCTURES: ADVANCED TABLESPACES

• more about temporary tablespaces
• about temporary tablespace groups
• more about permanent tablespaces
• more about bigfile tablespaces
• more about the sysaux tablespace

STORAGE STRUCTURES: DATA FILES & TEMP FILES

• managing data files
• managing temp files
• about oracle-managed files (omf)

UNDO MANAGEMENT

• about undo space management
• configure undo management
• guarantee undo retention
• monitor undo space
• use the undo advisor

DATABASE SECURITY

• database system privileges
• database object privileges
• audit database activity
• register for security updates

ADMINISTERING USERS

• create & manage database accounts
• grant & revoke database privileges
• resource limits via profiles
• password management via profiles
• about role-based security

MANAGING DATA: LOADING DATA WITH SQL LOADER

• about the database utilities
• using the loader
• understanding the loader process
• control file options • direct path loads

MANAGING DATA: EXPORTING & IMPORTING DATA

• create directory objects
• expdp
• impdp oracle net services
• what is oracle net services?
• oracle net manager
• listener configuration
• listener administration
• lsnrctl commands
• configuring client parameters
• isolating the problem
• oracle trace assistant
• network troubleshooting utilities

ORACLE SHARED SERVERS

• shared servers architecture
• configuration of shared server mode

MONITORING & RESOLVING LOCK CONFLICTS

• about latches & locks
• more about latches
• more about locks

BACKUP & RECOVERY CONCEPTS

• about database backup & recovery
• about redo data
• redo log file maintenance
• managing the archive options
• more about the control file

ISTQB Technical Test AnalystOracleOracle 10gOracle Database 10g