Users Online

· Guests Online: 63

· Members Online: 0

· Total Members: 188
· Newest Member: meenachowdary055

Forum Threads

Newest Threads
No Threads created
Hottest Threads
No Threads created

Latest Articles

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

by Kishan


18_026 - PDB connection scenario



Oracle Dba 19c -learn Real Time Scenarios Using Simulation

 

 

Oracle administration

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?This 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: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

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

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

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

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

      
Course Contents
01 - Introduction 02 - Database installation using DBCA 03 - Database Basic healthchecks 04 - Diagnostics practice 05 - Create a sample table with million rows for practice 06 - Monitoring database generally as a DBA 07 - FRA housekeeping 08 - Managing processes sessions and transactions effectively 9 - Undo management 10 - Project scenario Basic database down and start during OS patching 11 - Project scenario Ensure backup during application activity 12 - Mount point full 13 - Statistics collection basics 14 - User access scenarios 15 - Temporary tablespace scenario 16 - Tablespace issues when disk is full 17 - Database decommission request 18 - PDB scenarios 19 - Diagnose ORA006007445 internal errors 20 - Simulate corruption 21 - Data refresh activities

Comments

No Comments have been Posted.

Post Comment

Please Login to Post a Comment.

Ratings

Rating is available to Members only.

Please login or register to vote.

No Ratings have been Posted.
Render time: 0.74 seconds
10,270,502 unique visits