Oracle Database 11g Release 2 DBA using Enterprise Manager

Level:
Costs:
Total time:
Provider rating: 10 Perpetual Solutions has an average rating of 10 (out of 1 reviews)
Logo Perpetual Solutions

Tip: Receive more information about the programme, starting dates & price. Or request a proposal from multiple providers for in-house training.

Overview

Your experience of this course?

Did you attend the course Oracle Database 11g Release 2 DBA using Enterprise Manager at Perpetual Solutions? Help other people by submitting your review at Springest!

Springest will donate £1.- to the Edukans Foundation as a thank you for each review

 
Schedule:
Daytime
Run time:
2 Days
Location type:
Open

completion, maximum participants, and starting dateplaces are unknown for this course.

Prerequisites:

Delegates should have an understanding of relational database concepts and basic operating system knowledge. They should also have a working knowledge of Oracle SQL*Plus, this can be gained by attendance on the pre-requisite course.

Course Description:

This course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 11g Release 1 or 2.The course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks.This course is not aimed at delegates who are full time Database Administrators.Full time Database Administrators should at…

Read the complete description

Description

Prerequisites:

Delegates should have an understanding of relational database concepts and basic operating system knowledge. They should also have a working knowledge of Oracle SQL*Plus, this can be gained by attendance on the pre-requisite course.

Course Description:

This course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 11g Release 1 or 2.The course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks.This course is not aimed at delegates who are full time Database Administrators.Full time Database Administrators should attend the Oracle Database 11g DBA - Part I and Oracle Database 11g DBA - Part II courses.

This course aims to give delegates practical experience in installing Oracle Database 11g Release 1 or2software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks. The focus is on using Enterprise Manager to teach delegates how to carry out basic management of the database.

The delegate will practice:

  • Installing Oracle Database 11g Software
  • Creating an Oracle database
  • Administering an Oracle database with Enterprise Manager
  • Configuring the Oracle Network Environment
  • Creating and Managing Database Storage Structures
  • Managing Schema Objects
  • Managing Users
  • Maintaining Database Security
  • Backing up, Restoring and Recovering the Database
  • Monitoring the Performance of the Database Using Advisors

This course includes the following modules:

Introduction

  • Oracle product overview
  • Oracle Support services
  • Relational database concepts
  • Oracle architecture
  • Database administration tasks
  • Database administration tools

Installing and Configuring an Oracle Database

  • Understand system requirements
  • Use Oracle Universal Installer to install Oracle software (OUI)
  • Create a database using Database Configuration Assistant (DBCA)
  • Delete a database using DBCA
  • Use DBCA to manage templates
  • Upgrade a database using Database Upgrade Assistant (DBUA)

Administer a Database

  • Administrative tools available to a DBA
  • Use SQL*Plus and SQL Developer to manage a database
  • Administer the database using Enterprise Manager (EM)
  • Start and stop the EM Database Console
  • EM navigation
  • Grant EM administrative privileges to a user

Configure the Oracle Network Environment

  • Overview of network configuration
  • Oracle Net Listener configuration and management
  • Oracle Net Naming methods
  • Tools for configuring and managing the Oracle network
  • Configure local naming for client connections with Net Manager
  • Start and stop the Oracle listener
  • Configure the listener with EM
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database

Oracle Instance

  • Instance management
  • Memory structures
  • Background processes
  • Access an Oracle database
  • Initialization parameters
  • Password file
  • Shutdown the database
  • Startup the database
  • View alert log and trace files

Database Storage Structures

  • Oracle database structures
  • Control files
  • Redo log and archive redo log files
  • Tablespaces and data files
  • Create tablespaces
  • Manage tablespaces
  • Manage undo and use the Undo Advisor
  • Use EM to view the storage structure of the database

Manage Users

  • Database administration accounts
  • User accounts
  • Create and administer user accounts
  • Lock and unlock user accounts
  • Change a user's password
  • Administer privileges and roles

Manage Schema Objects

  • Create schema objects
  • Create a new table
  • View the attributes and contents of a table
  • Understand data integrity
  • Define constraints
  • Create indexes
  • View index attributes
  • Create views
  • Create synonyms
  • Create sequences

Backup, Recover and Restore a Database

  • Oracle backup strategy
  • Overview of backup, restore and recovery
  • Backup and recovery configuration
  • Configure ARCHIVELOG mode
  • Backup and recover the database using EM
  • Schedule backups
  • Configure backup settings
  • Configure recovery settings
  • Configure catalog settings
  • Perform recovery

Performance Monitoring

  • Self-monitoring architecture
  • Monitor an Oracle database
  • Automatic Workload Repository
  • Automatic Database Diagnostics Monitor (ADDM)
  • Use the advisors
  • Set up notification rules
  • Conclusion

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

Reviews

There are no reviews yet. Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

In-company offer

Ask for a quote on a customised training course.
Maximum 3 relevant providers will directly respond.

More courses within this subject:

Compare 35,998 training courses in subjects like Oracle 11G

Subscribe to our newsletter?

Receive news, tips, articles, interviews and education on personal development each month.

Sign up to create your own Learning Lists.

Not for humans