Data Intellect DBA

Oracle DBA Training

In Oracle Database Administration course you will learn how to perform all activities related to maintaining a successful database environment.  Typically a DBA responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use.

Oracle DBA Training at Data Intellect has been designed as per latest industry trends and keeping in mind the advanced Oracle DBA course content and syllabus based on the professional requirement of the student; helping them to get placement in Multinational companies and achieve their career goals.

Solid Knowledge in SQL and PL/SQL is a pre-requisite for this course.

This course will cover:

Introduction to Database

Different type of Database
Popular database management system (DBMS) software and why Oracle DBMS.
History and Current trends of DBMS and Database Administration.
Oracle database market share and about its current competitive landscape.
Tasks of a Database Administrator.
Career as a Oracle Database Administrator
Oracle Certification for DBA

Oracle Enterprise Architecture

Oracle Database
Connecting to a Server
Oracle Database Server Architecture: Overview
Instance: Database Configurations
Connecting to the Database Instance
Oracle Database Memory Structures
Shared Pool
Database Buffer Cache
Redo Log Buffer
Large Pool
Java Pool and Streams Pool
Program Global Area (PGA)
Process Architecture
Process Structures
Database Writer Process (DBWn)
Log Writer Process (LGWR)
Checkpoint Process (CKPT)
System Monitor Process (SMON)
Process Monitor Process (PMON)
Recoverer Process
Archiver Processes (ARCn)
Process Startup Sequence
Database Storage Architecture
Logical and Physical Database Structures
Oracle Database, Control files,
Redo log files, data files, Oracle Server.

Installation

Identify system requirements
The optimal flexible architecture (ofa)
Identify system requirements
Download Required software
Installing VMware
Installing Linux
Installing oracle Database
installing Putty
Installing Xmin (windows X)
Installing SQL Developer
Establish Client Server configuration

Creating an oracle database
Create a new database
Configure an existing database
Drop a database
Manage dbca templates
Manually create a database

Managing the database instance

starting & stopping database control
starting & stopping the database listener
starting & stopping the database instance
more about the database files
Using SQL*Plus
Calling a SQL *Plus script
Calling SQL *Plus from a Shell script

Oracle Networking

Oracle Net Services
Oracle Net Listener
Establishing Net Connections
Establishing a Connection
User Sessions
Tools for Configuring and Managing the Oracle Network
Listener Control Utility
Listener Control Utility Syntax
Using SRVCTL to Start and Stop the Listener
Listener Home Page
Net Services Administration Page
Creating a Listener
Adding Listener Addresses
Naming Methods
Easy Connect
Local Naming
Directory Naming
External Naming Method
Configuring Service Aliases
Advanced Connection Options
Testing Oracle Net Connectivity
User Sessions: Dedicated Server Process
User Sessions: Shared Server Processes
Configuring Communication Between Databases
Connecting to Another Database

Manage database storage structures 

Tablespaces
How Table Data Is Stored
Database Block: Contents
Explonng the Storage Structure
Creating a New Tablespace
Storage for Tablespaces
Tablespaces in the Preconfigured Database
Altering a Tablespace
Actions with Tablespaces
Dropping Tablespaces
Viewing Tablespace Information
Viewing Tablespace Contents
Oracle-Managed Files (OMF)
Enlarging the Database

Managing undo data

about undo space management
configure automatic undo management
undo_management
undo_tablespace
undo_retention
guarantee undo retention
monitor undo space
use the undo advisor

Administering user security

create & manage database accounts
grant & revoke database privileges
resource limits via profiles
alter profile
drop profile
password management via profiles
about role-based security
with admin option
alter user…default role
set role
enhanced default security settings

Moving data

Sql loader
loader concepts
control file options
load methods
using the em interface

Export & import
manage directory objects
about the data pump architecture
data pump export
data pump import
data pump data dictionary views
using the em interface

Database maintenance & performance management

the management & advisory framework
manage the automatic workload repository
automatic database diagnostic monitor
use metrics & alert thresholds
automatic maintenance tasks

Managing concurrency & locks
about latches & locks
manage & monitor latches
manage & monitor locks
v$lock
v$locked_object
v$session
v$session_wait
dba_blockers & dba_waiters
dba_dml_locks & dba_ddl_locks
dml_locks

User Management

Type of users,
creating database users,
Authentication methods (local authentication, OS authentication, network authentication).
Managing privileges and different types of privileges such as object level privileges and system level privileges.
Using Roles for privilege management,
Identifying assigned privileges using views for a given user.
Understanding profiles and implementing profiles.

UNDO Management

button Understanding UNDO tablespace features like read consistency,
rollback operations,
flashback options such as flashback query,
flashback version query,
flash back transaction query,
flashback database,
flashback data archive.
Setting up FRA area and the purpose.
Rollback segments, Pending offline status.
Retention policy,
Retention guarantee,
sizing UNDO tablespaces,
addressing ORA-01555 snapshot too old issues.

Backup and Database Patching procedures

Backup procedures provided by Oracle,
Logical backups and purpose,
Physical backup’s architecture,
understanding complete recovery vs. incomplete recovery,
online recovery vs. offline recovery.
Purpose of cold backup.
HOT backups architecture.
Restore database
button RMAN architecture and best practices in corporate world.
Different types of recoveries such as complete recovery,
incomplete recovery, online recovery and
offline recovery. Dynamics of recoveries. Recovery Manager Backups (RMAN),
RAMN setup and configuration, with catalog or out catalog. Corporate standards for RMAN backups.
Catalog database, Target databases and Auxiliary databases.
Performing backups and recoveries using all the methods (logical, physical and RMAN).
RMAN Command reference such as list, report, delete etc.
Database cloning using RMAN with database duplication as industry standard.

ASM

ASM (Automated storage management) concepts.
Different storage options for database files like file system files,
RAW partitions,
OMF and ASM. ASM architecture,
background processes, creating disk groups,
mounting disk groups.
Using ASMCMD and asmca GUI tool to manage ASM instances.
Grid Infrastructure software installation and configuring ASM for standalone database for its storage.

DATA GUARD

button Purpose of Data Guard, Architecture,
Physical Standby database setup,
Active data guard features.
Various protection modes such as Max Performance, Max Availability and Max Protection.

Performance Tuning

Best practices, requirements, different levels of performance tuning.
Sharing real world personal experiences on tuning techniques.
OS level base line statistics, database level maintenance methods with best practices,
database level statistics, indexes,
optimization methods, Row chaining and migration, DOP (parallelism),
monitoring and configuring parallelism related parameters.
Explain plans; enabling trace at session level understanding performance statistics during tracing.
Understanding TKPROF output.
Memory tuning, Automated shared memory management (SGA, SGA+PGA),
different types of caches for performance improvement such as keep cache,
recycle cache and result cache.

Oracle database upgrades

Introduction to Oracle versions and how to understand a version.
How to upgrade from a previous release to Oracle 12c.
How to upgrade from one patchset to another patchset within a release. What is slip-streaming ?
What are one-off/interim patches.
What are quarterly CPU patches (Cumulative Patch Updates).
Learn about Oracle Interim Patch Installer (OPATCH).
Upgrade a database using dbua (database upgrade assistant) GUI tool.