Back to Search Results

Training Course Summary:

This hands-on technical course is time efficient way to learn the general administrative operations required to support an Oracle database running on Windows NT.

W

Pre-Requisites:

Working knowledge of Windows NT General relational database concepts

Suggested Prerequisites
Windows NT Administration, Basic SQL

Who Should Attend:

NT System Administrators Network Administrators Technical Support Professionals Oracle Database Operators

Training Course Overview/Content:

What is an Oracle database?
The purpose of an Oracle database
Components of an Oracle database
Logical and physical structures of an Oracle database
Storing data in a database

Accessing an Oracle database
SQL and PL/SQL languages

Oracle database operator role
Installing the Oracle Server
Creating an Oracle database
Providing database access to users
Implementing a physical structure for applications
Access to applications data
Loading external data for an Oracle application
Backing up databases for possible recovery
Performing basic performance tuning controls

How to install Oracle database software
Running the setup.exe program from the distribution CD.
Installing the Server, Net8, OEM, Diagnostics pack, Tuning pack and SQL*Plus
Creating an Oracle database
Database Assistant tool
Defining what Oracle files are required, created and opened for an Oracle database
Identifying the directories for various Oracle database files
Defining the services created for an Oracle database

Where to find other important files
Password file
Trace files

Oracle networking and OEM configuration
Network configuration files
Using the Net8 Assistant tool
Net8 configuration files
Creating the OEM repository
Describing the purpose of the Intelligent Agent process
Discovering all Oracle databases in the OEM console navigator

Stop and start an Oracle database
Stopping and starting the database in different modes
Using the Instance Manager to stop and start an Oracle database

Implementing the logical and physical structure for New Applications
Components of an Oracle application
Using the Storage Manager to manage logical & physical structures

Creating Users
Security Manager to manage users
Different categories of users
Creating new users with different functions
Assigning quotas for schema users
Assigning users system privileges and roles

Objects to store application data
Using the Schema Manager, SQL*Worksheet or SQL*Plus tool, and SQL scripts to create objects
Creating tables, clusters, indexes, views, procedures, sequences, and synonyms
Identifying objects that require space
Using the Storage Manager to check free space tablespaces

How to secure application data manipulation
Defining object privileges
Identifying the users responsible for granting object privileges to other users

Why and when to back up databases
Frequency of database backups
Performing full database backups
Automation of periodic full backups

Database Recovery
Different failure scenarios
The archive modes of an Oracle database
Performing a complete recovery
Archiving redo log files to avoid loss of data and reducing recovery time

How to load Non-Oracle Data
Schema Manager
Using the Data Manager to load non-Oracle data into an Oracle database
Automatic data load operations using the OEM job service

Administration issues
Detecting space problems and segments
Avoiding archiving lack of space
Avoiding tracing over-consumption of space

How to solve blocking situations
Defining the reasons for blocked sessions
Using the Lock Manager to detect and release blocked sessions

High-level performance tuning
Oracle Expert for general database tuning
Launching a tuning session and setting up the tuning scope
Collection and analysis of data


Course Objectives

The course is designed for computing professionals such as network and systems administrators who support smaller or departmental databases. This task-based course provides a general knowledge of basic database operation including installing the Oracle server software, creating an Oracle database, implementing applications, managing users, performing general backup and recovery operations, and high level database tuning. Objectives

Install the Oracle server software in a Windows NT environment. Describe the use of an Oracle database. Recognise Oracle databases running on a machine. Create new Oracle databases. Provide access to Oracle databases. Implement