TruTek

This class covers:
- Installing the Oracle Database software and creating a database
- Using Enterprise Manager Database Control to manage the database
- Configuring and managing the Oracle Network environment
- Installing Oracle Database 10g
- Upgrading the Database
- Performing Post Migration Tasks
- Managing the Database with Enterprise Manager Database Control
- Controlling the Instance
- Maintaining the Database
- Managing Resources
- Automating Tasks using the Scheduler
- Managing Memory Structures
- Managing Database Storage Structures
- Using Automatic Storage Management (ASM)
- Managing Undo
- Administering Users
- Managing Schema Objects
- Backing Up and Recovering the Database

Return to top

Course Topics:
Planning Your Upgrade to Oracle Database 10g
Supported upgrade paths to Oracle Database 10g
Planning the upgrade

Installing Oracle Database 10g
Installing Oracle Database 10g software
Use the Database Configuration Assistant to create a database

Upgrading Your Database to Oracle Database 10g
Using Database Upgrade Assistant (DBUA)
Using the manual upgrade method
Using Export and Import to upgrade

Performing Post-Upgrade Steps
Upgrading Server Manager scripts to work in SQL*Plus
Performing additional upgrade tasks

Using Enterprise Manager: Database Control
Starting the Enterprise Manager dbconsole process
Accessing Enterprise Manager Database Control
Navigating in Enterprise Manager Database Control
Granting Enterprise Manager Administrative Privileges

Controlling the Instance and Access to the Database
Using the Server Parameter file (SPFILE) to Configure Initialization Parameters
Quiescing the Database
Dropping the Database

Managing Oracle Net Services
Using New Tools to Manage Oracle Net Services
Connecting using the easy connect method
Exporting Directory Naming Entries
Using New Features of the Shared Server Configuration

Proactively Maintaining the Database
Defining AWR Snapshot Baselines
Subscribing Applications to Server-Generated Alerts
Using the Automatic Database Diagnostic Monitor (ADDM)

Managing Resources
Using New Features of the Database Resource Manager

Automating Tasks with the Scheduler
Using the Scheduler to Perform Database Administration Tasks
Creating a Job, Program, Schedule, and Window
Reusing Scheduler Components for Similar Tasks
Viewing Information about Job Executions

Managing Memory Structures
Using Automatic Shared Memory Tuning
Configuring Automatic PGA Memory Management
Modifying Initialization Parameters for Memory Components

Managing Database Storage Structures
Specifying a Default User Tablespace
Creating Bigfile Tablespaces
Creating a Default Temporary Tablespace
Creating Temporary Tablespace Groups
Renaming Tablespaces
Using the Redo Logfile Sizing Advisor

Implementing Automatic Storage Management (ASM)
Creating ASM Instance
Setting Up Initialization Parameter Files for ASM
Executing SQL Commands with ASM File Names
Starting up and shutting down ASM instances
Administering ASM disk groups
Using RMAN to Migrate the Database to ASM

Managing Undo
Configuring the Database for Automatic Undo Management
Monitoring Undo Usage
Converting from Manual Rollback to Automatic Undo
Using the Undo Advisor

Administering Users and Database Security
Unlocking Default User Accounts
Setting a Single Password for System Users
Using fine-grained auditing
Auditing Administrative Users

Managing Schema Objects
Configure Automatic Segment-Space Management
Estimating Table and Index Size
Performing Online Redefinition of Tables
Enabling Automatic Statistics Collection
Using the Segment Advisor
Enabling Resumable Space Allocation
Managing database storage structures
Administering users and security
Managing schema objects
Backing up and recovering the Oracle database
Monitoring the database and using the Advisors
Updating Oracle software with patch releases
Tuning the database

Return to top

Course Topics:
Overview of Oracle Database Administration
Overview of the Oracle Instance and Database
Tasks of an Oracle Database Administrator
Tools Used to Administer an Oracle Database

Installing Oracle Software and Creating the Database
Using the Oracle Universal Installer (OUI)
Installation Pre-requisites
Installing the Oracle Software
Using the Database Configuration Assistant (DBCA) to Create a Database
Using DBCA to Manage Templates
Using DBCA to Add Options to Your Database

Using Oracle Enterprise Manager Database Control and SQL*Plus
Overview of Administering the Database Using Enterprise Manager (EM)
Starting the EM Database Console
Enterprise Manager Navigation
Granting EM Administrative Privileges
Using SQL*Plus and iSQL*Plus to Access Your Database

Configuring the Oracle Network Environment
Network Configuration Overview
Oracle Net Listener Configuration and Management
Oracle Net Naming Methods
Tools for Configuring and Managing the Oracle Network

Managing the Oracle Instance
Oracle Instance and Instance Management
Accessing the Oracle Database
Initialization Parameters and Password File
Starting Up and Shutting Down the Instance
Viewing the Alert Log and Trace Files

Managing Database Storage Structures
Oracle Database Structures
Creating a New Tablespace
Managing Undo and Using the Undo Advisor
Multiplexing the Redo Log File

Administering Users and Security
Overview of Users and Security
Creating and Administering Users
Locking and Unlocking Accounts
Setting Passwords
Administering Privileges and Roles

Managing Schema Objects
Creating Schema Objects
Creating and Modifying Tables
Understanding Data Integrity and Defining Constraints
Viewing the Attributes and Contents of a Table
Creating Indexes and Views
Loading Data

Performing Backup and Recovery
Backup, Restore and Recovery Concepts
Configuring the Database for Backup and Recovery
Configuring Backup Settings
Backing Up the Database Using EM
Whole Database Backups
Oracle-Suggested Backup Strategy
Restoring and Recovering the Whole Database

Monitoring and Tuning the Database
Monitoring the Oracle Database
Self-Monitoring Architecture
Monitoring and Tuning Usage Model
Using the Advisors