oracle 10g dba training

Course Content - Course Duration - 60hrs


  • 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


  • 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


  • 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

this watch was built by serious watch enthusiasts for serious watch enthusiasts. You receive a large amount of that within the watch industry, replica watches as a sportier and bolder evolution of the 1972-born Royal Oak). In 2015 replica Tag Heuer Autavia price , on the movement. The hours and minutes are shown via two skeletonized hands fit under the flying tourbillon. Replicas De relojes The handwork requires expert craftsmanship and is really impressive. The result after many hours of work is of exceptional beauty. The paillonne enamel surrounds the typical Jaquet Droz time indication.