Oracle Dba 19C -Learn Real Time Scenarios

Oracle 19c Administration and Simulation

What you'll learn

Learners can be able to get hands on experience on Oracle database administration

Learners get confidence to face real time scenarios

Learners can apply the techniques in their workplace

Learners can get a broader understanding of Oracle Administration

Requirements

A laptop with good specifications and Internet connection

Description

Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?If you are looking for a structured course explaining "what is what" all the time, then this course is not for you.This course is for those who are really interested in technical content and learning with illustrationsThis course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: VM Configuration

Lecture 2 Software to be installed

Section 3: OEL 8.2 Installation and Configuration

Lecture 3 Oracle Linux 8.2 Installation and Network Configuration

Lecture 4 Initial Configuration

Section 4: Oracle Database Software Installation

Lecture 5 Oracle Database Software

Section 5: Database installation using DBCA

Lecture 6 Database installation

Lecture 7 Listener creation

Lecture 8 Connect to database

Section 6: Oracle Architecture

Lecture 9 High Level Architecture

Section 7: Database Startup and Shutdown Modes

Lecture 10 Startup Stages, Pfile and SPfile concepts

Section 8: DB_FILE_MULTI_BLOCK_READ_COUNT

Lecture 11 Scattered reads

Section 9: Database Basic healthchecks

Lecture 12 Database health checks

Section 10: Diagnostics practice

Lecture 13 Identify the alertlog and tracefiles

Section 11: Create a sample table with million rows for practice

Lecture 14 Create sample table

Section 12: Monitoring database generally as a DBA

Lecture 15 Monitor a session

Lecture 16 Identify Long sessions

Lecture 17 Why and When to use session longops?

Lecture 18 Identify session that i am connected to

Lecture 19 Project scenario - Kill sessions

Lecture 20 Kill a single application specific session

Lecture 21 Kill resource hogging processes

Lecture 22 Map OS process to database

Lecture 23 Who has blocked my session?

Lecture 24 Identify the software edition in an Oracle Home

Lecture 25 Identify SQL Command Type

Lecture 26 Identify Session Accessing An Object

Section 13: FRA housekeeping

Lecture 27 FRA space issues

Section 14: Managing processes, sessions and transactions effectively

Lecture 28 Calculate optimal processes, sessions and transactions

Lecture 29 Simulate processes exceed error

Lecture 30 Handling Inactive Sessions

Section 15: OPEN CURSOR

Lecture 31 Why cursors exceed in database?

Section 16: Undo management

Lecture 32 Undo management demonstration

Lecture 33 Undo errors and face them

Lecture 34 Undo solution

Section 17: Project scenario - Basic database down and start during OS patching

Lecture 35 DBA coordination for OS patching

Section 18: Project scenario - Ensure backup during application activity

Lecture 36 Ensure backups

Section 19: Mount point full

Lecture 37 Database mount point full scenario

Section 20: Statistics collection basics

Lecture 38 Statistics theory

Lecture 39 Optimizer statistics for table

Lecture 40 Statistics issues scenario

Lecture 41 Statistics Staleness Mystery

Section 21: User access scenarios

Lecture 42 Grant access for existing user

Section 22: Temporary tablespace scenario

Lecture 43 Temp tablespace growth

Lecture 44 Sorting with multiple queries in Temp tablespace

Lecture 45 Temp usage history

Section 23: Tablespace issues when disk is full

Lecture 46 Tablespace issues when disk is full

Section 24: Database decommission request

Lecture 47 Decommission a database

Section 25: PDB scenarios

Lecture 48 PDB connection scenario

Lecture 49 Connect to PDB and identify current connected container

Lecture 50 Application connectivity issues to PDB after activity

Lecture 51 Save PDB states

Section 26: Diagnose ORA-00600/7445 internal errors

Lecture 52 Oracle internal error scenario

Lecture 53 Error lookup

Section 27: BONUS: Oracle Enterprise Manager

Lecture 54 Real time monitoring tool for mission critical database system(OEM 13.5)

Lecture 55 Post Installation Steps

Lecture 56 Download Agent Software

Lecture 57 Configure Registration Password

Lecture 58 Deploy agent in target host

Lecture 59 Target addition in OEM

Section 28: Patching

Lecture 60 Database Patching

Lecture 61 Check for availability of RU's for 19c

Lecture 62 RU Patching Scenario

Lecture 63 RU Patching for 19c- Practical 1

Lecture 64 RU Patching for 19c - Practical 2

Lecture 65 RU Patching Post Patch steps

Section 29: Simulate corruption

Lecture 66 Simulate logical corruption

Section 30: Data refresh activities

Lecture 67 Instant Data Copy Using DBLINK

Lecture 68 Table refresh 1

Lecture 69 Table refresh 2

Section 31: High CPU diagnosis scenario

Lecture 70 What will you do if CPU usage is consistently high?

Section 32: Automatic Maintenance

Lecture 71 Automatic Maintenance Plan

Lecture 72 Manage Auto jobs

Section 33: Memory management in database

Lecture 73 AMM calculation part 1

Lecture 74 AMM part 2

Section 34: Catalog your backup/recovery

Lecture 75 Catalog backup/recovery

Lecture 76 Registered databases in catalog

Section 35: Automatic Diagnostic Repository

Lecture 77 ADRCI

Lecture 78 Create and Generate Incident Package

Section 36: Change database name

Lecture 79 Database name change

Oracle DBA