Foundation for Oracle Database Administrator (DBA)

Rating 4.05 out of 5 (88 ratings in Udemy)

What you'll learn

How to setup Oracle Database 12C Environment on your Laptop or Desktop computer
How to install oracle virtual box on Labtop or Desktop step by step instruction
How to install oracle Linux 7.3 as guest operating system step by step instruction
How to install Oracle 12c on oracle Linux 7.3 step by step hands on
How to stop and start oracle 12c database
How to use advance level database tools like ADRCI for DBA
Learn about CDB …

Rating 4.05 out of 5 (88 ratings in Udemy)

What you'll learn

How to setup Oracle Database 12C Environment on your Laptop or Desktop computer
How to install oracle virtual box on Labtop or Desktop step by step instruction
How to install oracle Linux 7.3 as guest operating system step by step instruction
How to install Oracle 12c on oracle Linux 7.3 step by step hands on
How to stop and start oracle 12c database
How to use advance level database tools like ADRCI for DBA
Learn about CDB and PDB database and switch over from root container to pluggable container databases

Description

Oracle is among the world's most complex and sophisticated databases, and mastering this complex set ofcomputer programs requires many skills. Learning Oracle is only appropriate for experienced professionals withappropriate prerequisite training.I was interviewing a few candidates which had OCP in their resume but even though they had good theoretical knowledge but lack in hands-on. One of the candidate frankly told me that without job how to get hands on. And this course is the answer to his valid question. In this course we will also learn very useful tool which help DBA to identify they issue and how to escalate issue to Oracle support.
Oracle 12C Architecture internal (Slides)
Oracle 12C Memory Internal (Slides)

======

QUICK REVIEW VERYUseful for DBA

Install oracle 18c Demo

Install Oracle enterprise manager(OEM) in steps Demo

Oracle Migration from Non-RAC to RAC database Demo

Oracle Database clone in RAC enviroment Demo

Convert oracle database from windows to Linux Demo

Duplicate Oracle Database using RMAN Demo

=========================================

Oracle Database 19c installation in Oracle Linux 7

Action Plan:

1. Preparing the Oracle Linux 7.6 Operating System for Database 19c installation.

2. Virtual Box Settings for Oracle Linux 7 VM.

3. Setting the static ip address

4. kernel parameters configuration

5. Resource limit configuration and stopping the Firewall

6. dependencies installation

7. oracle database installation

8. Host name configuration for Oracle Linux VM.

9. Oracle listener configuration after installation.

10. Starting the Database in SQL Plus

11. Create one Common user called "scott"

12. SQL Developer 19.1 Connectivity with Oracle database 19c

13. Mounting the pluggable database orclpdb and check connectivity on SQL Developer.

14. Access the Oracle Enterprise Manager on host machine browser.

Duration 5 Hours 58 Minutes

Paid

Self paced

All Levels

English (US)

16872

Rating 4.05 out of 5 (88 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.