Oracle Database 11g Administration Workshop 1 Training institute in Chennai SQL STAR

Oracle Database 11g: Administration Workshop I Release 2

This Database 11g Administration training gives you a firm foundation in basic database administration, including how to install and maintain an Oracle database. Learn about architecture and how the database components work and interact.
Learn ToThis Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

• Install Oracle Grid Infrastructure.
• Create and manage Users.
• Install and configure an Oracle Database.
• Create and manage storage structures.
• Administer the Oracle Database.
• Understand the Oracle database architecture and how its components work and interact with one another.
• Perform backup and recovery.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Create an Operational Database

You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, User management and backup/recovery techniques.

Training Requirements

This Oracle Database 11g: Administration Workshop I Release 2 course fulfills the training requirement for an Oracle Certification Path. Only instructor-led online (LVC, LWC), in-class (ILT) or Training On Demand courses fulfill the requirement. Please note that Self-Study Courses and Knowledge Center courses do not fulfill the training requirement.

Prerequisites
Suggested Prerequisite

• Taken Oracle Introduction to SQL course or equivalent experience
• Taken Oracle PL/SQL course or equivalent experience

Audience

• Database Administrators
• Java Developers
• Support Engineer
• Technical Consultant
• Technical Administrator

Course Objectives

• Install Oracle Grid Infrastructure
• Install and configure Oracle Database 11g
• Configure Oracle Net services
• Monitor and administer undo data
• Manage the database storage structures
• Create and administer User accounts
• Perform basic backup and recovery of a database
• Manage data concurrency
• Monitor performance
• Describe Oracle Database Architecture
  Course Topics

Exploring the Oracle Database Architecture

• ASM storage components
• Logical and physical storage structures
• Oracle Database Architecture Overview
• Oracle ASM Architecture Overview
• Process Architecture
• Memory structrues

Installing your Oracle Software

• Oracle Universal Installer (OUI)
• Installation: System Requirements
• Tools Used to Administer an Oracle Database
• Installing Oracle Grid Infrastructure
• Installing Oracle Database Software
• Tasks of an Oracle Database Administrator
• Silent Install

Creating an Oracle Database

• Planning the Database
• Password Management
• Using the DBCA to Create a Database
• Creating a Database Design Template
• Using the DBCA to Delete a Database

Managing the Oracle Database Instance

• Modify database installation parameters
• Describe database shutdown options
• Use Oracle Enterprise Manager
• Describe the stages of database startup
• Start and stop the Oracle database and components
• Access a database with SQLPlus
• View the alert log
• Access dynamic performance views

Manage the ASM Instance

• Set up initialization parameter files for ASM instance
• Administer ASM disk groups
• Start up and shut down ASM instances

Configuring the Oracle Network Environment

• Use Enterprise Manager to create and configure the Listener
• Identify when to use shared servers and when to use dedicated servers
• Enable Oracle Restart to monitor the listener
• Use tnsping to test Oracle Net connectivity

Managing Database Storage Structures

• Oracle Manage d Files (OMF)
• Storage Structures
• Table spaces in the Preconfigured Database
• Space Management in Table spaces
• Actions with Table spaces
• How Table Data Is Stored
• Anatomy of a Database Block

Administering User Security

• Benefits of Roles
• Predefined Administrative Accounts
• Implementing Profiles
• Predefined Roles
• Database User Accounts

Managing Data Concurrency

• Resolving Lock Conflicts
• Data Concurrency
• Deadlocks
• Enqueue Mechanism

Managing Undo Data

• Undo Data Versus Redo Data
• Data Manipulation
• Transactions and Undo Data
• Configuring Undo Retention

Implementing Oracle Database Auditing

• Enable standard database auditing
• Describe DBA responsibilities for security
• Review audit information
• Maintain the audit trail
• Specify audit options

Database Maintenance

• Use server-generated alerts
• Use automated tasks
• Manage the Automatic Workload Repository (AWR)
• Set alert thresholds
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Describe and use the advisory framework
• Manage optimizer statistics

Performance Management

• Performance Monitoring
• Dynamic Performance Statistics
• Enabling Automatic Memory Management (AMM)
• Automatic Shared Memory Advisor
• Using Memory Advisors
• Trouble shooting and Tuning Views
• Invalid and Unusable Objects
• Managing Memory Components

Backup and Recovery Concepts

• Understanding Instance Recovery
• Statement Failure
• Phases of Instance Recovery
• Archive Log Files
• Media Failure
• Part of Your Job
• User Error
• Using the MTTR Advisor

Performing Database Backups

• Backup Solutions: Overview
• Monitoring the Flash Recovery Area
• Recovery Manager (RMAN)
• Terminology
• Configuring Backup Settings
• Backing Up the Control File to a Trace File
• User-Manage d Backup
• Oracle Secure Backup

Performing Database Recovery

• Opening a Database
• Data Recovery Advisor Views
• Data Recovery Advisor
• Loss of a Control File
• Data Failures
• Loss of a Redo Log File
• Listing Data Failures

Moving Data

• Use SQL*Loader to move data
• Use external tables to move data
• Describe ways to move data
• Create and use directory objects
• Use Data Pump export and import to move data
• General architecture of Oracle Data Pump

Working with Support

• Use the Enterprise Manager Support Workbench
• Manage patches
• Work with Oracle Support
• Log service requests (SR)