Oracle 18c and Dataguard setup on premises and oracle Cloud
What you'll learn
- Able to setup Oracle 18c test lab for Oracle OCM certification including Understand the concepts of Oracle Data Guard architecture on cloud &on priem
- ODG
- 19c
- Lab Setup
Requirements
- I assume the audience have the basic knowledge of the Oracle Database Administration fundamentals. We do not expect you to be an expert DBA
- oracle ODG
- Failover
- Failback
Description
My name is Zulqarnain Hayat and welcome to my learning course for Oracle 18C . This course have two major parts First one is Oracle 18C lab setup and Oracle data guard on Premises and Oracle cloud with Hands-on experience. And second part is Oracle cloud 18C database on cloud we cover oracle database as service and Oracle Data-guard setup on cloud using free trial account including Administration tasks like switch over, fail over, and snapshot standby step by step . This course will covers with following contents.
Section-1 Oracle 18C lab environment hands-on
Download Software
Configure Virtual Machine and Install Oracle Linux 7
OS Configuration for Oracle 18C
Copy and install Oracle 18c
Configure LISTENER
DBCA generate scripts to create database
Connecting to Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 18c
Section -2 Oracle Data-Guard LAB Setup on Oracle 18c
Install Oracle 18C
OS configuration for Oracle 18C
Clone second node
Setup Data-Guard on premises
Section -3 Oracle Cloud Database as a Service (DBaaS)
Create free account for one month on oracle cloud
Create service
Generating an SSH Key Pair On Windows Using the PuTTY Key Generator
Logging in to your instance using ssh from windows
Section-4- Oracle Cloud Infrastructure (OCI)
Create a Compartment
Create a Virtual Cloud Network (VCN)
Create a Database VM
section-5 Oracle 18c- Configure Data Guard On Oracle Cloud Service
Oracle 18c Configure Data Guard On Oracle Cloud Service
Database Switch-over
Database Fail-over
Snapshot Standby database
Who this course is for:
- This course is designed for Oracle Database Administrators and Oracle developer or who want to do preparation to complete Oracle certification
- who would like to use Oracle 18c and Oracle Data Guard on premises or on Oracle Cloud .
- Lab Setup
Instructor
I have done Master in Computer science (IT) and additionally I have more than 17 years of professional experience UNIX administration, Oracle database administration with different flavors (Solaris, Linux, Oracle Linux, Red Hat) and working as role Database specialist.I have completed command over following functions and skills.
Key Skills:
· Oracle Database Administration
· MS SQL Server Administrations
· MYSQL/MariaDB Administration
· Sun Solaris Administration (Certified)
· Linux Administration (Red Hat ,CENTOS,UBUNTU)
· Oracle Application Server Administration
· Banner UDC technology stack DBA track
· Application Administration (LAMP,LEMP)
· Oracle EBS Administration
· Oracle Database Administration (RAC, Data Guard)
· Oracle Business Intelligence Administration
· Hyperion /ESBASE/WEB LOGIC
· Windows Server Administration
· Oracle Data Warehouse Builder
· SQL Server Administration
· Project Management
· Problem solving skills and approach
· Systems audit and control
· Oracle OAM 11G,OSSO 10G EBS R12
· Data Center Design and Implementation
· VMware Infrastructure
· EMC Storage and Legato Networker Administration