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