Courses

oracle 10g dba training

Course Content - Course Duration - 60hrs

1.Introduction

  • Identify the oracle product

2.Installing oracle database 10g software

  • System requirements.
  • Redhat Linux Installation
  • Install software with the Oracle Universal Installer on Linux Platform

3.Create an oracle database

  • Oracle Database Architecture
  • Oracle instance architecture
  • Oracle Read Consistency and Concurrency

4.Controlling the database

  • Start and stop the enterprise manager database console
  • Start and stop the listener
  • Startup and shutdown the database

5.Database Creation

  • Manual
  • Database Configuration Assistant(DBCA)

6.Storage Structures

  • Logical structure Vs Physical structure
  • Defining the tablespaces and data files
  • Create tablespaces
  • Manage tablespaces
  • Obtain tablespace information
  • Managing Undo Data

7.File Management

  • Control File Management
  • Redo Log File Management
  • Parameter File Management
  • Obtain tablespace information

8.Administering users

  • Create and manage database user accounts
  • Roles
  • Privileges
  • Control resource usage by using Profiles

9.Oracle Net Services

  • Understand Oracle Net concepts
  • Use Oracle Net Manager to create and configure listeners
  • Use the listener control utility to control the Oracle Net Listener
  • Testing Oracle Net connectivity
  • Shared Server: Connection pooling

10.Managing schema objects

  • Create and modify tables
  • Define constraints
  • View the attributes of a table
  • View the contents of a table
  • Create indexes and views

11.Oracle Backup & Recovery (User Managed)

  • Introduction
  • Design, Testing, Implementation Strategies
  • Offline(cold)/Online(hot) backups
  • Performing Complete Recovery
  • Performing Incomplete Recovery

12.Oracle Backup & Recovery (System Managed: RMAN)

  • Introduction
  • RMAN Architecture
  • Configuration
  • Setting up Catalog
  • Online/Offline Backup using RMAN
  • Backups Options
  • Incremental Backups
  • Image copies
  • Scripts,
  • Complete Recovery
  • Incomplete Recovery
  • Table Space Point in Time Recovery (TSPITR)
  • Disaster Recovery

13.Cloning

  • RMAN
  • Manual

14.Logical Backup & Transporting data between databases

  • Introduction Data pump (expdp, impdp) Utilities
  • Exporting/Importing Tables
  • Exporting/Importing Schemas
  • Exporting/Importing Table space
  • Exporting/Importing Database
  • Transportable Table space within & across the database and platforms

15.High Availability(HA)

  • Database Patch Management Introduction
  • Applying Interim and Patch set Patches
  • Patch History & Documentation

16.Proactive Maintenance

  • Contents
  • Optimizer statistics
  • Automatic Workload Repository

17.Flashback

  • Introduction
  • Configuration
  • Flashback Query/Table/Drop/Database
  • Flashback Version Query
  • Creating Restore Points 

18.Automatic Storage Management

19.Oracle Grid Control

  • Introduction
  • Architecture
  • Managing the multiple database nodes using OEM grid control

 

live Chat