ORACLE DBA
Download
1 / 4

Oracle DBA Training in Hyderabad - PowerPoint PPT Presentation


orienit is the best Oracle DBA((Oracle Database Administrator)) Training institutes in Hyderabad.We Providing Oracle DBA Training by real time faculty in hyderabad.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

Download Presentation

Oracle DBA Training in Hyderabad

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


ORACLE DBA

Introduction

?

What is DBA?

? Why a Company needs a DBA?

? Roles & Responsibilities of DBA

? Identify the oracle product

? Oracle Architecture

? Physical and Logical Phase of Database

Installing oracle database 11g software

? System requirements.

? Redhat Linux Installation

? Install software with the Oracle Universal Installer on Linux Platform

? Identify System Requirements

? Optimal Flexible Architecture (OFA)

? Discuss Oracle Base

? Discuss Oracle Home

? Configure Ms Windows Installation

? Prerequisite Checks and Fixup Utility

Exploring The Oracle DatabaseArchitecture: General

? More About Database Instances

? What is Instance and SGA

? General Database Architecture

? Instance Background Processes

? Discuss about New Feature Parameters

? About PGA and Server Process

Exploring The Oracle Database Physical Architecture:

? Discuss about Control files

? How to manage the Control files

? Multiplexing the Control files

? Multiplexing the online redo log files

? Brief about online redo log files.

? More About Datafiles concepts

? Brief About Parameter files

? Discuss about Password files.

? How to create spfile and pfile

? What is spfile?

? Difference between spfile and pfile

Create an oracle database

? Database Configuration Assistant(DBCA)

? Create A New Database

? Configure An Existing Database

? Drop A Database

? Manually Create A Database

? More About The Database Files

Manually Starting and Stopping Database Services

? Starting and Stopping Database Control

? Different Startup Modes

? Different Shutdown Modes

? Starting and Stopping The Listener

? Sysdba

#204, 2nd Floor, Annapurna Block, Aditya Enclave, Ameerpet, Hyderabad.

Ph: 040 6514 2345, 970 320 2345. E-mail: info@orienit.com www.orienit.com


Manage Database Storage Structures: Tablespaces

?

What are segments?

? What are extents?

? What is Blocks?

? Estimation of Extents

? Dictionary Managed Table space

? Locally Managed Table space

? About Tablespaces

? Tablespace Management

? Autoextend Options

? Drop Tablespace

? Alter Tablespace

? Tablespace Encryption

Manage Database Storage Structures: Advanced Tablespaces

? More About Temporary Tablespaces

? Using V$Sort_Segment

? About Temporary Tablespace Groups

? Temporary Groups

? More About Permanent Tablespaces

? About Database_Properties

? More About Bigfile Tablespaces

? More About The Sysaux Tablespace

Manage Database Storage Structures:

? Managing Data Files

? Managing Temp Files

? Enable Oracle-Managed Files (OMF)

? Renaming a data file

? Temporary Groups

Managing Undo Data

? About Undo Space Management

? Configure Undo Management

? Undo_Management

? Undo_Tablespace

? Undo_Retention

? Guarantee Undo Retention

? Monitor Undo Space

? Use The Undo Advisor

Security: Administering User Security

? Create and manage database user accounts

? Create and manage roles

? Grant and revoke privileges

? Control resource usage by using Profiles

? Auditing Of Database Activity

? Audit_Trail Parameter

? Enhanced Default Security Settings

? Create and Manage Database Accounts

? Grant and Revoke Database Privileges

? Resource Limits Via Profiles

? Alter Profile

? Drop Profile

? Password Management Via Profiles

#204, 2nd Floor, Annapurna Block, Aditya Enclave, Ameerpet, Hyderabad.

Ph: 040 6514 2345, 970 320 2345. E-mail: info@orienit.com www.orienit.com


? About Role-Based Security

? With Admin Option

? With Admin Option and System Privileges

? With Grant Option and Object Privileges

? Alter User...Default Role

? Set Role

? Enhanced Default Security Settings

? Sec_Case_Sensitive_Logon Setting

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

? Start and stop Listener concepts

? Listener.ora

? Tnsnames.ora

? Concept about Database Links

? Use the Oracle Net Manager to configure client and middle-tier connection

? Use TNSPING to test Oracle Net connectivity

Create indexes and views Logical Backup & Restore

? 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

? Discuss New features concept 11g

Oracle Backup & Recovery (User Managed)

? Introduction

? Design, Testing, Implementation Strategies

? Offline(cold)/Online(hot) backups

? Performing Complete Recovery

? Performing Incomplete Recovery

Oracle Backup & Recovery (System Managed: RMAN)

? Introduction

? RMAN Architecture & Rman commands

? Configuration

? Setting up Catalog

? Online/Offline Backup using RMAN

? Backups Options

? Incremental Backups,

? Scripts,

? Complete Recovery

? Incomplete Recovery

? Table Space Point in Time Recovery (TSPITR)

? Disaster Recovery

? Recovery of Corrupted DB-Blocks

? RMAN 11g new features

Cloning & Refresh

? Database Refresh Using RMAN

? Database refresh Using Manual

? DB refresh Using Expdp and Empdp

? Migration Using Expdp and Impdp

? Migration Using Rman

#204, 2nd Floor, Annapurna Block, Aditya Enclave, Ameerpet, Hyderabad.

Ph: 040 6514 2345, 970 320 2345. E-mail: info@orienit.com www.orienit.com


Flashback Database Concept

?

Introduction

? Configuration

? Flashback Query/Table/Drop/Database

? Flashback Version Query

? Creating Restore Points

? Flashback Archive(11g)

Patching Activity

? Database Patch Management Introduction

? Applying Interim and Patch set Patches

? Patch History & Documentation

Data Guard Concept

? Introduction

? Architecture

? Configuring Standby database

? Types of Standby databases

? Performing Switch Over and Fail Over

? Monitoring & Troubleshooting

? 11g New features in Data Guard

? Types of Protection modes

? Active standby/snapshot standby(11g)

Automatic Storage Management

? Basic Automatic Storage Management Concepts

? Disk Groups

? Automatic Storage Management Files

? Automatic Storage Management Templates

? Automatic Storage Management Disks

? Failure Groups

? Automatic Storage Management Instances

? Benefits of Using Automatic Storage Management

Oracle Performance Tuning

? Why Tuning required?

? Types of Tuning

? Proactive Vs Reactive Tuning

? Tuning through effective DB Configurations

? Health Management/Periodical Checkup

? DB Defragmentation

? Database Tuning

Highlights of the Course

? Application Tuning

? Oracle installation process

? SQL Tuning

? Patching Activity

? Memory Tuning

? Upgradation Process

? Network Tuning

? Migration Process

? Partitioning and Indexes

? Rman Refresh & cloning Process

? Tuning Memory, Disk I/O

? Resume Preparation

? AWR/ASH/ASMM/ADDM

? Dataguard scenario

? Resource Intensive SQL

? Performance Tunning Troubleshoot

? Managing the DB Statistics ( for CBO)

? Project related scenario.

? Managing the AWR Snapshots

? Real time scenario.

? Generating/ Interpreting the AWR Report

Oracle Grid Control

? Introduction

? Architecture

? Installation & Configuration

? Managing the multiple database nodes using OEM grid control

#204, 2nd Floor, Annapurna Block, Aditya Enclave, Ameerpet, Hyderabad.

Ph: 040 6514 2345, 970 320 2345. E-mail: info@orienit.com www.orienit.com


ad
  • Login